Hi, I am trying to connect Oracle data base. when i am running a job I am getting this error. Please find bellow. Could you please suggest me. Exception in component tOracleInput_1 java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) 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:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387) at salesforce.test_0_1.Test.tOracleInput_1Process(Test.java:1745) at salesforce.test_0_1.Test.tSetProxy_1Process(Test.java:1338) at salesforce.test_0_1.Test.tFileInputProperties_1Process(Test.java:1230) at salesforce.test_0_1.Test.runJobInTOS(Test.java:2507) at salesforce.test_0_1.Test.main(Test.java:2157) disconnected Thank you, Praveen
Hi Shong,
I Build the job same way as you said,
Job properties files--main-->Load properties File to context
|
onsubjobok
|
proxy info
|
onsubjobok
|
tAs400Input-->tMap-->tOracleOutput
But still the problem is not sloved. I am thinking on data types. Can you please find this data types: