Error: "PLS-306: Wrong Number or Types of Arguments in Call to 'GET_LINK_NAME'" When Attempting to Run the StarETL Process (Doc ID 2171560.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Primavera Analytics - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

The Data Warehouse / Analytics environment has been upgraded to 15.2.0.0 or later, but an older version of the starETL (.bat/.sh) script gets run against the upgraded STAR database.  When an attempt is made to run the correct starETL script version, the following error occurs:


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

  1. Upgrade the P6 EPPM/Data Warehouse environment and STAR database to R15.2 or later.
  2. Run a pre-15.2 version of the starETL script against the upgraded database.
  3. The older script fails.
  4. Attempting to run the correct version of the starETL script fails with the reported error.

Due to this issue, the STAR data cannot be used for reporting.

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