Two Stars

Error using tMSSqlOutput. Could someone help me?

hello people, how are you? im trying to integrate sugarcrm's users table with a table of sql server 2000.
So, i have:
tSugarCRMInput_1 ----> tMap ----> tMSSqlOutput
When i run the job the following error appears
Exception in component tMSSqlOutput_1
java.sql.DataTruncation: Data truncation
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(
at piloto3.insertpersons.InsertPersons.tSugarCRMInput_1Process(
at piloto3.insertpersons.InsertPersons.runJob(
at piloto3.insertpersons.InsertPersons.main(
could anyone help me with this?
thanks in advance!
Community Manager

Re: Error using tMSSqlOutput. Could someone help me?

Which version of TOS did you use?
Best regards
Talend | Data Agility for Modern Business
Two Stars

Re: Error using tMSSqlOutput. Could someone help me?

hello shong, thanks for reply. i have found what was causing this error.
I was that on sugarcrm i have a record with 55 characters but on my sql server the mapping has to be lower than 50. I had put on the sql server mapping the length to 50, but these doesn't work... so i've mapped with myString.substring(0, 50) and it worked well