untranslatable character error

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

Database Connection

Accepted answers

jrgo

@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

All comments

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

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

Kavya432

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335