String value error

[Anonymous]

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.

[cterenzi]

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?

[Anonymous]

My DB type is String in both the tables.

Please find the attached screenshot

[vapukov]

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

[Anonymous]

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]

[Anonymous]

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]

---