Four Stars

String value error

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

error.png

 

 

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

 

 

  • Data Integration
5 REPLIES
Ten Stars

Re: String value error

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?
Four Stars

Re: String value error

My DB type is String in both the tables.db_type.png

Please find the attached screenshot

Nine Stars

Re: String value error

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

-----------
Four Stars

Re: String value error

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]

Six Stars

Re: String value error

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]



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]