topic Re: TOS 3.1.1 Error in Talend Studio

TOS 3.1.1 Error

Anonymous — Sat, 16 Nov 2024 13:53:55 GMT

I'm currently involved in a very large project where we have to transfer data from our Informix DB to PostgreSQL.
I am trying to test using Talend Open Studio and I'm running into some problems. I created a job to test and keep getting the following:
Starting job Cards at 15:07 25/06/2009.
Exception in component tInformixInput_1
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3244)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3553)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:218)
at nitro.cards_0_1.Cards.tInformixInput_1Process(Cards.java:1399)
at nitro.cards_0_1.Cards.runJobInTOS(Cards.java:2087)
at nitro.cards_0_1.Cards.main(Cards.java:2005)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558)
... 10 more
I'm using:
tInformixInput
tMap -- Since the table structures are different
tPostgresqlOutput
I thought this was all I needed but I'm getting the above errors.

Re: TOS 3.1.1 Error

Anonymous — Fri, 26 Jun 2009 14:00:39 GMT

Hello,
I think you have a problem with your SQL Statement on the informix component.
Can you give us your SQL Query? What is the result of "Guess Schema" button on the tInformixInput component?
Thank,

Re: TOS 3.1.1 Error

Anonymous — Fri, 26 Jun 2009 15:32:02 GMT

This is the sql produced by Guess query,
"SELECT account.\"account \",
account.\"pin \",
account.\"client_id \",
account.\"group_id \",
account.\"pref_id \",
account.\"custcode \",
account.\"cust_host \",
account.\"loy_percent \",
account.\"expire_date \",
account.\"status \",
account.\"create_type \",
account.\"life_cycle_status \",
account.\"card_type \",
account.\"activated \",
account.\"enrolled \",
account.\"loy_redemp_ok \",
account.\"activated_date \",
account.\"enroll_date \",
account.\"issuer \",
account.\"card_is_test \",
account.\"create_id \",
account.\"create_dtime \",
account.\"deact_dtime \",
account.\"min_bal \"
FROM account"
but I only need 4 columns, this is the query I used
"SELECT \"account\".\"account\",
\"account\".\"pin\",
\"account\".\"create_dtime\",
\"account\".\"expire_date\"
FROM \"account\""
Should I remove the extra \ and " ?
thank you

Re: TOS 3.1.1 Error

Anonymous — Fri, 26 Jun 2009 15:46:08 GMT

Yes, you can try without \" and without space right.
It's a strange behaviour. What is your version of TOS?

Re: TOS 3.1.1 Error

Anonymous — Fri, 26 Jun 2009 16:01:20 GMT

TOS 3.1.1

Re: TOS 3.1.1 Error

Anonymous — Fri, 26 Jun 2009 16:56:00 GMT

Ok Thank.
What is the result after editon of the SQL Query?

Re: TOS 3.1.1 Error

Anonymous — Mon, 29 Jun 2009 04:16:17 GMT

Hello
THere are some bug on 'guess query' button,
8017
7563
At the moment, you can edit the sql statement manuallly,eg:
"SELECT account.account,
account.pin,
account.create_dtime,
account.expire_date
FROM account"
Best regards

shong

Re: TOS 3.1.1 Error

Anonymous — Mon, 29 Jun 2009 15:04:31 GMT

Modified sql as shown, still get the following:
Starting job Cards at 10:04 29/06/2009.
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Syntax error on token "SELECT", , expected
account cannot be resolved
account cannot be resolved
account cannot be resolved
account cannot be resolved
Syntax error, insert ")" to complete MethodInvocation
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
FROM cannot be resolved to a type
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
String literal is not properly closed by a double-quote
String literal is not properly closed by a double-quote
Syntax error on token "SELECT", , expected
Syntax error, insert ")" to complete MethodInvocation
Syntax error, insert ";" to complete Statement
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
at nitro.cards_0_1.Cards.tInformixInput_1Process(Cards.java:1421)
at nitro.cards_0_1.Cards.runJobInTOS(Cards.java:2128)
at nitro.cards_0_1.Cards.main(Cards.java:2046)
Job Cards ended at 10:04 29/06/2009.

Re: TOS 3.1.1 Error

Anonymous — Tue, 30 Jun 2009 15:58:21 GMT

OK, I updated to 3.1.2 and now I get this:
Execution failed :generationManager is not initialized by the perljet/javajet!

Re: TOS 3.1.1 Error

Anonymous — Wed, 01 Jul 2009 06:39:14 GMT

Hello

Exception in thread "main" java.lang.Error: Unresolved compilation problems:

There are some compile error in your sql, open 'Code' tab and you will see the error, it looks you don't close the sql with double quote. Can you create a simpe table just with one or two filed and test?
Best regards
shong

Re: TOS 3.1.1 Error

Anonymous — Wed, 01 Jul 2009 13:36:07 GMT

I HAVE DOUBLE QUOTES AT THE END OF THE SQL.
I also get something new with 3.1.2 when starting the application:
An internal error occurred during: "Generation Engine Initia;ization in progres...",
java.lang.NullPointerExeption

Re: TOS 3.1.1 Error

Anonymous — Thu, 18 Aug 2016 12:50:06 GMT

Hi there,
TMAP Expression: row2.Inactive == "-1" ? true : false
Inactive: String Type
Destination field: Boolean Type
Error:Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Help me with it