Newest Alteryx gives any Oracle Database connections unknown error in PI_PushAllRecords

[aihnen]

I just downloaded the latest version of Alteryx, 2020.4.5.12471, and now all my oracle database connections fail with this error "An unknown error occured in PI_PushAllRecords". I have a few different workflows running on scheduler that use these database connections and now they are all erroring out and I cannot figure out why. I have checked the ODBC connection and everything seems to work but when I run any workflow that contains them it shows this error directly at the Data Input tool. I have actually run them on an older version of Alteryx and they work fine. Any thoughts on why this might be happening? 

 

[BrandonB]

If you haven't already, can you please send an email to support@alteryx.com? I think I have seen this once before when the field sizes oracle was trying to return were much larger than they needed to be for some reason. As a test can you try copying one of your workflows Input Data tools into a new workflow and modifying the SQL to cast the fields to smaller sizes to see if you can get the query to execute if this is the case? 

[aihnen]

Unfortunately, I know already that the size of the fields within the database are fairly small so this shouldn't be an issue (e.g. ID# with total of 8 digits has size of 8). Would there be some reason these fields be larger than they are within the database when its pulled by the Input Data tool? I'll try out your solution though as well as send an email to Alteryx support. Thanks for the response Brandon!

[BrandonB]

Yep that's exactly what I'm curious about as you have described with potentially small sized fields that are trying to be pulled in as larger fields. 

[BrandonB]

This is the post that has me thinking it might be the case: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Getting-an-error-Input-Data-1-An-unkno...

[aihnen]

Brandon, can you help me with some sample SQL statement to do this? I have tried a few variations of SQL that I have thought may do this but have not been successful. I have even uninstalled the most recent version of Alteryx and reinstalled 2020.3 and am still getting this error. Any help is appreciated!

[BrandonB]

Before you try writing the SQL to cast the data, can you take a look at the visual query builder to see the data types and sizes of the table?

 

[aihnen]

The data types and sizes are ok (actually sizes are quite small). I reached out to Alteryx Support, they helped me determine I had 2 different version of Oracle installed. This was confusing Alteryx on which one to use. 

[BrandonB]

Nice, glad you got it figured out! Yeah, Oracle doesn't have the most straightforward driver installation/configuration processes so I could see how that could happen.

Happy holidays!