community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Oracle Table Load - Prioritizationn

Meteor

I am trying to use Alteryx as an ETL error to read data from an oracle database, manipulate the data and load it into another oracle database...

I have come across Bad Packet errors, TimeOut errors etc and could not really identify a pattern for these errors...

 

I got better results when I triied to put a Block Until Done right right before the input tool...

 

I now have a scenario where I have to load 5 different tables within the same workflow...

Below is a simple description of my workflow with any data manipulations... 

 

Disabling 3 containers and refreshing only 1 container takes 30 seconds for each of the below processes...

Running all 4 at the same time seems to hang my alteryx... I am thinking having multiple block until done might be causing an issue...

 

Any insight on running containers in a sequence will be helpful... 

And any knowledge on Oracle database load errors will be great....

 

 

Alteryx Oracle.jpg

Highlighted
Meteor

Below is an additional image of the table load which is taking the longest time to load -


My connecttion is "oci oracle database"...

I tried transaction sizes 1,100,1000,10000

 

I am not even sure why the Output is showing a percentage without the Block Until Done becoming 100%....

Alteryx Oracle.jpg 

Labels