Salesforce Marketing Cloud Integration with ServiceNow

[VasanthPandian]

Hello there,

We integration ServiceNow with Salesforce Marketing Cloud. The authentication and connection is successful. But the scheduled job: "Salesforce Marketing Cloud Download Contacts Consumption" is failing and the reason we noticed is 

Error Message:

"

Error: Following mandatory input field or field(s) in array of input field cannot be left blank- Data Extension. Check error log for more information

"

And I observed that we have a table "sn_sforce_mc_spoke_configurations" and on the Data Extension - Contacts Consumption record, there is no any value for configuration value.

Could you please help me on this?

Regards,

Vasanth

[dreinhardt]

Hi @VasanthPandian,

we had a similar issue with the integration - I prefer to create a case.

Please find attached some details of our troubleshooting with SN support.

• SalesForce CRM SaaS Integration Scheduled Job Failing - Support and Troubleshooting (servicenow.com)
• Check the logs if there is anything like:

"2023-05-29 04:09:33 (959) worker.0 worker.0 txid=85d4xxxxx0f WARNING *** WARNING *** Security restricted: Execute operation on script include 'SAMSaasIntegrationUtils' from scope 'Salesforce Spoke' was denied. The application 'Salesforce Spoke' must declare a cross scope access privilege. Please contact the application author to update their privilege requests."

Resolution:

Please create a cross-scope access privilege and attempt to run this again.

Please see the below docs to assist with completing this:

https://docs.servicenow.com/en-US/bundle/utah-application-development/page/build/applications/refere...
https://docs.servicenow.com/bundle/tokyo-application-development/page/build/applications/task/set-RC...

Or the below KB gives a closer example of how you would set this up:
KB0690133 : How to grant cross-scope access to a module

Best, Dennis