Summary

When you attempt to copy or move a document with a template that contains fields such that the total length of all the field names exceeds 2000 characters, you may receive the following error message:

Error executing SQL command [7050].

In your repository's error.log file, you may see entries similar to the following:

[7050] Copy document failed (tocid=x, volid=y, destid=z): Unclosed quotation mark before the character string 'partial field name'.

Resolution

There is a hotfix available for Laserfiche Server 7.2.1. The fix is a SQL script that updates a stored procedure to increase a variable limit to 4000 characters.

To update your Laserfiche Server

1. Click the following link to download a zip file containing the hotfix file.
   Hotfix_SCR32531.zip
2. Extract 32531.sql to a temporary location.
3. Run the 32531.sql script on your SQL database.
   1. Click Start and then click Run.
   2. In the Run dialog box, type the following and then click OK to run the script.

      osql -E -S SQLServerInstance -d "DatabaseName" -i "PathTo32531.sql"

      SQLInstance is the name of your SQL Server instance name.

      DatabaseName is the name of the main SQL database associated with your Laserfiche repository.

      PathTo32531.sql is the full path (including the file name and extension) to the extracted 32531.sql file.