Unable to perform the requested database operation

Question

We have an API integration that is using the 'Journal entry batch (Create) (Deprecated)' endpoint. When attempting to create a batch we are receiving a response with the error 'Unable to perform the requested database operation'.

I have also tried using the newer (non deprecated) endpoint 'Journal entry batch process (Create)', followed by the 'Background process status (Get)' endpoint to get the status of the process. This returns a status of 7 (Job failed) along with the same error message: 'Unable to perform the requested database operation'

I would appreciate any assistance in getting this resolved - thank you

Give Interactive DevOps · Answer

Thank you @Alex Wong  - it ended up being the batch 'description' field, which is apparently limited to 60 characters. We were passing 61.

I found this info in a knowledgebase article but it would definitely be helpful if it was mentioned in the main documentation for this and related endpoints.

Alex Wong · Answer

this usually happens when you have bad JSON data being passed into the API endpoint. So double check that against the API definition.

You can also post your API request here (redacted) and get help that way.