Bi Interactive Dashboard Showing Errors "Opr4onwy:U9im8tac:Oi2dl65p State: Hy000. Code: 10058"
(Doc ID 1263214.1)
Last updated on FEBRUARY 20, 2023
Applies to:
Oracle Agile PLM Business Intelligence - Version 3.2.0 and laterInformation in this document applies to any platform.
Symptoms
On : 3.2.0 version, PC MDS Layer, the BI Interactive Dashboard showing errors
ERROR
-----------------------
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SELECT FILTER("Project Measures"."# Projects" USING ("- Project Scheduled Start Date"."Start Fiscal Year" = VALUEOF("CURRENT YEAR"))) saw_0, (FILTER("Project Measures"."# Projects" USING ("- Project Scheduled End Date"."End Fiscal Year" = VALUEOF("CURRENT YEAR"))) /FILTER("Project Measures"."# Projects" USING ("- Project Scheduled End Date"."End Fiscal Year" = VALUEOF("PREVIOUS YEAR"))) )*100 saw_1 FROM "PLM PPM - Project Summary" WHERE (Project."Project State" <> 'Template')
STEPS
-----------------------
1. Log into BI dashboard, http://hostname:7777/analytics
2. See the errors in Product Portfolio tab
Changes
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 |
| Changes |
| Cause |
| Solution |