topic Re: Error on SQL Server in Talend Studio

Error on SQL Server

Anonymous — Sat, 16 Nov 2024 04:16:35 GMT

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)

Re: Error on SQL Server

Anonymous — Fri, 25 Oct 2019 04:17:42 GMT

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

Regards
Shong

Re: Error on SQL Server

Anonymous — Fri, 25 Oct 2019 04:19:55 GMT

Dear Shong,

Re: Error on SQL Server

Anonymous — Fri, 25 Oct 2019 04:27:28 GMT

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.

Re: Error on SQL Server

Anonymous — Fri, 25 Oct 2019 04:35:23 GMT

Action on table: Create table

Action on data: Insert

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

Re: Error on SQL Server

Anonymous — Fri, 25 Oct 2019 04:59:39 GMT

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.

Re: Error on SQL Server

Anonymous — Fri, 25 Oct 2019 18:44:15 GMT

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