String value error

Highlighted
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.

 

 

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

Forteen 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]

Seven 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]


 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch