Integration Issue: Manual Load Works, Scheduled Job Fails

[monica190]

I had configured an integration following this approach: Integration between Redshift and ServiceNow. After completing all the setup steps, I created a scheduled job to run the data source on a schedule, using a user with the import_scheduler role.

However, for some reason, while loading all records manually works perfectly, the same logic fails to pull data when executed via the scheduled job.

Has anyone come across a similar issue?

[Maik Skoddow]

Hi @monica190 

what does " while loading all records manually works perfectly" mean? Did you perform that load with your identity? If yes, you probably have all the required roles/rights to store the data in the target tables. On the other side: An integration user only having the role "import_scheduler" role is probably not sufficient to store the data.

Maik

[monica190]

Hi @Maik Skoddow ,

Thank you for your response. What I meant earlier is that there’s a related link under Data Sources to load all records, clicking that was working fine. However, running it through a scheduled job wasn’t loading any records.

It’s working now though. I cleared the cache and restarted the MID server to sync the JAR file, and everything seems to be functioning properly. Thanks!