AnsweredAssumed Answered

Error recreating PRJ_BLB_SLICES table - upgrade 13.2 to 14.3

Question asked by MauricioLobao4213392 on Mar 14, 2016
Latest reply on Mar 17, 2016 by MauricioLobao4213392

Hello all,

Could someone help me ? I'm facing the bellow error when I tried upgrade Clarity from 13.2 to 14.3

Thanks.

Process - procedure: PRJ_BLB_SLICES_REORG_SP.xml

Process - other: PRJ_BLB_SLICES_CLRT_71773.xml

INFO: The operation on the PRJ_BLB_SLICES table could take some time depending on the size of the table

com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error recreating PRJ_BLB_SLICES table. Refer to the Change Impact Guide for information : ORA-12801: error signaled in parallel query server P000

ORA-00060: deadlock detected while waiting for resource

ORA-06512: at "NIKU.PRJ_BLB_SLICES_REORG_SP", line 122

ORA-06512: at line 11

 

 

  at com.ca.clarity.jdbc.oraclebase.ddes.j(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.ddes.a(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.ddes.executeBatch(Unknown Source)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

  at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$48d40569.executeBatch(<generated>)

  at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2686)

  at com.niku.dbtools.DriverApp.apply(DriverApp.java:1490)

  at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:710)

  at com.niku.dbtools.Utilities.run(Utilities.java:1836)

  at com.niku.dbtools.Utilities.main(Utilities.java:954)

 

 

SQL Text:

 

 

 

 

DECLARE

  V_COUNT NUMBER := 0;

 

  BEGIN

 

    SELECT COUNT(1) INTO V_COUNT FROM CMN_DB_HISTORY

      WHERE NAME='PRJ_BLB_SLICES_CLRT_71773.xml' AND TYPE='other';

 

    IF V_COUNT = 0 THEN

 

 

      PRJ_BLB_SLICES_REORG_SP();

     

    END IF;

 

  END;

 

 

 

 

 

Note: Foreign Keys and Triggers have been enabled

 

 

DBDriver failed to install!

Exception in thread "main" java.lang.Exception: DBDriver failed to install

  at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:908)

  at com.niku.dbtools.Utilities.run(Utilities.java:1836)

  at com.niku.dbtools.Utilities.main(Utilities.java:954)

Caused by: com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error recreating PRJ_BLB_SLICES table. Refer to the Change Impact Guide for information : ORA-12801: error signaled in parallel query server P000

ORA-00060: deadlock detected while waiting for resource

ORA-06512: at "NIKU.PRJ_BLB_SLICES_REORG_SP", line 122

ORA-06512: at line 11

Attachments

Outcomes