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.
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.
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!