9 Replies Latest reply on Nov 3, 2014 8:43 AM by shawkins

Error executing statement with Oracle 11g

vince_fr Oct 30, 2014 11:36 AM

Hi Datavirt masters,

I'm currently virtualizing some Oracle 11g tables with the JBDS.

I did the Source Model for my table, with the JBDS wizard. Went fine, can see my table in the studio and can preview the data.

Then I created a VDB from that source model, went fine.

But I started to face issues when trying to query my VDB with the Database Development tool from JBDS.

Having the same issues with a simple Squirrel SQL after publishing my VDB on the server.

Here is the error output (CEREP is the vdb name, it's also the name of my source model), after submitting a "select * from CEREP_RATING" or submitting a "select RAT_ID_PK from CEREP_RATING "

Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 CEREP: 40042 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23, c_24, c_25, c_26, c_27, c_28, c_29, c_30, c_31, c_32, c_33, c_34, c_35, c_36, c_37, c_38, c_39, c_40, c_41, c_42, c_43, c_44, c_45, c_46, c_47, c_48, c_49, c_50, c_51 FROM (SELECT g_0."RAT_ID_PK" AS c_0, g_0."RAT_REPORTING_PERIOD_FK" AS c_1, g_0."RAT_RATING_PERIOD_FK" AS c_2, g_0."RAT_CRA_IDENTIFIER_FK" AS c_3, g_0."RAT_REA_WITHDRAWAL_REASON_FK" AS c_4, g_0."RAT_RDS_CODE_FK" AS c_5, g_0."RAT_BIC_STD_ISSUER_ID_FK" AS c_6, g_0."RAT_CFI_FILE_NAME_FK" AS c_7, g_0."RAT_REPORTING_PERIOD" AS c_8, g_0."RAT_RATING_PERIOD" AS c_9, g_0."RAT_RATING_PERIOD_START" AS c_10, g_0."RAT_RATING_PERIOD_END" AS c_11, g_0."RAT_RATING_IDENTIFER" AS c_12, g_0."RAT_RATING_NAME" AS c_13, g_0."RAT_DEFAULT" AS c_14, g_0."RAT_WITHDRAWAL" AS c_15, g_0."RAT_NOT_VALUE_BOP" AS c_16, g_0."RAT_NOT_VALUE_EOP" AS c_17, g_0."RAT_NOT_BOP_FK" AS c_18, g_0."RAT_NOT_EOP_FK" AS c_19, g_0."RAT_CRY_VERS_ID_FK" AS c_20, g_0."RAT_THO_VERS_ID_FK" AS c_21, g_0."RAT_IND_VERS_ID_FK" AS c_22, g_0."RAT_SUL_VERS_ID_FK" AS c_23, g_0."RAT_GAR_VERS_ID_FK" AS c_24, g_0."RAT_RTT_VERS_ID_FK" AS c_25, g_0."RAT_LOI_VERS_ID_FK" AS c_26, g_0."RAT_SAT_VERS_ID_FK" AS c_27, g_0."RAT_AST_VERS_ID_FK" AS c_28, g_0."RAT_SEC_VERS_ID_FK" AS c_29, g_0."RAT_CAT_VALUE_BOP" AS c_30, g_0."RAT_CAT_VALUE_EOP" AS c_31, g_0."RAT_GEOG_AREA_ID_COUNTRY_CODE" AS c_32, g_0."RAT_ASSET_SUBASSET" AS c_33, g_0."RAT_VINTAGE_YEAR" AS c_34, g_0."RAT_INT_INSTR_ID" AS c_35, g_0."RAT_STD_INSTR_ID" AS c_36, g_0."RAT_INTER_ISSU_ID" AS c_37, g_0."RAT_NEW_RATING" AS c_38, g_0."RAT_REASON_HISTO_CHG" AS c_39, g_0."RAT_REASON_HISTO_CAN" AS c_40, g_0."RAT_RESP_CRA_UNIQ_ID" AS c_41, g_0."RAT_CREATION_DATE_TIME" AS c_42, g_0."RAT_CANCEL_DATE_TIME" AS c_43, g_0."RAT_IS_ALREADY_PUB" AS c_44, g_0."RAT_IS_PUBLISHED" AS c_45, g_0."RAT_HIST_AMENDMENT" AS c_46, g_0."RAT_COMPLETNESS" AS c_47, g_0."LAST_UPDATE_DATE_TIME" AS c_48, g_0."LAST_UPDATE_PREPUB" AS c_49, g_0."LAST_UPDATE_PUB" AS c_50, g_0."RAT_GEOG_AREA_EU_MEMBER" AS c_51 FROM "CEREP_DBA_USER"."CEREP_RATING" g_0) WHERE ROWNUM <= 100]

