STARETL Step 12, Part 1 (In Addition To Various Steps Executed Later In The ETL Run) Fails With Error: "ORA-00933: SQL command not properly ended" When Attempting To Create Or Objects That Reference The Database Link Name (Doc ID 1954301.1)

Last updated on AUGUST 02, 2016

Applies to:

Primavera P6 Analytics - Version R3.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the STARETL, the following error occur throughout any step that either creates or calls an object that contains a reference to the database link name:

ERROR
-----------------------
<12.15.2014 05:23:40> staretl [INFO] (Message) - === Step 12, Part 1 ====================================================
<12.15.2014 05:23:40> staretl [INFO] (Message) - === Create source-specific synonyms (create_source_synonyms.sql)
<12.15.2014 05:23:40> staretl [DEBUG] (Message) - SQL Plus(4) :  [-s] [********] [@run$script.sql] [SCRIPTNAME:create_source_synonyms.sql]
<12.15.2014 05:23:41> staretl [INFO] (Message) - PL/SQL procedure successfully completed.
<12.15.2014 05:23:41> staretl [INFO] (Message) - DECLARE
<12.15.2014 05:23:41> staretl [INFO] (Message) - *
<12.15.2014 05:23:41> staretl [INFO] (Message) - ERROR at line 1:
<12.15.2014 05:23:41> staretl [INFO] (Message) - ORA-00933: SQL command not properly ended
<12.15.2014 05:23:41> staretl [INFO] (Message) - ORA-06512: at line 12
<12.15.2014 05:23:41> staretl [INFO] (Progress) - Step 12/50 Part 1/1 - FAILED (933) (0 hours, 0 minutes, 1 seconds, 591 milliseconds)

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