"ORA-20001 unique constraint IM_POD_SQL_PK violated" appears while adding SQL to POD


 Product(s):Exor Information Manager
 Version(s):04.07.00.01
 Environment:N\A
 Area:Pod Results
 Subarea:N\A

Error or Warning Message

ORA-20001 unique constraint IM_POD_SQL_PK violated

Explanation

I am getting error "Error in mru internal routine: ORA-20001:" when trying to add SQL to the POD source.
 

How to Avoid

This error appears because the incorrect number is provided by IPS_ID_SEQ sequence. You need register it and recreate using scripts below. This script must be run by Highways owner.
insert into hig_sequence_associations (hsa_table_name, hsa_column_name, hsa_sequence_name)
values ('IM_POD_SQL', 'IPS_ID', 'IPS_ID_SEQ');
commit;
exec nm3ddl.rebuild_sequence('IPS_ID_SEQ');

See Also

 

 Original Author:NT