Error: "ORA-28545: Error Diagnosed By Net8 When Connecting To An Agent" When Running The runETL Process Configured To Connect To A SQL Database Using The Oracle Gateway (Doc ID 1316107.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Primavera P6 Reporting Database - Version R2.1 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Apr-2014***

Symptoms

Using Reporting Database R2.1 configured to connect to a P6 EPPM database hosted on SQL Server through the Oracle Gateway, when attempting to process the runETL command for data extraction into the newly created reporting database, the following error occurs.

ERROR
-----------------------
extract [INFO] (Message) - ORA-28545: error diagnosed by Net8 when connecting to an agent
extract [INFO] (Message) - Unable to retrieve text of NETWORK/NCR message 65535
extract [INFO] (Message) - ORA-02063: preceding 2 lines from STAGE2PMDB
extract [INFO] (Progress) - Step 3/9 Part 1/4 - FAILED (28545) (0 hours, 0 minutes, 5 seconds, 609 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