Why am I getting a 500 Response code from the REST API with an error response detail "Cannot save/update: <custom object>(ID=<id>): DB API Error"?
Oracle B2C Service Oracle B2C Service REST API
The REST API returns a response code of 500 including OSC-CREST-00008 and the detail "Cannot save/update: <custom object>(ID=<id>): DB API Error". This is due to the custom object definition design, specifically the number and type of fields. More details can be found in the error log, there can only be 8126 bytes added per PATCH request, with 768 used in the table itself.
DB API Error
There are a number of ways to handle this, the most straightforward is to redesign this table so that fields that do not need to be text are redefined if possible to another data type. Additionally, the table could be split up into multiple tables for any repeating columns. Those repeating columns should be put into an association table created to store the N instances of those columns. This would significantly reduce the size of both the main table and the associated table.