Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

ORA 12592:TNS:bad packet error

AnandKumar1
8 - Asteroid

Hi,

 

I'm trying to load my workflow output to ORACLE table but getting TNS bad packet error. But when i try to load the data to other table i'm not getting any error.

I tried using Block until done before Output but no help. I've tried saving the output as a .csv and then writing this csv to Oracle table but still no help.

 

I've tried changing to Oracle bulk but then i get "Error running TRUNCATE TABLE" error ( I'm doing delete data and append) and i cannot this permission from my DBA also.

 

Is there any other way to solve this issue?

 

Thanks,

Anand

 

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @AnandKumar1 

 

One user seems to have found a soltution for a problem similar to yours and quoting:

 

To fix this I changed all VW_String data types to V_String data types, and I also changed all precision to at least 255 in a Select tool in the Alteryx workflows as well as in the database tables.

 

This seemed to work to him.

 

You could try chainging first the fields to V_string and if not do the second part. Before doing any modifications in the database tables be sure this won't affect any other worfkows or processes. This kind of modifications should be done in a controlled enviroment (lab database or equivalent)

 

Regards

AnandKumar1
8 - Asteroid

There were some NULL value in output but in Oracle DB it was set to not null. So i've asked DB guys to make it Nullable and it works now.

Labels