Creating New Diagrams got ORA-01400: Cannot Insert Null Into I$SDD_Diagram_Segments.Ivid (Doc ID 465862.1)

Last updated on OCTOBER 16, 2012

Applies to:

Oracle Designer - Version 10.1.2 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 10.1.2 in Production:
Trying to create a new ER Diagram get the following

ERROR
ORA-01400: cannot insert NULL into ("SCM_ADMIN"."I$SDD_DIAGRAM_SEGMENTS"."IVID")

EXPECTED BEHAVIOR
Expect be able to create ER diagrams without problems.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Enter into Designer
2. Go to ER Diagrams
3.Create a new Diagram

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot use Designer

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms