OAC: An Analysis Fails With ORA-01017 Error When The Data Model Is Built On A Connection As The SYS User
(Doc ID 2431567.1)
Last updated on JULY 03, 2023
Applies to:
Oracle Analytics Cloud - Classic - Version N/A to N/A [Release 14.1]Information in this document applies to any platform.
Symptoms
1. Create a Connection to a Database instance, connecting as the SYS user
For example: Login to OAC (/dv/ui) > Navigator > Console > Connections > New Connection ... Connect As: SYS AS SYSDBA
2. Create a Data Model via the Thin Client Modeller (TCM), using the Connection created
For example: Login to OAC (/dv/ui) > Navigator > Data > Page Menu > Manage Models > Create Model ... Select the Connection above
3. Create an Analysis on the Data Model, once the design is completed
For example: Login to OAC (/dv/ui) > Open Classic Home > New - Analysis ... Select columns etc.
4. Navigate to the Results tab to run the Analysis, and see the following error is thrown:
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17025. [nQSError: 17025] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied at OCI call OCISessionBegin. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: ...
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 |