SQLState: 38000

ErrorCode: 30504

I tried to create a view model based on the source model to see if I could workaround this issue but it didn't change anything.

Many thanks for your suggestions or help.

Vince

1. Re: Error executing statement with Oracle 11g

rareddy Oct 30, 2014 12:39 PM (in response to vince_fr)

What is the error in your server.log?
Actions
2. Re: Error executing statement with Oracle 11g

vince_fr Oct 31, 2014 6:17 AM (in response to rareddy)

Hi Ramesh,

Thanks again for taking care.

Which server.log ? The Oracle one ?
Or the jboss one ?
Here is the jboss log below. It crashed when I ask for "data/sample contents" from the Database Development perspective within JBDS.
I can see there is an issue with parsing the query but I can't explain why since I followed a typical process to virtualize this oracle table ...

Many thanks

Vince

*********************************************************************************
11:13:24,034 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue7) OracleExecutionFactory Commit=true;DatabaseProductName=Teiid Embedded;DatabaseProductVersion=8.4;DriverMajorVersion=8;DriverMajorVersion=4;DriverName=Teiid JDBC Driver;DriverVersion=8.4;IsolationLevel=2
11:13:24,080 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue7) TEIID30020 Processing exception for request JSXduwq1aIUq.0 'TEIID31100 Parsing error: Encountered "g_0.\"RAT_GAR_VERS_ID_FK\" [*]AS[*] c_24," at line 1, column 1156.
Was expecting: "and" | "as" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "or" | "similar" ...'. Originally QueryParserException QueryParser.java:215. Enable more detailed logging to see the entire stacktrace.
11:13:24,083 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue7) Connector worker process failed for atomic-request=gz19si/K2dXh.3.0.0: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23, c_24, c_25, c_26, c_27, c_28, c_29, c_30, c_31, c_32, c_33, c_34, c_35, c_36, c_37, c_38, c_39, c_40, c_41, c_42, c_43, c_44, c_45, c_46, c_47, c_48, c_49, c_50, c_51 FROM (SELECT g_0."RAT_ID_PK" AS c_0, g_0."RAT_REPORTING_PERIOD_FK" AS c_1, g_0."RAT_RATING_PERIOD_FK" AS c_2, g_0."RAT_CRA_IDENTIFIER_FK" AS c_3, g_0."RAT_REA_WITHDRAWAL_REASON_FK" AS c_4, g_0."RAT_RDS_CODE_FK" AS c_5, g_0."RAT_BIC_STD_ISSUER_ID_FK" AS c_6, g_0."RAT_CFI_FILE_NAME_FK" AS c_7, g_0."RAT_REPORTING_PERIOD" AS c_8, g_0."RAT_RATING_PERIOD" AS c_9, g_0."RAT_RATING_PERIOD_START" AS c_10, g_0."RAT_RATING_PERIOD_END" AS c_11, g_0."RAT_RATING_IDENTIFER" AS c_12, g_0."RAT_RATING_NAME" AS c_13, g_0."RAT_DEFAULT" AS c_14, g_0."RAT_WITHDRAWAL" AS c_15, g_0."RAT_NOT_VALUE_BOP" AS c_16, g_0."RAT_NOT_VALUE_EOP" AS c_17, g_0."RAT_NOT_BOP_FK" AS c_18, g_0."RAT_NOT_EOP_FK" AS c_19, g_0."RAT_CRY_VERS_ID_FK" AS c_20, g_0."RAT_THO_VERS_ID_FK" AS c_21, g_0."RAT_IND_VERS_ID_FK" AS c_22, g_0."RAT_SUL_VERS_ID_FK" AS c_23, g_0."RAT_GAR_VERS_ID_FK" AS c_24, g_0."RAT_RTT_VERS_ID_FK" AS c_25, g_0."RAT_LOI_VERS_ID_FK" AS c_26, g_0."RAT_SAT_VERS_ID_FK" AS c_27, g_0."RAT_AST_VERS_ID_FK" AS c_28, g_0."RAT_SEC_VERS_ID_FK" AS c_29, g_0."RAT_CAT_VALUE_BOP" AS c_30, g_0."RAT_CAT_VALUE_EOP" AS c_31, g_0."RAT_GEOG_AREA_ID_COUNTRY_CODE" AS c_32, g_0."RAT_ASSET_SUBASSET" AS c_33, g_0."RAT_VINTAGE_YEAR" AS c_34, g_0."RAT_INT_INSTR_ID" AS c_35, g_0."RAT_STD_INSTR_ID" AS c_36, g_0."RAT_INTER_ISSU_ID" AS c_37, g_0."RAT_NEW_RATING" AS c_38, g_0."RAT_REASON_HISTO_CHG" AS c_39, g_0."RAT_REASON_HISTO_CAN" AS c_40, g_0."RAT_RESP_CRA_UNIQ_ID" AS c_41, g_0."RAT_CREATION_DATE_TIME" AS c_42, g_0."RAT_CANCEL_DATE_TIME" AS c_43, g_0."RAT_IS_ALREADY_PUB" AS c_44, g_0."RAT_IS_PUBLISHED" AS c_45, g_0."RAT_HIST_AMENDMENT" AS c_46, g_0."RAT_COMPLETNESS" AS c_47, g_0."LAST_UPDATE_DATE_TIME" AS c_48, g_0."LAST_UPDATE_PREPUB" AS c_49, g_0."LAST_UPDATE_PUB" AS c_50, g_0."RAT_GEOG_AREA_EU_MEMBER" AS c_51 FROM "CEREP_DBA_USER"."CEREP_RATING" g_0) WHERE ROWNUM <= 50]
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:113) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65]
        at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_65]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_65]
        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65]
