My Oracle Support Banner

Error: "ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired" And/Or "ORA-00955: name is already used by an existing object" While Running A P6 ETL Using ODI (Doc ID 2364941.1)

Last updated on SEPTEMBER 05, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.12.1.0 and later
Information in this document applies to any platform.

Symptoms

While running an ETL for a P6 Data Source, the ETL fails with the following errors:

ERROR #1
-----------------------
[ERROR] PROC_AFTER_LOADING_PKG_RELATIONSHIPS
[ERROR] 0 \-\ Load Relationships
[ERROR] 1 /-/ Procedure - Load Relationships - Load Codes Mappings
 ODI-1228: Task Procedure-Load Relationships-Load Codes Mappings fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
 Caused By: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
 ORA-06512: at "STARUSER.RELATIONSHIP_PKG", line 152
 ORA-06512: at line 2

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)


ERROR #2
-----------------------
[ERROR] 1 \-\ Load UDF Activity HD
[ERROR] 2 /-/ Procedure - Load UDF Activity HD - Load activity UDF HD
 ODI-1228: Task Procedure-Load UDF Activity HD-Load activity UDF HD fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
 Caused By: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
 ORA-06512: at "STARUSER.SCD", line 956
 ORA-06512: at "STARUSER.SCD", line 970
 ORA-06512: at line 2

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)


ERROR #3
-----------------------
[ERROR] 1 \-\ Load UDF Assignment HD
[ERROR] 3 /-/ Procedure - Load UDF Assignment HD - Load assignment UDF HD
 ODI-1228: Task Procedure-Load UDF Assignment HD-Load assignment UDF HD fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
 Caused By: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
 ORA-06512: at "STARUSER.SCD", line 956
 ORA-06512: at "STARUSER.SCD", line 970
 ORA-06512: at line 2

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)

 

ERROR #4
-----------------------
[ERROR] After loading package relationships, duration = 63 seconds
[ERROR] PROC_AFTER_LOADING_PKG_RELATIONSHIPS
[ERROR] 0 \-\ Load Relationships
[ERROR] 1 /-/ Procedure - Load Relationships - Load Codes Mappings
ODI-1228: Task Procedure-Load Relationships-Load Codes Mappings fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
Caused By: java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "STARUSER.RELATIONSHIP_PKG", line 255
ORA-06512: at line 3


STEPS TO REPRODUCE
----------------------------
The issue can be reproduced at will with the following steps:

  1. Run the ETL process;

Notice the above behavior when finished.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the ETL process.

Changes

 

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.