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.