1:11 a.m.
[
https://issues.jboss.org/browse/TEIID-4325?page=com.atlassian.jira.plugin...
]
Chenna Krishna commented on TEIID-4325:
---------------------------------------
Mark,
How the problem fixed for this. Which join condition has to be changed we are also facing
the same error in TEIID (jasper). Suggestion would be very helpful. We are using
Teiid JDBC Driver version 8.12 (8/12)
Query:
select "DOX_JB_EAM_FOLDER_SP"."EAM_CODE" as
"DOX_JB_EAM_FOLDER_SP_EAM_CODE","DOX_JB_EAM_FOLDER_SP"."OBJECT_NAME"
as
"DOX_JB_EAM_FOLDER_SP_OBJECT_NAME","DT_DOX_JB_EAM_DOC_SP_CA"."R_CREATION_DATE"
as
"DT_DOX_JB_EAM_DOC_SP_CA_R_CREATION_DATE","DT_DOX_JB_EAM_DOC_SP_EAM"."R_CREATION_DATE"
as
"DT_DOX_JB_EAM_DOC_SP_EAM_R_CREATION_DATE","DT_ODS_AGENT_PROFILES"."AGENT_CODE"
as
"DT_ODS_AGENT_PROFILES_AGENT_CODE","DT_ODS_AGENT_PROFILES"."AGENT_NAME"
as
"DT_ODS_AGENT_PROFILES_AGENT_NAME","DT_ODS_AGENT_PROFILES"."MODIFICATION_DATE"
as
"DT_ODS_AGENT_PROFILES_MODIFICATION_DATE","DT_ODS_AGENT_PROFILES"."OPEN_DATE"
as
"DT_ODS_AGENT_PROFILES_OPEN_DATE","DT_ODS_AGENT_PROFILES"."STATUS"
as "DT_ODS_AGENT_PROFILES_STATUS"from
"DOX_JASPER_DXTR_USER"."JB_EAM_FOLDER_SP_SG"
"DOX_JB_EAM_FOLDER_SP"left outer join (SELECT AGENT_CODE, AGENT_NAME,
MODIFICATION_DATE, OPEN_DATE, CASE WHEN STATUS = 'A' THEN 'Inactive' WHEN
STATUS = '' THEN 'Active' ELSE STATUS END AS STATUS FROM
ODS.AGENT_PROFILES WHERE FLG_ACTIVE = 'Y') "DT_ODS_AGENT_PROFILES" on
("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" =
"DT_ODS_AGENT_PROFILES"."AGENT_CODE")left outer join (SELECT
D.DOC_CODE, D.EAM_CODE, D.OBJECT_NAME, D.R_CREATION_DATE FROM
DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG D INNER JOIN (SELECT EAM_CODE, DOC_CODE,
MAX(R_CREATION_DATE) R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG WHERE
DOC_CODE = 'E115' GROUP BY EAM_CODE, DOC_CODE) T ON D.EAM_CODE = T.EAM_CODE AND
D.DOC_CODE = T.DOC_CODE AND D.R_CREATION_DATE = T.R_CREATION_DATE)
"DT_DOX_JB_EAM_DOC_SP_CA" on
("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" =
"DT_DOX_JB_EAM_DOC_SP_CA"."EAM_CODE")left outer join (SELECT
D.DOC_CODE, D.EAM_CODE, D.OBJECT_NAME, D.R_CREATION_DATE FROM
DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG D INNER JOIN (SELECT EAM_CODE, DOC_CODE,
MAX(R_CREATION_DATE) R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG WHERE
DOC_CODE = 'E109' GROUP BY EAM_CODE, DOC_CODE) T ON D.EAM_CODE = T.EAM_CODE AND
D.DOC_CODE = T.DOC_CODE AND D.R_CREATION_DATE = T.R_CREATION_DATE)
"DT_DOX_JB_EAM_DOC_SP_EAM" on
("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" =
"DT_DOX_JB_EAM_DOC_SP_EAM"."EAM_CODE")order by
"DT_ODS_AGENT_PROFILES_AGENT_CODE" limit 200001
Regads,
Chenna
ASSERTION FAILED: expected reference to be not null
---------------------------------------------------
Key: TEIID-4325
URL: https://issues.jboss.org/browse/TEIID-4325
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12
Reporter: Mark Tawk
Assignee: Steven Hawkins
Fix For: 9.1, 9.0.2, 8.12.6.6_3
Attachments: show_plan_debug.txt
I'm using teiid 9.0.0 over h2 :
I'm getting ASSERTION_FAILED over the following query and can not find what is
causing this exception:
select "Sheet1"."AvgAmoutRange" as
"Sheet1_EBt_211215_AvgAmoutRa1",COUNT( distinct
IFNULL("CEGlobalView"."Customer_CustomerID",-2147483648)) as
"CEGlobalView_Customer_Custom2","CEGlobalView"."Customer_GenderID"
as "CEGlobalView_Customer_Gender1","Gender"."Gender" as
"Gender_Gender","Sheet1"."Sheet1_EBt_211215ID" as
"Sheet1_EBt_211215_Sheet1_EBt11" from
"CEBanksBusinessModel"."CEGlobalView" "CEGlobalView" LEFT
JOIN
"h2dbimplify_data_cebankModel_ST"."implify_data_cebank"."Sheet1_EBt_211215"
"Sheet1" ON (
("CEGlobalView"."StreamCardsvt3r_StreamCards_1" BETWEEN
"Sheet1"."Min" and "Sheet1"."Max") )
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."Gender"
"Gender" ON "CEGlobalView"."Customer_GenderID" =
"Gender"."GenderID"
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."CustomerTag"
"CustomerTag" ON "CEGlobalView"."Customer_CustomerID" =
"CustomerTag"."Customer_CustomerID" AND ( (
("CustomerTag"."EndDateTime" > CURDATE()) OR (
("CustomerTag"."EndDateTime" IS null ) ) ) )
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagValue"
"TagValue" ON "CustomerTag"."TagValue_TagValueID" =
"TagValue"."TagValueID"
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagName"
"TagName" ON "TagValue"."TagName_TagNameID" =
"TagName"."TagNameID" AND ( (
("TagName"."TagType_TagTypeID" IN (1.0) ) ) AND (
("TagName"."TagScope_TagScopeID" IN (1.0) ) ) )
where ( ( ( ("TagName"."TagName" IN ('Behavior') ) ) ) AND
( ("Sheet1"."AvgAmoutRange" IS NOT null ) ) AND (
("CEGlobalView"."Customer_GenderID" IS NOT null ) ) AND (
("Gender"."Gender" IS NOT null ) ) ) group by
"Sheet1"."AvgAmoutRange","CEGlobalView"."Customer_GenderID","Gender"."Gender","Sheet1"."Sheet1_EBt_211215ID"
order by "Sheet1"."Sheet1_EBt_211215ID"
ASC,"Sheet1"."AvgAmoutRange" ASC,"Gender"."Gender"
DESC,"CEGlobalView"."Customer_GenderID" DESC
The exception stack:
ERROR TEIID_DQP_LOGGER:90 (http-bio-8080-exec-14) - - [TEIID30019 Unexpected exception
for request rBDBCRYcUyyM.0]
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at
org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367)
at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:133)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
at
org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91)
at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313)
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245)
at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:177)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260)
at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:175)
at com.sun.proxy.$Proxy34.executeRequest(Unknown Source)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:673)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
you find attached the show plan debug
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
3519
days inactive
3519
days old
0 comments
1 participants
participants (1)
-
Chenna Krishna (JIRA)