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

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

Avatar

Avatar
Validate 1
Level 1
Shane0806
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Shane0806
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Shane0806
Level 1

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
Give Back 10
Employee
craigthonis
Employee

Likes

157 likes

Total Posts

247 posts

Correct Reply

143 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

157 likes

Total Posts

247 posts

Correct Reply

143 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
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
Contributor
MVP
Milan_Vucetic
MVP

Likes

164 likes

Total Posts

382 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

164 likes

Total Posts

382 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
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