Problem

Adding a new standard item into Standard Items form (MAI3888) causes HIG-0169 Database constraint violated CNI_INDEX_P1.

Solution

Item already existed in DUMCONCODE contract but did not exist in standard items form ( mai3888). So I removed the entry from the DUMCONCODE contract. Then I was able to enter the item code that was failing.

Queried back item from standard items form to see if already existed - with the scenario investigated it did not. However, entering and saving new item caused HIG-0169 Database constraint violated CNI_INDEX_P1 to be displayed. Check Product Option DUMCONCODE, note the Contract assigned (DEFAULT). From Contracts form query back contract (DEFAULT). From contract items part of form check if item exists, if it does ( which it did for this scenario)  - remove by deleting record.Then return to standard items form to create item. Insert Trigger on standard items table caused the error.

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!