Database Error Messages

ORA-41962

Invalid primary key in VERTEX_ID or EDGE_ID value

Cause

The VERTEX_ID or EDGE_ID value is invalid. The value of the KEY_VALUE field does not match the primary key of the vertex or edge table. This indicates one of the following issues:

  1. The number of values in KEY_VALUE does not match the number of primary key columns in the table.
  2. The value of at least one primary key column is not present in KEY_VALUE.
  3. The type of at least one primary key column does not match the value provided in KEY_VALUE.

Action

Provide a valid VERTEX_ID or EDGE_ID value. Ensure that all conditions are met:

  1. The number of values in KEY_VALUE must match the number of primary key columns of the table.
  2. Exactly one value must be provided for each primary key column.
  3. The key value types must match the types of the corresponding primary key columns in the table.