My Oracle Support Banner

Error: "ORA-04021: timeout occurred while waiting to lock object" Executing STARUSER.UDF_UNIFIER (With Unifier ETL) Or STARUSER.DYNAMIC_UDFS / STARUSER.HIER_PKG (With P6 ETL) (Doc ID 2460120.1)

Last updated on MARCH 09, 2020

Applies to:

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

Symptoms

While the scheduled ETLs are running for both staretl1 (P6) and staretl2 (Unifier), each ETL can intermittently fail with the following issue:

STARETL2 (UNIFIER) ERROR
-----------------------
...
  [ERROR] PROC_LOAD_PROJECT_SHELL_UDF
  [DONE] 0 \-\ VAR_DATASOURCE_ID
  [DONE] 1 /-/ Variable - VAR_DATASOURCE_ID - null
  [ERROR] 1 \-\ Unifier Project Shell Udf
  [ERROR] 2 /-/ Procedure - Unifier Project Shell Udf - Load Project Shell Dim Udf
ODI-1228: Task Procedure-Unifier Project Shell Udf-Load Project Shell Dim Udf fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
 Caused By: java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "STARUSER.UDF_UNIFIER", line 414
ORA-06512: at line 2


STARETL1 (P6) ERROR
-----------------------
...
  [ERROR] After Loading Package Global, duration = 903 seconds
  [ERROR] PROC_AFTER_LOADING_PKG_GLOBAL
  [ERROR] 0 \-\ Load EPS Resource Role Hierarchies
  [ERROR] 1 /-/ Procedure - Load EPS Resource Role Hierarchies - LoadEpsResRoleHierarchies
ODI-1228: Task Procedure-Load EPS Resource Role Hierarchies-LoadEpsResRoleHierarchies fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
  Caused By: java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "STARUSER.HIER_PKG", line 307
ORA-06512: at line 2
...
  [ERROR] Load project UDF, duration = 903 seconds
  [ERROR] PROC_LOAD_PROJECT_UDF
  [ERROR] 0 \-\ Load Project Udf
  [ERROR] 1 /-/ Procedure - Load Project Udf - Load Project Udf Dim
ODI-1228: Task Procedure-Load Project Udf-Load Project Udf Dim fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
  Caused By: java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "STARUSER.TRUNC_PARTITION", line 30
ORA-06512: at "STARUSER.DYNAMIC_UDFS", line 296
ORA-06512: at "STARUSER.DYNAMIC_UDFS", line 316


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

  1. Schedule ETL and observe results

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.