community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

untranslatable character error

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

Alteryx
Alteryx

@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
Highlighted
Alteryx Certified Partner

@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

Asteroid

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

Labels