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...

[Gurpreet07]

Are you using some mid server for data sources.

[tony_barratt]

Hi Saurabh,

All the same, it is possible for a scheduled job to carry out actions on import set tables.

For example a scheduled job could look through all import set tables and carry out some actions.

If the user who created such a scheduled job with "Run as" empty, has their userid deactivated, then such a scheduled job will run as guest - and mostly likely fail to carry out the expected action - although you might   see an empty row owned by guest.

Here is an example of a scheduled job that might carry out actions against "your" import set table.

http://wiki.servicenow.com/index.php?title=Web_Service_Import_Sets#Import_Set_Mode

3 Import Set Mode

When a web service message inserts a record into an import set table, and the table did not previously have an import set referenced, a new one will be created, and its Mode will be set asSynchronous. A synchronous import set transforms the data as soon as it is inserted, provided that the transform map already exists. This import set will also have a default State of Loading. By default, the state of all synchronous import sets is automatically set to Processed at midnight. As a result, when a new insert happens to the same table, a new synchronous import set will be created.

Could you attach a screenshot of the guest entry you are seeing?

Gurpreet's inquiry as to whether you are using a MID Server indicates another possible explanation BTW.

Best Regards

Tony

[Ashish Kumar Ag]

Hi Saurabh,

The source of import is file or data source?

[Oliver D_sereck]

Hi Saurabh,

did you ever get an answer to this?

I have the same issue.

Normal Load Data -> Transform happens as Guest User. I have ACLs and Before Query Business Rules which are now not working since Guest has no access.

To everyone else, this is WITHOUT Scheduled Loads...I do not want to use them either.

It seems that there is no property to set which user runs transforms outside of the scheduled load system