OBIA 11g: Errors In Buyer Productivity Dashboard In Procurement
(Doc ID 1569839.1)
Last updated on JULY 11, 2022
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.7.0 and laterInformation in this document applies to any platform.
Symptoms
OBIA 11.1.1.7.1
Source system is PeopleSoft FSCM 9.1. - Procurement
There is an issue with Buyer Productivity Dashboard.
No data is displayed for the dashboard and shows the following errors
Error
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 90009] An error occurred while querying UI hints from ADF. [nQSError: 46119] Failed to open HTTP connection to server <hostname> at port <port>. [nQSError: 46131] Unresolved host name: <hostname>. Could not get details about the specified host (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT CAST("Time - Approved Date"."Report Date" AS DATE) FROM "Procurement - Requisitions Real Time"')}
SQL Issued: SELECT CAST("Time - Approved Date"."Report Date" AS DATE) FROM "Procurement - Requisitions Real Time"
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 90009] An error occurred while querying UI hints from ADF. [nQSError: 46119] Failed to open HTTP connection to server <hostname> at port <port>. [nQSError: 46131] Unresolved host name: <hostname>. Could not get details about the specified host (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT CAST("Time - Approved Date"."Report Date" AS DATE) FROM "Procurement - Requisitions Real Time"')}
SQL Issued: SELECT CAST("Time - Approved Date"."Report Date" AS DATE) FROM "Procurement - Requisitions Real Time"
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |