Which role is required to run Field Map script of Transform Map.

[Ishan4]

I am running a transform map which has script for field map, sys_id is being targeted, which role does it require ? 

I suspect, it could be security_admin or agent_security_admin but can any lower role do the job ? 

[Harneet Sital · Accepted solution]

Hi Ishan, 

A couple of things -

Transform map transformation based on filed mapping or script will not be impacted by the user you are running it with. Ideally, a user with an import_set_loader role has the right access to transform data if that's what you are looking for. 

If the transforms are failing then do check if the user who is running the imports has the right access to the target table. 

If the above information is not what you were looking for, please elaborate on your issue and if possible include a screenshot of the error/TMap. 

If the answer has helped you, please mark the answer correct/helpful. Thank you.
-Harneet
ServiceNow Certified Technical Architect

[Ishan4]

Hi Harneet,

Thanks for reply. Actually I have access to tables but no script which is included in transform map is running, is there any way to check if server side scripts are blocked in instance ?

Thanks

[Harneet Sital]

Field and transform map scripts are never blocked and it seems the scripts are not running. 

While the data is loaded, do you see any errors if so the errors would explain the error?

The field script or transform map scripts are usually executed unless they are incorrectly written, would like to see the code if it's okay to share here on the post so that we can debug the issue. 

If the answer has helped you, please mark the answer correct/helpful. Thank you.
-Harneet
ServiceNow Certified Technical Architect 

[Ishan4]

Actually I ran exact script in Personal Dev Instance and those are running perfectly, in the instance where I need to do is, these are not running. Data is being loaded completely, if I run map without script everything is working fine, if I do same thing using scripts those are not happening, seems scripts are not running at all.

Since there is difference in roles on PDI and the instance where these needs to be done, that is why I suspected if these things are blocked due to roles.

Also no error is there in the transform map history, system log, import set row error tables, everything is green and/or no reported errors. I have put log.error(), log.info() as well.

Again, I would say scripts are running perfectly fine as intended in PDI where I have Admin role.