Getting an error :Input Data (1): An unknown error occurred in PI_PushAllRecords.

Hello,

I am trying to connect Oracle database via Server connection made on Company's gallery. while connecting, i can see data in preview section but after running process i am getting an error : Input Data (1): An unknown error occurred in PI_PushAllRecords.

Thanks,

Input

Error Message

Accepted answers

JoeS

Hi @SHAANKI

This error may be due to field types in the database.

Do you have any fields that are coming through with an abnormal type or really long length?

If so maybe trying casting them to something else in the select statement to see if that works.

All comments

JoeS

Hi @SHAANKI

This error may be due to field types in the database.

Do you have any fields that are coming through with an abnormal type or really long length?

If so maybe trying casting them to something else in the select statement to see if that works.

matthewbechard

I am getting this same error connection to Oracle. I am running Alteryx Designer 2018.2.4x. I have reinstalled both my oracal drivers and alteryx. I can preview rows. I had another user running the same version of alteryx run the same db query using a service account and it works on his machine. I am stumped.

Matt

matthewbechard

I am getting this same error connection to Oracle. I am running Alteryx Designer 2018.2.4x. I have reinstalled both my Oracle drivers and alteryx. I can preview rows. I had another user running the same version of alteryx run the same db query using a service account and it works on his machine. I am stumped.

Matt

calan

Adding a select tool, and changing the size of the strings worked for me. For some reason, the sizes were WAY larger than they needed to be. Reducing them to 255 in the select tool resolved this issue for me.

alteryx.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703