Salesforce Connector Activity: Remote CRM: Field Import Issue in WORKFLOW | Community
Skip to main content
R
RoystonPr
Level 3
January 22, 2021
Solved

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

  • January 22, 2021
  • 2 replies
  • 2024 views

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.
Best answer by Craig_Thonis

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. 

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
January 25, 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. 

R
RoystonPrAuthor
Level 3
January 27, 2021
@craig_thonis and this comes from Salesforce as foreign relationship fields would have null value or 18 digit ID
Milan_Vucetic
Milan_Vucetic
Level 9
January 25, 2021

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

R
RoystonPrAuthor
Level 3
January 27, 2021

@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.

Terms & ConditionsAccessibility statement

Loading footer...