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

untranslatable character error

Kavya432
8 - Asteroid

Hi Team,

 

I am trying to insert into teradata table. I am receiving below message. Any idea how to resolve this issue?

 

Error: Output Data (287): DataWrap2ODBC::SendBatch: [Teradata][ODBC Teradata Driver][Teradata Database] The string contains an untranslatable character. Insert into "CA_Business_Info_Team"."NWACD_Attendee"("Concentration","Descipline","Course_Descriptor","Training_Type","Course_Title","Course_Date","Last_Name","First_Name","State","Producer_Type","Short_Name","DimProducer_Id","Region","RVP","AVP","Sales_Director","Sales_Manager","Agency_Name","Email","Dist","AID","Status","Count","Location","Delivery_Team","LMS_Source","Content_Owner","EMP_ID","Meeting_ID","Delivery_Hours","Agent_Producer_No_","Attestations","Consumption","Description","Full_Name","Job_Level","Job_Title","No_Direct_Reports","Service_Time","UACChannel_Cd","UACSource_Cd") Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

 

 

Thanks

Kavya

3 REPLIES 3
DiganP
Alteryx Alumni (Retired)

@Kavya432 There could be a special character in the dataset that the driver cannot read and insert into the table. What I would do is try to create a table with a sample tool, limiting the amount of rows going in. First try, try 1000 rows then 1500 rows and see where the issue is occurring. You can then find out that special character and get rid of it within the workflow. 

Digan
Alteryx
jrgo
14 - Magnetar

@Kavya432 

 

Sounds like a special, character is showing up in one of your fields. May be challenging in trying to find it, especially if there's a lot of records you're attempting to insert.

 

You could try putting a Select tool before the Output tool and see if any of the fields are showing up as V_WString or WString. If you do, try changing them to V_String and see if the insert completes.

 

Note that this may modify the value in the record so it will no longer match up with the source system which generated the data so you'll still want to try and identify what special characters are showing up in your data to make sure that it being altered does not have a negative outcome downstream.

Jimmy
Teknion Data Solutions

Kavya432
8 - Asteroid

It helped. The data has been loaded. Thanks a lot Jimmy. Appreciate you help.

Labels