BICS : Reports With DBaas Throws Error "Please have your System Administrator look at the log for more details on this error"
Last updated on MAY 31, 2018
Applies to:Oracle Business Intelligence Cloud Service - Version 22.214.171.124.0 to N/A [Release 15 to 14.1]
Information in this document applies to any platform.
BICS reports with DBCS stopped working and throws below errors:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
Additionally when trying to test the connection will throw I/O Error:
The Network Adapter could not establish the connection - connect timed out
[2018-04-28T23:02:27.963+00:00] [OracleBIServerComponent] [ERROR:1]   [ecid: 005Qj2TJhH74aqW_PxWByd00063A0000CM,0:4:1:9:5:1] [SI-Name: xxx] [IDD-GUID: 52165390875358603] [IDD-Name: xxxx-test] [tid: eabf4700] [nQSError: 17014] Could not connect to Oracle database. [[^M
file: server/Query/Execution/DbGateway/Oci10g/../Oci8/Src/SQXDGOci8.cpp; line: 430^M
Properties: description=<<100218>> DbGateway Exchange: DB1.CP1; producerID=0xe8947e80; requestID=0xd01000e; sessionID=0xd010000; userNamefirstname.lastname@example.org; ^M
[nQSError: 17001] Oracle Error code: 28001, message: ORA-28001: the password has expired
at OCI call OCISessionBegin.^M
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