Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Shane0806
Level 2
Level 2

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

 

1 Accepted Solution
craigthonis
Correct answer by
Employee
Employee

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 solution in original post

5 Replies
craigthonis
Correct answer by
Employee
Employee

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 solution in original post

Shane0806
Level 2
Level 2
@craigthonis The field inside "SalesForce CRM" schema is STRING with length as 18.
Shane0806
Level 2
Level 2
@craigthonis and this comes from Salesforce as foreign relationship fields would have null value or 18 digit ID
Milan_Vucetic
Community Advisor
Community Advisor

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

Shane0806
Level 2
Level 2

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