Caused by: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "g_0.\"RAT_GAR_VERS_ID_FK\" [*]AS[*] c_24," at line 1, column 1156.
Was expecting: "and" | "as" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "or" | "similar" ...
        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:668) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:512) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:258) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
        ... 12 more
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "g_0.\"RAT_GAR_VERS_ID_FK\" [*]AS[*] c_24," at line 1, column 1156.
Was expecting: "and" | "as" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "or" | "similar" ...
        at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:215) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:165) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:141) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:279) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:364) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:115) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:436) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:600) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:309) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_65]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_65]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_65]
        at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_65]
        at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at com.sun.proxy.$Proxy18.executeRequest(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_65]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_65]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_65]
        at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_65]
        at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137) [teiid-runtime-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65]
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135) [teiid-runtime-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at com.sun.proxy.$Proxy18.executeRequest(Unknown Source)
        at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:635) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:510) [teiid-client-8.4.1-redhat-7.jar:8.4.1-redhat-7]
        ... 15 more

11:13:24,099 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue8) TEIID30020 Processing exception for request gz19si/K2dXh.3 'TEIID30504 CEREP: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23, c_24, c_25, c_26, c_27, c_28, c_29, c_30, c_31, c_32, c_33, c_34, c_35, c_36, c_37, c_38, c_39, c_40, c_41, c_42, c_43, c_44, c_45, c_46, c_47, c_48, c_49, c_50, c_51 FROM (SELECT g_0."RAT_ID_PK" AS c_0, g_0."RAT_REPORTING_PERIOD_FK" AS c_1, g_0."RAT_RATING_PERIOD_FK" AS c_2, g_0."RAT_CRA_IDENTIFIER_FK" AS c_3, g_0."RAT_REA_WITHDRAWAL_REASON_FK" AS c_4, g_0."RAT_RDS_CODE_FK" AS c_5, g_0."RAT_BIC_STD_ISSUER_ID_FK" AS c_6, g_0."RAT_CFI_FILE_NAME_FK" AS c_7, g_0."RAT_REPORTING_PERIOD" AS c_8, g_0."RAT_RATING_PERIOD" AS c_9, g_0."RAT_RATING_PERIOD_START" AS c_10, g_0."RAT_RATING_PERIOD_END" AS c_11, g_0."RAT_RATING_IDENTIFER" AS c_12, g_0."RAT_RATING_NAME" AS c_13, g_0."RAT_DEFAULT" AS c_14, g_0."RAT_WITHDRAWAL" AS c_15, g_0."RAT_NOT_VALUE_BOP" AS c_16, g_0."RAT_NOT_VALUE_EOP" AS c_17, g_0."RAT_NOT_BOP_FK" AS c_18, g_0."RAT_NOT_EOP_FK" AS c_19, g_0."RAT_CRY_VERS_ID_FK" AS c_20, g_0."RAT_THO_VERS_ID_FK" AS c_21, g_0."RAT_IND_VERS_ID_FK" AS c_22, g_0."RAT_SUL_VERS_ID_FK" AS c_23, g_0."RAT_GAR_VERS_ID_FK" AS c_24, g_0."RAT_RTT_VERS_ID_FK" AS c_25, g_0."RAT_LOI_VERS_ID_FK" AS c_26, g_0."RAT_SAT_VERS_ID_FK" AS c_27, g_0."RAT_AST_VERS_ID_FK" AS c_28, g_0."RAT_SEC_VERS_ID_FK" AS c_29, g_0."RAT_CAT_VALUE_BOP" AS c_30, g_0."RAT_CAT_VALUE_EOP" AS c_31, g_0."RAT_GEOG_AREA_ID_COUNTRY_CODE" AS c_32, g_0."RAT_ASSET_SUBASSET" AS c_33, g_0."RAT_VINTAGE_YEAR" AS c_34, g_0."RAT_INT_INSTR_ID" AS c_35, g_0."RAT_STD_INSTR_ID" AS c_36, g_0."RAT_INTER_ISSU_ID" AS c_37, g_0."RAT_NEW_RATING" AS c_38, g_0."RAT_REASON_HISTO_CHG" AS c_39, g_0."RAT_REASON_HISTO_CAN" AS c_40, g_0."RAT_RESP_CRA_UNIQ_ID" AS c_41, g_0."RAT_CREATION_DATE_TIME" AS c_42, g_0."RAT_CANCEL_DATE_TIME" AS c_43, g_0."RAT_IS_ALREADY_PUB" AS c_44, g_0."RAT_IS_PUBLISHED" AS c_45, g_0."RAT_HIST_AMENDMENT" AS c_46, g_0."RAT_COMPLETNESS" AS c_47, g_0."LAST_UPDATE_DATE_TIME" AS c_48, g_0."LAST_UPDATE_PREPUB" AS c_49, g_0."LAST_UPDATE_PUB" AS c_50, g_0."RAT_GEOG_AREA_EU_MEMBER" AS c_51 FROM "CEREP_DBA_USER"."CEREP_RATING" g_0) WHERE ROWNUM <= 50]'. Originally TeiidProcessingException 'TEIID31100 Parsing error: Encountered "g_0.\"RAT_GAR_VERS_ID_FK\" [*]AS[*] c_24," at line 1, column 1156.
Was expecting: "and" | "as" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "or" | "similar" ...' QueryParser.java:215. Enable more detailed logging to see the entire stacktrace.
11:14:27,490 WARN [org.teiid.SECURITY] (New I/O worker #3) TEIID40011 Processing exception 'TEIID40042 Invalid Session rEpu4dc2+N9g. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:355). Enable more detailed logging to see the entire stacktrace.
11:14:27,503 WARN [org.teiid.SECURITY] (New I/O worker #3) TEIID40011 Processing exception 'TEIID40042 Invalid Session ps7Nj5RMNtAl. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:355). Enable more detailed logging to see the entire stacktrace.
Actions
3. Re: Error executing statement with Oracle 11g

rareddy Oct 31, 2014 9:15 AM (in response to vince_fr)

Oracle does not support aliasing with "AS" keyword, that is what the error above indicating. That means, you MUST have set the translator name wrong on your Oracle source model.
Actions
4. Re: Error executing statement with Oracle 11g

vince_fr Oct 31, 2014 10:16 AM (in response to rareddy)

Ramesh thanks again,

It makes sense !
But, how can I correct the "translator name" on the source model. I don't see anything for that.
Ps : at connexion level, I'm using the oracle thin driver

Thanks

Vincent
Actions
5. Re: Error executing statement with Oracle 11g

rareddy Oct 31, 2014 11:25 AM (in response to vince_fr)

If you are using Designer, in the VDB explorer window
Actions
6. Re: Error executing statement with Oracle 11g

vince_fr Oct 31, 2014 12:06 PM (in response to rareddy)

Ok thanks !
I got it.
Mine is : oracle.
Better to try some generic jdbc ?
Actions
7. Re: Error executing statement with Oracle 11g

rareddy Oct 31, 2014 12:26 PM (in response to vince_fr)

Not sure I understand the question. Teiid provides a translator for specifically for oracle, why would you want to something generic jdbc? Is that effects of using wrong kind of translator we are dealing with right now?
Actions
8. Re: Error executing statement with Oracle 11g

vince_fr Nov 3, 2014 4:32 AM (in response to rareddy)

Ok sorry, I'll explain better :
I checked my translator name after reading your advice here, that was pretty relevant. I was about to find something different from oracle.
But surprise : my translator name was already oracle.
So I'm puzzled.
I strictly followed the documented process to get this oracle table virtualized.
Actions
9. Re: Error executing statement with Oracle 11g

shawkins Nov 3, 2014 8:43 AM (in response to vince_fr)

The translator has been set to oracle, but is pointed to a Teiid data source - not oracle. The parsing exception from above would only occur if the query were submitted against Teiid as a source.
Actions

Go to original post