topic Re: String value error in Talend Studio

String value error

Anonymous — Thu, 08 Jun 2017 11:21:28 GMT

Hi,

I'm pulling data from "MSSQL" to "MYSQL".

Based on the query columns I'm mapping the columns and inserting the records to MYSQL

So I'm trying to use tconvertype to resolve the issue.

*Both database db types are same same but still im getting this error.

* For one column i have value : DSO/PUN/2016-17/0008

* Please let me know any other alternative solutions if any.

Re: String value error

cterenzi — Thu, 08 Jun 2017 11:24:59 GMT

Talend is trying to put that value into a column of type Integer. As that value is not an Integer, Talend can't complete the process. Is that the right type for that column in your schema?

Re: String value error

Anonymous — Thu, 08 Jun 2017 11:34:37 GMT

My DB type is String in both the tables.

Please find the attached screenshot

Re: String value error

vapukov — Thu, 08 Jun 2017 11:35:14 GMT

double check schemas:

- real database schema (types)

- tMSSQLInput schema

- look not only on name and types, but as well for order of columns in query and component schema

P.S. because You add screenshot - schema order, Talend put columns by number, not by name

also check - what is it Var.salesordernum

Re: String value error

Anonymous — Fri, 09 Jun 2017 06:51:52 GMT

Hi Vapukov,

Thnx for your speed reply.

After done the changes as per you instructions it executed 1150 records after that i got an error as below

Starting job May28 at 10:35 09/06/2017.
[statistics] connecting to socket on port 3874
[statistics] connected
[trace] connecting to socket on port 4814
[trace] connected

Exception in component tMSSqlInput_1 (May28)
java.sql.SQLException: Divide by zero error encountered.
   at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
   at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
   at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
   at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:805)
   at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:611)
   at test.may28_0_1.May28.tMSSqlInput_1Process(May28.java:2571)
   at test.may28_0_1.May28.runJobInTOS(May28.java:5122)
   at test.may28_0_1.May28.main(May28.java:4964)
[statistics] disconnected
[trace] disconnected
Job May28 ended at 11:00 09/06/2017. [exit code=1]

Re: String value error

Anonymous — Mon, 12 Jun 2017 00:47:45 GMT

In some of the input you are encountering zero value and that's why you are getting this error. Please check your input data and the operation you are trying to do. Check before performing the division, if input is zero or not.

@Rohit wrote:

Hi Vapukov,

Thnx for your speed reply.

After done the changes as per you instructions it executed 1150 records after that i got an error as below

Starting job May28 at 10:35 09/06/2017.
[statistics] connecting to socket on port 3874
[statistics] connected
[trace] connecting to socket on port 4814
[trace] connected

Exception in component tMSSqlInput_1 (May28)
java.sql.SQLException: Divide by zero error encountered.
   at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
   at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
   at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
   at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:805)
   at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:611)
   at test.may28_0_1.May28.tMSSqlInput_1Process(May28.java:2571)
   at test.may28_0_1.May28.runJobInTOS(May28.java:5122)
   at test.may28_0_1.May28.main(May28.java:4964)
[statistics] disconnected
[trace] disconnected
Job May28 ended at 11:00 09/06/2017. [exit code=1]