untranslatable character error

[Kavya432]

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

[DiganP]

@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. 

[jrgo · Accepted solution]

@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]

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