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.
crmConnectorDataMgt2 ORA-210000 Oracle error: ORA-00972: identifier is too long
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.
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.