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
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)
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