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


Possible Reason:

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



Solution:

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 & 2.1


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations