Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Failed to open HTTP connection to server slcac782.us.oracle.com

Received Response
1
Views
2
Comments
7688438
7688438 Rank 5 - Community Champion

Hi all, Can you any body give me some insight on the below error. We are using Out of the box OBIEE RPD for Financial analytics.We are try to create analysis with some measures/Attributes getting the below issue. Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46119] Failed to open HTTP connection to server slcac782.us.oracle.com at port 6013. [nQSError: 46131] Unresolved host name: slcac782.us.oracle.com. Could not get details about the specified host (HY000) SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Procurement - Requisitions Real Time"."Requisition Header Detail"."Header Description" s_1, "Procurement - Requisitions Real Time"."Requisition Header Detail"."Requisition Number" s_2, "Procurement - Requisitions Real Time"."Requisition Header"."Count" s_3 FROM "Procurement - Requisitions Real Time" FETCH FIRST 100000001 ROWS ONLY

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Why would you want to open a connection to a machine in one of Oracle's data centers? Unless you are working for Oracle on an Oracle-internal solution, surely that's a leftover / oversight in terms of RPD cleanup.

  • 7688438
    7688438 Rank 5 - Community Champion

    Chris, Thanks for your inputs.I found the solution.That dashboard is only for fusion users.Our source is EBS-12.1.3. OBIA 11g - Errors In The Buyer Productivity Dashboard Of The Procurement (Doc ID 1569839.1)