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 MARCH 07, 2018

Applies to:

Primavera Data Warehouse - Version R2.1 and later
Information in this document applies to any platform.

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)

Changes

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