IP17 IRM Preparation Of Prior Customer Repository (RepCrawler execution) Deadlock Error

(Doc ID 2329394.1)

Last updated on FEBRUARY 23, 2018

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

On : 17.0 [IP2017] version, Upgrade

When performing the upgrade from IP13 to IP17, the following error occurs in the logs while running Upgrep, RepCrawler execution :

ERROR
-------------


DELETE FROM SIEBEL.S_REP_OBJLST_US WHERE NAME in (Select XX.NAME from S_REP_OBJLST_US XX, S_BUSCOMP_SCRIPT where S_BUSCOMP_SCRIPT.ROW_ID='1-P7JS2' and S_BUSCOMP_SCRIPT.SCRIPT LIKE '%'||XX.NAME||'%')
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource

This is example from Script_2.out, can be seen in others



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