Bi Interactive Dashboard Showing Errors "Opr4onwy:U9im8tac:Oi2dl65p State: Hy000. Code: 10058" (Doc ID 1263214.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Agile PLM Business Intelligence - Version 3.2.0 and later
Information 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

Cause

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