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?

[Michael Fry1]

Your original post said you had a user account already, no reason to create a new one, but try giving it extra roles and see if that changes anything.

[rwagner]

Michael,

I gave it the admin role and it worked fine. However I cant do that in production.

[Michael Fry1]

I agree, won't want to do that. From the Netsuite side, the script uses a User account for pushing records, but that account doesn't have admin role. Depending on your setup, it might just be a role issue, more than an ACL issue. The account will also need roles to write to tables where data is syncing, like companies, projects, etc.

[Uncle Rob]

If the integration is via SOAP, this page may have some helpful information:

http://wiki.servicenow.com/index.php?title=Inbound_SOAP_Web_Service_Security#Web_Service_User_Roles