How can I restrict very long strings in DnB mapping when it surpasses the maximum attribute value size limit?

Question

We are creating organization failure for a few records in Reltio while we are clicking the Get Company Details Buttons for enrichment. We get the following error.

Answer

• Check the development tools for any error messages produced
• Check LogDNA for any error message produced. If  you see the following type of message 

Aug 22 14:44:23dnb-connector-5dbcf55578-6lh5ndnb-connectorERROR{"event":"org_create","context":{"entityUri":"entities/20EsHix","tenantId":"<tenantID>","environment":"361","operationType":"enrichment_plus","operationId":"a0fe1b09-55b9-41b6-a353-815d0aa0dc38","username":"dnb.connector","dnbUsername":"75qIo5RN1rhQV1UgPKUGUgBYFUobGpE6"},"additionalFields":{"dunsnumber":"093120871","index":0,"error":"Maximum attribute value size limit (10240) exceeded for attribute configuration/entityTypes/DNBCompany/attributes/Summary/attributes/Text, object URI (for existing objects) entities/20EsHix.: Maximum attribute value size limit (10240 characters) exceeded for attribute configuration/entityTypes/DNBCompany/attributes/Summary/attributes/Text, object URI (for existing objects) entities/20EsHix. Reduce size of attribute value or contact support to increase the limit.","uri":"entities/20EsHix"}}

• The attribute value can be truncated using the sub-string function in the mapping.

• Example of test in Jolt demo

Input Test

{
"people": [
{
"name1": "Bob Smith"
}
]
}

Mapping

[
{
"operation": "modify-default-beta",
"spec": {
"people": {
"*": {
"name": "=substring(@(1,name1),0,5)"
}
}
}
}
]

Output

{
"people" : [ {
"name1" : "Bob Smith",
"name" : "Bob S"
} ]
}

Note: It would be best to put the modify-overwrite-beta operations before any shift operations. 

Modify First, Then Shift: 

Modifying fields before restructuring ensures data integrity and avoids reference issues