Error - "ACL Exception Insert Failed due to security constraints"

Praful5 · ‎10-18-2019

Hi

I am trying to Automate change creation in service now with ansible through REST API. I am using the ansible uri module with POST method. I am getting the below error:

"content": "{\"error\":{\"detail\":\"ACL Exception Insert Failed due to security constraints\",\"message\":\"Operation Failed\"},\"status\":\"failure\"}",

"content_type": "application/json;charset=UTF-8",

"json": {

"error": {

"detail": "ACL Exception Insert Failed due to security constraints",

"message": "Operation Failed"

},

"status": "failure"

Could anyone can please help me ??

Ankur Bawiskar · ‎10-19-2019

Hi,

there is a CREATE acl on that table that is blocking the operation.

with which user you are testing this? admin or non-admin

if non-admin does that user have create Access on that table

check the above details

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Praful5 · ‎10-21-2019

Also, when i login to service now GUI with this credential, I am unable to see the option Create change

Ankur Bawiskar · ‎10-21-2019

Hi Praful,

So it means that user doesn't have proper ACLs to create that record I believe.

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Praful5 · ‎10-21-2019

Does this mean that the user does not have the right roles added ?

Praful5 · ‎10-21-2019

Hi All,

The issue got resolved after adding the user with right roles. Thank you very much for your valuable suggestions 🙂

Anjanie_Ali · ‎02-22-2021

Can you advise what the correct roles are, I am having the same issue but i cant seem to find what roles are missing