My Oracle Support Banner

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


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