Oninit
Talk to an expert →

Informix Error -9660: The database server operation failed due to an invalid JSON document.

Cause and resolution

The database server operation failed due to an invalid JSON document.

Replace the invalid JSON document with a valid JSON document. To prevent the problem from occurring in the future, ensure that the client inserts valid and uncorrupted JSON documents into the database.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9660 fires when a database server operation encounters a JSON document that isn't valid — per the official guidance.

  1. A malformed or corrupted JSON document, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Replace the invalid JSON document with a valid one, per the official guidance.
  2. Ensure the client inserts only valid, uncorrupted JSON documents in the future, per the official guidance, to prevent recurrence.
Examples
N/A

No specific triggering statement is documented; the specific malformation varies.

Diagnostic Checks
  1. Validate the JSON document's syntax (e.g. with a JSON linter), and correct or replace it.
Related Errors / Related Topics
  • -9659 — "The server does not support the specified UPDATE operation on JSON documents." A related JSON-document error, on an unsupported UPDATE operation rather than document validity.

A JSON document was invalid — replace it with a valid one, and ensure the client only inserts valid JSON going forward.