|Acrolinx Server||All versions|
|Microsoft SQL Server||All supported versions|
When importing terminology or restoring a database backup, the import operation is unexpectedly terminated with a "stack trace" error. When users review the core server log file for the cause of the error, the server reports that the "The total size of an index or primary key cannot exceed 900 bytes"
This issue can frequently occur when importing terms that contain multi-byte characters that are typically found in non-European character sets. When using an MS SQL database to store terminology, the storage capacity for the term name is restricted to 900 bytes. When this limit is exceeded, the Microsoft SQL Server returns this error message .
Resolving the Problem
Ensure that your import file does not contain term names that exceed 900 bytes or move to a database format that is more suitable for storing long term names that include multi-byte characters.