Data Flow Fails When Selecting "Save Data" As Oracle DB Connection With Proxy User Authentication
(Doc ID 2742371.1)
Last updated on JANUARY 14, 2021
Applies to:
Oracle Analytics Server - Version 5.5.0 to 5.5.0 [Release 5]Information in this document applies to any platform.
Symptoms
Data Flow Fails when using option "Save Data to" Database Connection and corresponding DB Connection definition in DV is leveraging proxy user authentication.
obis1-diagnostic.log
[OBIS] [ERROR:1] [] [] [ecid: *******] [sik: ssi] [tid: ****] [nQSError: 17010] SQL statement preparation failed. [[file: server/Query/Execution/DbGateway/Oci10g/../Oci8/Src/SQXDGOci8.cpp; line: 489Properties: description=PrepareExternal Prepare SQL select * from (select * from <DB>[<USER>].<TABLE>) T0 WHERE 1=0 Exchange; producerID=*****; requestID=0xffffffff; sessionID=0xffffffff; [nQSError: 17001] Oracle Error code: 907, message: ORA-00907: missing right parenthesis at OCI call OCIStmtExecute
Error message in DV UI:
Step |j| Execution failed. Status: FAILED. Message: [nQSError: 46236] Dataset Service error during Create Embryonic External Dataset - {"prefix":"DSS","code":***,"message":"Invalid Database Name","subMessage":"Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.\n[nQSError: 17001] Oracle Error code: 907, message: ORA-00907: missing right parenthesis\n at OCI call OCIStmtExecute.\n[nQSError: 17010] SQL statement preparation failed.\nAction: Please refer to logs for more Details"}[nQSError: 43224] The Dataflow "<Data_Flow>" failed during the execution.[nQSError: 43204] Asynchronous Job Manager failed to execute the asynchronous job.
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 |