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

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

  AutoCount Accounting 2.0

  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS

  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations