Error on SQL Server

[Anonymous]

Dear All,

I'm trying to pump data to Database using ODMS_DB(tDBOutput), but this error occurred. What is the meaning of the error below? 

Exception in component tDBOutput_1 (offlinetemplate_test)
com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Length or precision specification 0 is invalid.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)
at local_project.offlinetemplate_test_0_1.offlinetemplate_test.tFileInputExcel_2Process(offlinetemplate_test.java:3378)
at local_project.offlinetemplate_test_0_1.offlinetemplate_test.runJobInTOS(offlinetemplate_test.java:5721)
at local_project.offlinetemplate_test_0_1.offlinetemplate_test.main(offlinetemplate_test.java:5571)

[Anonymous]

Hi
Can you upload a screenshot of the schema of tDBOutput_1? What's the data type of this column?

Regards
Shong

[Anonymous]

Dear Shong,

[Anonymous]

What is the option in the Action on table on tDBOutput_1?
Have a try to remove "0" from the precision column on the schema.

[Anonymous]

Action on table: Create table

Action on data: Insert

Yes, I've tried removing the 0, same error

[Anonymous]

Hi
If you create the table on tDBOutput component, you should specify the length for each column. From your screenshot, I see the length is empty on some column.

[Anonymous · Accepted solution]

Hi,

    You are missing length for region and cluster varchar columns. When you create table, you need to specify the length for all varchar columns.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved