Error: Unable to load data list. Unclosed quotation mark after the character string 'ED85990C-95A9'. Incorrect syntax near 'ED85990C-95A9'.

When attempting to inactivate a value on an attribute code table, the following error is displayed:

"Unable to load data list. Unclosed quotation mark after the character string 'ED85990C-95A9'. Incorrect syntax near 'ED85990C-95A"

T
he error appears to come from the length of the amount of characters used in a code table name. Name used: "Caseatons new codetable to testissues withlength123" which is 51 characters long with spaces, 46 without spaces.

We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1. Add a new attribute category with data type of code table - use name above for Name of attribute
2. Add a new code table by clicking on the add button- use the same long name
3. Click save on both the add code table and add an attribute category and navigate to code table
4. Click add to add in a value to the code table, the value appears correctly in the code table datalist
5. Add a 2nd value to the code table datalist
6. Click Edit on Test Value 1- mark the value as inactive, click Ok and Error appears

Environment

 Blackbaud CRM
 4.0
 4.0.163

Was this article helpful?