Salesforce Connector Activity: Remote CRM: Field Import Issue in WORKFLOW

Avatar

Avatar

Shane0806

Avatar

Shane0806

Shane0806

22-01-2021

We are trying to fetch one field along with other existing fields via import workflow from Salesforce. 

Field Name: “Word1 word2 word3 word4” causing an issue when we try to fetch under the CRM level activity in the Adobe Campaign.

 

Error:

crmConnectorDataMgt2 ORA-210000 Oracle error: ORA-00972: identifier is too long

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

craigthonis

Employee

Avatar

craigthonis

Employee

craigthonis
Employee

25-01-2021

Hi Shane,

 

Can you check the field and let us know the type and how many characters it's configured for?  The error seems to indicate that your identifier is way to long. 

Answers (1)

Answers (1)

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

25-01-2021

Hi @Shane0806,

Oracle has 30 character limit by default. However, since 12.2 version, the maximum length of most identifiers is increased on 128 bytes.

If you are able, try to extend schema for this field on higher length. If not, set a function to cut string longer than 30 characters or plan database upgrade.

Regards,

Milan