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…
Articles
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.…
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=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
