My Oracle Support Banner

Mongo API Fails With ORA-40944: Cannot insert into JSON Relational Duality View (Doc ID 3044313.1)

Last updated on AUGUST 28, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

A table is defined with a PK column INTEGER GENERATED BY DEFAULT ON NULL AS IDENTITY.

Via SQL, a row can be inserted without specifying the PK column when populating the columns or the duality view.

However, the MongoAPI will not allow a row to be inserted without an _id column, and fails with the error below:

MongoServerError: ORA-40944: Cannot insert into JSON Relational Duality View 'CU1': The input JSON document is invalid.
JZN-00655: Message 655 not found; No message file for product=XDK, facility=JZN

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.