ACL error

[rwagner]

I have a Netsuite to Servicenow integration issue that's popped up. When my Netsuite integration runs on a particular table I am presented with the following error.

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

I've verified that the user account used for integration has the required role for the table inserts,updates and deletes. The only way I can get it to work is by giving the user account the Admin role which I do not want to do.

Any ideas?

[Uncle Rob]

Two possibilities.
1)   The ACL you're looking at has script conditions as well as role conditions, and the insert is failing the script.

2)   An ACL other than what you're investigating is the culprit.   If you're looking at a table level ACL, check if there are field level ACL's on the same table.   If so, will the user still pass?  

You can also manually test this by impersonating the account used for the integration, and following this guide when manually simulating the integration activity:

ACL Troubleshooting - A visual beginners' guide

[rwagner]

Robert the other day I removed the "webservice only" option from the user account, impersonated the account and was able to manually fill out a project. It was only failing during web service. This was all prior to the user account having any roles assigned.

[Michael Fry1]

I have a user for Netsuite integration that has lots of roles, but not admin. web_service_admin, rest_api_explorer, import_admin, _scheduler, _set_loader, _transform - to name a few.

[rwagner]

Michael do I add a user account here?