Forum Discussion

Guillaume_'s avatar
Guillaume_
Icon for Helper I rankHelper I
4 years ago

Incremental Dataflow on Oracle ADW ORA-01013: user requested cancel of current operation

I've setup an incremental dataflow on a premium capacity fetching data from a failry large table (50m+ rows) on Oracle ADW via a DataGateway. I've partitioned the dataflow into 24 months. Each parti...
Dataflow
Need Help
Guillaume_'s avatar
Guillaume_
Icon for Helper I rankHelper I
3 years ago

The workaround found so far is to setup the connection to ADW as low. This limits the number of parallel processing of queries and consequently have more resource available for concurrent queries.

This seems to work so far after a few tries.

vpertsovsky's avatar
vpertsovsky
Frequent Visitor
3 years ago

Hello, I'm having the same issue with large incremental refresh and Oracle.  Can you explain what you meant by "setup the connection to ADW as low".  Where do you setup this option?

 

Thank you