Acctivate Database Backup Prompt

In newer versions of Acctivate, there is a prompt upon exiting the application to create a backup if a SQL backup has not been run in the last 7 days. This prompt will show for all users until the backup

Posted in Database, Technology

Restore Acctivate Database in SQL Server Management Studio

If you are unable to restore your database file in AcctivateDBMaint or you are wanting to restore it to a different location than where Acctivate is installed then you may want to use SQL Server Management Studio to restore it.

Posted in Database

“Cannot Open Databases for Company…” on CYMA workstation

Cannot open databases for company _________. This error comes from the configuration of PSQL in the Acctivate sources. First you need to know if you are using a PSQL Server license or a PSQL Workgroup license to run CYMA with.

Posted in Database

Can’t Find Voided Transactions?

Unlike voided invoices or canceled orders, voided transfers, receipts, or other transactions voided through the Void Inventory Session tool are not able to be recalled and viewed again after being voided. This can understandably be confusing for users at times.

Posted in Database, Inventory

Database Backup File Is Much Larger Than Database

When creating a backup within Acctivate, users have two options. They can either create a standard backup by just clicking “Start Backup” or they can check the “Overwrite existing sets” box. If a user chooses not to check this box,

Posted in Database

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=, 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
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.