Confirm - ORA-00001: unique constraint (SBS.COMMENT_LIBRARY_PKX) violated

Product Feature: Street Works

Operating System: Not stated

Database: Not stated

Configuration: Not stated


When trying to add comments to the Confirm Comments library the following error is displayed:

Error message: DataWindow error for comment_library, executing: 
INSERT INTO comment_library ( comment_key, comment_text, comment_applic, comment_order, comment_name ) VALUES ( 1, 'yte', 'ALL', 999999, 'test' ) SQLSTATE = 23000 
[Oracle][ODBC][Ora]ORA-00001: unique constraint (SBS.COMMENT_LIBRARY_PKX) violated 



This Caused by there being no entries in the system_seed table for the comment_library. Probably caused by copying streetworks notices into the system by tables rather than reprocessing the messages.


UPDATED: April 3, 2017
Run the following queries to check and fix this issue.

--Run this query to get whether there are corresponding records exist or not.

SELECT * FROM system_seed WHERE seed_type='comment_library';

--Run this query to get max of comment_key

SELECT MAX(comment_key) comment_key FROM comment_library;

--Now run INSERT query

INSERT INTO system_seed VALUES('comment_library',(SELECT MAX(comment_key) FROM comment_library));