My Oracle Support Banner

Dataflow Fails With Unable To Rename Table In OAC (Doc ID 3056048.1)

Last updated on NOVEMBER 04, 2024

Applies to:

Oracle Analytics Cloud - Version N/A and later
Information in this document applies to any platform.

Symptoms

Scenario:

Created a dataset DS1 with Excel file.

Create a dataflow DTFLOW using the dataset DS1 and save the output data to database table DFTABLE using database Connection.

Run the dataflow and dataflow fails with below error.

Error:

The following dataflow(s) have failed:
************************************************************
* DFLW : DTFLOW
************************************************************
"dataflow : 'user'.'DTFLOW'" on BIJDBC submitted with job id <JOB-ID>
Finished execution with status Failed
Execution failed.
[nQSError: 17011] SQL statement execution failed.
[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist
at OCI call OCIStmtExecute.
[nQSError: 59166] Unable to rename table DTFLOW_<INDEX> to DFTABLE.
[nQSError: 43224] The Dataflow "DTFLOW" failed during the execution.
[nQSError: 43204] Asynchronous Job Manager failed to execute the asynchronous job.
Execution time :19 second(s), 152 millisecond(s)

Changes

 

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
Changes
Cause
Solution


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