[resolved] insert data into MS Sql server

One Star

[resolved] insert data into MS Sql server

Hello!
I get the follow error on trying to insert data into MS Sql Server

Exception in component tMSSqlOutput_1
java.sql.SQLException: Line 1: Length or precision specification 0 is invalid.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
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.JtdsStatement.executeImpl(JtdsStatement.java:664)

What is wrong?
Could you help me plese?
Gisella

Accepted Solutions
One Star

Re: [resolved] insert data into MS Sql server


All Replies
One Star

Re: [resolved] insert data into MS Sql server

Check that the schema which is in use for the tMSSQLOutput_1 component has the appropriate data lengths included for all fields (under edit schema in the component).
I believe the lengths need to be included as part of the schema for validation purposes.
One Star

Re: [resolved] insert data into MS Sql server