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(SQLDiagnostic.java:379)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at piloto3.insertpersons.InsertPersons.tSugarCRMInput_1Process(InsertPersons.java:1101)
at piloto3.insertpersons.InsertPersons.runJob(InsertPersons.java:1303)
at piloto3.insertpersons.InsertPersons.main(InsertPersons.java:1242)
could anyone help me with this?
thanks in advance!
2 REPLIES
Community Manager

Re: Error using tMSSqlOutput. Could someone help me?

Hi
Which version of TOS did you use?
Best regards
shong
----------------------------------------------------------
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
Thanks!