Unifier ETL Job Fails With "ORA-01031: insufficient privileges"

(Doc ID 2346926.1)

Last updated on JANUARY 26, 2018

Applies to:

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

Symptoms


When attempting to run the ETL for Unifier Analytics, the following error occurs.

 

ERROR
----------

INFO: Begin parsing odi xml: oracle/odi/domain/mapping/generator/resource/HiveTemplate.xml
Thu Jan 04 18:23:20 GMT 2018.... Starting loadPlan LOAD_PLAN_DAILY
Load plan [LOAD_PLAN_DAILY] started, instance id = 385
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 10 seconds

...more

Thu Jan 04 15:14:54 GMT 2018.... Starting loadPlan LOAD_PLAN_DAILY
Load plan [LOAD_PLAN_DAILY] started, instance id = 380
  Load dimension and fact tables
  [ERROR]44) SCENARIO_UNIFIER_LOAD, duration = 2 seconds
  [ERROR]SCENARIO_UNIFIER_LOAD
  [ERROR]RUNNER_UNIFIER_LOAD
  [ERROR]UNIFIER_LOAD_W_PROJECT_D_PHYSICAL
  [ERROR]10 \-\ Physical_STEP
  [ERROR]10 /-/ SERIAL - MAP_MAIN - null
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-PRIMAVERA_ANALYTICS_SRC_LS_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-PRIMAVERA_ANALYTICS_SRC_LS_UNIT (20)" failed because child task
"Create view/table on source-LKM Oracle to Oracle (DBLINK)- (40)" is in error.
ODI-1227: Task Create view/table on source-LKM Oracle to Oracle (DBLINK)- fails on the source connection PRIMAVERA_ANALYTICS_SRC_DS2.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
 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)

...more

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:745)
  [WARNING]30 /-/ Drop work table - LKM Oracle to Oracle (DBLINK) - null
  [ERROR]40 /-/ Create view/table on source - LKM Oracle to Oracle (DBLINK) - null
ODI-1227: Task Create view/table on source-LKM Oracle to Oracle (DBLINK)- fails on the source connection PRIMAVERA_ANALYTICS_SRC_DS2.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

...more

RUNNING]P6 Daily
  [DONE]Status daily run start, duration = 1 seconds
  [DONE]STATUS_DAILY_RUN_START
  [DONE]Populate Global Date Dimension, duration = 2 seconds
  [DONE]PROC_POPULATE_GLOBAL_DATE_DIMENSION
  [ERROR]rootStep_caseWhen, duration = 7 seconds
  [DONE]Create Udf Columns, duration = 4 seconds
  [DONE]PROC_CREATE_UDF_COLUMNS
  [DONE]Create Code Columns, duration = 0 seconds
  [DONE]PROC_CREATE_CODE_COLUMNS
  [ERROR]Case Data Source Type, duration = 7 seconds
  SQL scripts after loading part 1
  SQL scripts after loading part 2
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 21 seconds
-- End --
15:15:27.957 [main] INFO com.oracle.pgbu.bi.odi.runner.OdiPurgeStaleLog - Purged 30stale log session(s) older



STEPS TO REPRODUCE
---------------------------

  1. In Analytics administration (accessible from cloud landing page), choose Staretl2 and Run ETL (in this case Startetl2 is the name for the Analytics Unifier ETL script)



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