Troubleshooting:Consolidate Financial Report - Cannot set column “LiveDBDatabaseName”

From AutoCount Resource Center

Question: When I attach account book for Consolidate Financial Report, error message prompted: "Cannot set column "LiveDBDatabaseName,". The value violates the Maxlength limit of this column".

Version: 1.8 / 1.9 / 2.0

Cfr length.png

Possible Reason:

The length of database name exceeds maximum length of 20 characters.

Cfr length1.png


1. Login to Microsoft SQL Server Management Studio to edit the length of Database Name (it should be within 20 alphanumeric).

2. Backup and restore the database and make sure the length of database name is within 20 alphanumeric.

By: Evelyn 170728, KM 170731; P170808

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations