Error exporting data from EDB into Oracle

One Star

Error exporting data from EDB into Oracle

I am trying to export data from an EDB database into an Oracle table.I am encountering the below error and would aprpeciate any guidance.Thanks in advance.
------
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-00907: missing right parenthesis
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
at dailyload.swg_dwhs_0_1.swg_dwhs.tPostgresqlInput_1Process(swg_dwhs.java:1065)
connecting to socket on port 3372
connected
------
Rachana
Community Manager

Re: Error exporting data from EDB into Oracle

Hello
java.sql.SQLException: ORA-00907: missing right parenthesis

The probalble cause is a left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses, All parentheses must be entered in pairs. Please Correct the syntax and retry the statement.
Aslo, please go to code generated tab and show your sql statement.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Error exporting data from EDB into Oracle

I had the same problem, so I fixed it changing the source column name : "STATE I/O" to "STATE", one hour later.... If you can´t modifiy the source column name maybe you can write a view.
One Star

Re: Error exporting data from EDB into Oracle

I am getting this error , in tOracleInput_2 component, I verified very clearly the quotes are matching .In my case I am getting this error if I pass dates to a where condition through context variable like ( table1.date1>="+context.loaddate+") this. If I pass hard coded values in place of context query runs. 
Please suggest , don't throw generic replies.
Exception in component tOracleInput_2
java.sql.SQLException: ORA-00907: missing right parenthesis
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315)
Moderator

Re: Error exporting data from EDB into Oracle

Hi krisreddy,
Could you please go to code generated tab and show us your sql statement.(marked ad red line)?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.