Summary

When you select multiple documents and attempt to change field values for all the selected documents you may receive the following error message:

The parameter is out of range or too long. [9020]

Cause

This issue affects repositories with the following characteristics:

• The repository was migrated from Laserfiche 7.2
• The Laserfiche 7.2 repository contained documents with assigned fields that have empty values.
• Once migrated to Laserfiche 8, you modify those field definitions to support multiple values.

During the migration process, the migration wizard does not create rows with null values for those fields with empty values. If you then allow these fields to have multiple values, the Laserfiche 8 client does not correctly handle changing the field values if you select multiple documents with the affected field and attempt to simultaneously change the field values for all the selected documents.

Workaround

Please download the following zip file containing a SQL script file.

SCR53292.zip

Note: Please stop the Laserfiche Server before running the script.

The script file contains the following INSERT statement.

insert into propval (tocid, prop_id, pos) select t.tocid, psp.prop_id, 0 from toc t join pset_props psp on t.pset_id = psp.pset_id where not exists (select * from propval pv where pv.tocid = t.tocid and pv.prop_id = psp.prop_id)