Newest Alteryx gives any Oracle Database connections unknown error in PI_PushAllRecords

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?

Bug

Database Connection

Accepted answers

All comments

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703