Tech Notes http://brinkerhoff.org/w Just another WordPress site Thu, 31 Jan 2013 21:47:13 +0000 en-US hourly 1 http://wordpress.org/?v=3.4.2 Talend, SalesForce http://brinkerhoff.org/w/?p=4 http://brinkerhoff.org/w/?p=4#comments Thu, 31 Jan 2013 21:37:39 +0000 sbrinkerhoff http://brinkerhoff.org/w/?p=4 Continue reading →]]> While attempting to ETL a SalesForce object from SalesForce to Microsoft SQL Server using Talend 5.2.0 the following error presented:

[statistics] connected
Exception in component tMSSqlOutput_2
java.sql.SQLException: Line 1: Length or precision specification 0 is invalid.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
    at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
    at general_etl.servicemax_0_1.ServiceMax.tSalesforceInput_2Process(ServiceMax.java:6198)
    at general_etl.servicemax_0_1.ServiceMax.runJobInTOS(ServiceMax.java:9086)
    at general_etl.servicemax_0_1.ServiceMax.main(ServiceMax.java:8939)
[statistics] disconnected

The issue seems to be caused by columns that are identified as the ‘float’ datatype. Opening the Microsoft SQL destination table properties, and definiting a data length for each column that was a ‘float’ cleared up the problem.

]]> http://brinkerhoff.org/w/?feed=rss2&p=4 0 Hello world! http://brinkerhoff.org/w/?p=1 http://brinkerhoff.org/w/?p=1#comments Thu, 08 Nov 2012 20:41:50 +0000 sbrinkerhoff http://brinkerhoff.org/w/?p=1 Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

]]> http://brinkerhoff.org/w/?feed=rss2&p=1 1