Unable to perform the requested database operation

Give Interactive DevOps
Give Interactive DevOps
Kudos 1 Name Dropper Facilitator 1
in SKY Developer General Discussions

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

Answers

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    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.

  • Give Interactive DevOps
    Give Interactive DevOps
    Kudos 1 Name Dropper Facilitator 1

    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.

Categories