When trying to create a new network section you get an error similar to:
"Unigue constraint NE_PK violated"
This is probably because your sequences are out of sync.To check this run the following:select max(ne_id) from nm_elements_all;
Say this returns 9087304
Then run:select last_number from user_sequences where sequence_name = 'NE_ID_SEQ';
Say this returns 9086892 which is smaller than the number above which means that sequence IS out of sync with the table. To fix this run:
(change this according to the results above)Alter Sequence NE_ID_SEQINCREMENT BY 412;
SELECT NE_ID_SEQ.NEXTVAL FROM DUAL;
Alter Sequence NE_ID_SEQINCREMENT BY 1;
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
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!