My Oracle Support Banner

Unable to Login to Argus - EID_DBAPP_INSERT_LOGINID (301200172) Error (Doc ID 2753143.1)

Last updated on MARCH 09, 2021

Applies to:

Oracle Argus Safety - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

Recently performed Database refresh from Production into Development environment.

Updated the control_table to align with DB_NAME

 
When attempt to login to Argus, now getting EID_DBAPP_INSERT_LOGINID (301200172) error:





CMN_ERROR_LOG entry below is created around the same time:


Argus Safety.COM :- Oracle error 1 occurred.
ORA-00001: unique constraint (G001SCHEMA.PK_CMN_USER_LOGIN) violated
SQL: INSERT INTO CMN_USER_LOGIN (LOGIN_ID, USER_ID, login_time) VALUES (:P_LOGIN_ID, :P_USER_ID, to_date(:P_ZULU_HOURS, 'YYYY/MM/DD HH24:MI:SS'))
PL/SQL Call Stack:
  SQL
673        PKG_CONSOLE_COMMON.P_ERROR_LOG
1          __anonymous_block



Changes

 Recent database clone from another Argus Environment

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.