Skip to main content
RoystonPr
Level 3
Jan 22, 2021 1:49 PM UTC
Solved

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

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Craig_Thonis
Craig_ThonisAccepted solution
Adobe Employee
Jan 25, 2021 2:12 PM UTC

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. 

View in thread

5 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
Jan 25, 2021 2:12 PM UTC

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. 

Translate
RoystonPrAuthor
Level 3
Jan 27, 2021 8:06 AM UTC
@craig_thonis The field inside "SalesForce CRM" schema is STRING with length as 18.
Translate
Milan_Vucetic
Milan_Vucetic
Level 9
Jan 25, 2021 7:24 PM UTC

Hi @roystonpr,

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

Translate
RoystonPrAuthor
Level 3
Jan 27, 2021 8:15 AM UTC

@milan_vucetic: The salesforce CRM schema has String type with length as 18. In otherside Salesforce is sending null value or 18 digit ID for this field. Note: Other fields are coming on the way(when i tried to select with remote crm and update the data) with same length and type. I'm facing only for two fields which looks different only in longer in "Name" & "Label" when comparing with other working fields under campaign level. I'm failing here in the first step itself when try to fetch the field under the CRM activity level.

Translate
Terms & ConditionsAccessibility statement

Loading footer...