My Oracle Support Banner

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

Last updated on APRIL 01, 2019

Applies to:

Oracle Agile PLM Business Intelligence - Version 3.2.0 and later
Information in this document applies to any platform.


On : 3.2.0 version, PC MDS Layer, the BI Interactive Dashboard showing errors

Error Details
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')

1. Log into BI dashboard, http://hostname:7777/analytics
2. See the errors in Product Portfolio tab


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.