Open main menu

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".


Cfr length.png


Possible Reason:

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


Cfr length1.png


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