Load Data - Run Transform Map Loading data as GUEST user

[Community Alums]

Hi All

I have been struggling with this problem on our instance.

For some strange reason, when I am using Load Data module and then Running Transform Maps, then it runs as Guest user.

Also, I want to highlight this is not consistent, sometimes it works with the person's User ID who is executing the transform map.

Anyone else has seen this behavior, we need to give this functionality, and the loaded data and the transform map must execute with the ID of the person executing it.

Please help...

[Pradeep Sharma]

Hi Saurabh Gupta

I am assuming there might be a schedule data imports which runs the job as guest user. Please check the same in your instance.

Basically there is a field called "Run as" in it which if blank will run as a guest user. Please find more details in the below link.

Scheduling Data Imports - ServiceNow Wiki

Please let me know if you have any questions.

[Community Alums]

Hi Pradeep

No.. I am not using a Scheduled importing... Just the Load Date functionality and then manually trigerring the Transform maps.

Can somone else schedule import impacts my transform maps and manual loading...

Regards

Saurabh

[tony_barratt]

Hi Saurabh,

Creating a Scheduled Job - ServiceNow Wiki

Run as

The user creating and running the scheduled job. To have the scheduled job assigned to system behavior instead of the person creating the scheduled job, create a system or "dummy" user and add that user to this field.

If the "Run As" field in a scheduled job is blank then the scheduled job will run as the userid of the person who created the scheduled job.

If the userid of the person who created the scheduled job is inactive, locked out or simply no longer present in the sys_user table then the scheduled job will run as guest.

A scheduled job, that initiates an import or perhaps an asynchronous transform may be running as guest for the above mentioned reasons.

Best Regards

Tony

[Community Alums]

Hi Tony..

Thanks for helping me... just want to confirm I am not using any scheduled import or scheduled job to trigger the loading of data.

All manual loading... Load Data.. Run Transform... Select Transform Maps and Click Transform button

Or are you saying there is some scheduled job in the background that is used by this functionality and that is running as guest?

Regards

Saurabh