| 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
