Articles

Permission denied error running database update

After installing an Acctivate update, a user will need to log into each Acctivate company file and upgrade the database.  In certain cases, a user may receive the error, below, when upgrading the company database. Error running database update:  User does not

Posted in Configuration, Database

Not enough storage is available to process this command

Users may receive the exception, below, when loading large quantities of records, posting large transactions or importing large amounts of data. Could not load file or assembly ‘System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ or one of its dependencies. Not enough storage is available

Posted in Database

List of Acctivate Database Maintenance commands

Acctivate Database Maintenance supports backing up and upgrading company files from a command line.  Here is the list of commands and the available arguments, below, with links to find out more about how each of these is used in further

Posted in Database

Upgrade Acctivate database from a command line

After installing a new Acctivate update, each company file will typically require a database upgrade.  Typically, users are prompted to start a database upgrade the first time a user logs into Acctivate after the installation of the update completes.  However,

Posted in Database, Installation

Acctivate database connections with CYMA

Due to some recent changes in newer versions of CYMA (CYMA 15+), Acctivate for CYMA users have reported some conflicts in how Acctivate connects with CYMA and how CYMA reports are configured. Starting in Acctivate 10.2sp1, Acctivate now creates a Pervasive.SQL

Posted in Database

Using Remote App with Acctivate

RemoteApp enables you to make programs that are accessed remotely through Remote Desktop Services appear as if they are running on the end user’s local computer. This application can be used to provide Acctivate to remote users as well. If

Posted in Database, Getting Started, Launch Acctivate, Uncategorized

Send Database Copy to Acctivate Support

From time to time, Acctivate Support may encounter an issue that cannot be replicated in the Demo company, and may require a copy of the database with the issue for testing. This article shows how to create that backup and

Posted in Database

Create a View using SSMS Query Designer

When you install SQL Server Management Studio, it comes with a lot of very helpful database tools. The Query Designer is a way to build Select statements that can then be placed into custom views in your database. These views

Posted in Database, Technology

Locating the Server with Acctivate’s Active Database

When using more than one server, there may come a time when Acctivate’s database is copied from one server to another one. This is especially true if you have undergone a server migration at some point in the past. While

Posted in Database, Installation, Technology

Anti-Virus realtime scanning causes performance issues

Acctivate users may experience performance issues if their anti-virus uses a realtime scanning function.  Realtime scanning may constantly scan all SQL Server activity, which can be an extensive amount of data flowing between the Acctivate server and the workstations.  This can

Posted in Database, Installation, Technology
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.