Users Are Unable To Save Case Data, -60:ORA-00060: deadlock detected while waiting for resource (Doc ID 1531736.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Argus Safety - Version 6.0.5 to 7.0.1 [Release 6.0 to 7.0.0]
Information in this document applies to any platform.
***Checked for relevance on 10-MAY-2017***
***Checked for relevance on 23-Sep-2014***

Symptoms

When a user clicks on the save button, the progress bar will continue spinning and nothing happens. The user can only perform "read only" activities.

CMN_ERROR_LOG entries around the time of the slowdown show a number of entries similar to below regarding deadlocks:

-60:ORA-00060: deadlock detected while waiting for resource:
=====================================================================================================================================
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "ARGUS_APP.GSS_CASE", line 305
ORA-06512: at line 1
=====================================================================================================================================
SQL: BEGIN GSS_CASE.P_CASE_MASTER_IU(:PI_CASE_ID, :PI_CASE_NUM, :PI_REV, :PI_WORKFLOW_SEQ_NUM, :PI_LAST_WORKFLOW_SEQ_NUM, :PI_CREATE_TIME, :PI_INIT_REPT_DATE, :PI_USER_ID, :PI_LAST_UPDATE_TIME, :PI_LAST_UPDATE_USER_ID, :PI_REQUIRES_FOLLOWUP, :PI_FOLLOWUP_DATE, :PI_OWNER_ID, :PI_STATE_ID, :PI_COUNTRY_ID, :PI_LANG_ID, :PI_PRIORITY, :PI_SITE_ID, :PI_SERIOUSNESS, :PI_RPT_TYPE_ID, :PI_LAST_STATE_ID, :PI_ASSESSMENT_NEEDED, :PI_PRIORITY_OVERRIDE, :PI_SID, :PI_SAFETY_DATE, :PI_NORMAL_TIME, :PI_MAX_TIME, :PI_REPORT_SCHEDULING, :PI_PRIORITY_ASSESSMENT, :PI_CLOSE_USER_ID, :PI_CLOSE_DATE, :PI_CLOSE_NOTES, :PI_DATE_LOCKED, :PI_UD_TEXT_1, :PI_UD_TEXT_2, :PI_UD_TEXT_3, :PI_UD_TEXT_4, :PI_UD_TEXT_5, :PI_UD_TEXT_6, :PI_UD_TEXT_7, :PI_UD_TEXT_8, :PI_UD_TEXT_9, :PI_UD_DATE_1, :PI_UD_DATE_2, :PI_UD_DATE_3, :PI_UD_DATE_4, :PI_UD_DATE_5, :PI_UD_DATE_6, :PI_UD_DATE_7, :PI_UD_DATE_8, :PI_UD_DATE_9, :PI_UD_NUMBER_1, :PI_UD_NUMBER_2, :PI_UD_NUMBER_3, :PI_UD_NUMBER_4, :PI_UD_NUMBER_5, :PI_UD_NUMBER_6, :PI_UD_NUMBER_7, :PI_UD_NUMBER_8, :PI_UD_NUMBER_9, :PI_DUE_SOON, :PI_GLOBAL_NUM, :PI_PRIORITY_DATE_ASSESSED, :PI_UD_TEXT_10, :PI_UD_TEXT_11, :PI_UD_TEXT_12, :PI_UD_DATE_10, :PI_UD_DATE_11, :PI_UD_DATE_12, :PI_UD_NUMBER_10, :PI_UD_NUMBER_11, :PI_UD_NUMBER_12, :PI_LAM_ASSESS_DONE, :PI_WORKLIST_OWNER_ID, :PI_SUSAR, :PI_LAST_UPDATE_EVENT, :PI_FORCE_SOON, :PI_INITIAL_JUSTIFICATION, :PI_DUE_SOON_J, :PI_FOLLOWUP_DATE_J, :PI_INIT_REPT_DATE_J, :PI_JUST_INIT_REPT_DATE_J, :PI_UD_TEXT_1_J, :PI_UD_TEXT_2_J, :PI_UD_TEXT_3_J, :PI_UD_TEXT_4_J, :PI_UD_TEXT_5_J, :PI_UD_TEXT_6_J, :PI_UD_TEXT_7_J, :PI_UD_TEXT_8_J, :PI_UD_TEXT_9_J, :PI_UD_TEXT_10_J, :PI_UD_TEXT_11_J, :PI_UD_TEXT_12_J, :PI_INITIAL_JUSTIFICATION_J); END;
=====================================================================================================================================
-60:ORA-00060: deadlock detected while waiting for resource:
=====================================================================================================================================
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00060: deadlock detected while waiting for resource
=====================================================================================================================================
SQL: update case_master set PRIORITY_DATE_ASSESSED = null where PRIORITY_DATE_ASSESSED is not null
=====================================================================================================================================
-60:ORA-00060: deadlock detected while waiting for resource:
=====================================================================================================================================
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "ARGUS_APP.TRG_CFG_PER_RPT_FREQ_AFT_UID", line 2
ORA-04088: error during execution of trigger 'ARGUS_APP.TRG_CFG_PER_RPT_FREQ_AFT_UID'

SQL: update cfg_per_rpt_freq Set deleted = sysdate where report_form_id = 112514
=====================================================================================================================================
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00060: deadlock detected while waiting for resource
=====================================================================================================================================
SQL: SELECT * FROM LM_REPORT_FORMS WHERE REPORT_FORM_ID = 112939 FOR UPDATE
Argus Safety.COM :- Oracle error 8197 occurred.
=====================================================================================================================================
SQL execution error, ORA-00060: deadlock detected while waiting for resource
=====================================================================================================================================
SQL: update case_master set PRIORITY_DATE_ASSESSED = null where PRIORITY_DATE_ASSESSED is not null
-60:ORA-00060: deadlock detected while waiting for resource:
-60:ORA-00060: deadlock detected while waiting for resource:
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "ARGUS_APP.TRG_CFG_PER_RPT_FREQ_AFT_UID", line 2
ORA-04088: error during execution of trigger 'ARGUS_APP.TRG_CFG_PER_RPT_FREQ_AFT_UID'
ORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 11825
ORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 11549
ORA-06512: at line 1

SQL: Begin gss_periodic.P_COPY_PERIODIC_REPORT(:P_USER_ID, :P_REPORT_TYPE, :P_REPORT_FORM_ID, :P_REPORT_NAME); end;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms