[JBoss JIRA] (TEIID-1794) Teiid Plugin shows zero for all metrics except Session Count
by Ted Jones (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1794?page=com.atlassian.jira.plugin... ]
Ted Jones commented on TEIID-1794:
----------------------------------
Looks like this is an unaccounted for datatype change:
2011-10-24 13:49:45,702 ERROR [org.rhq] (ResourceContainer.invoker.daemon-33) Failed to obtain measurement [null]. Cause: java.lang.ClassCastException: Cannot cast java.lang.String to org.teiid.adminapi.Request$ProcessingState
2011-10-24 13:49:45,702 ERROR [org.rhq.core.pc.measurement.MeasurementManager] (http-10.15.208.149-8080-1) Could not get measurement values
java.lang.ClassCastException: Cannot cast java.lang.String to org.teiid.adminapi.Request$ProcessingState
at java.lang.Class.cast(Class.java:3007)
at org.teiid.rhq.plugin.util.ProfileServiceUtil.getSimpleValue(ProfileServiceUtil.java:347)
at org.teiid.rhq.admin.DQPManagementView.unwrapRequestMetaValue(DQPManagementView.java:879)
at org.teiid.rhq.admin.DQPManagementView.getRequestCollectionValue(DQPManagementView.java:707)
at org.teiid.rhq.admin.DQPManagementView.getPlatformMetric(DQPManagementView.java:126)
at org.teiid.rhq.admin.DQPManagementView.getMetric(DQPManagementView.java:108)
at org.teiid.rhq.plugin.PlatformComponent.getValues(PlatformComponent.java:126)
at sun.reflect.GeneratedMethodAccessor1238.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:525)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
2011-10-24 13:49:45,709 ERROR [org.rhq] (ResourceContainer.invoker.daemon-33) Failed to obtain measurement [null]. Cause: java.lang.ClassCastException: Cannot cast java.lang.String to org.teiid.adminapi.Request$ProcessingState
2011-10-24 13:49:45,709 ERROR [org.rhq.core.pc.measurement.MeasurementManager] (http-10.15.208.149-8080-1) Could not get measurement values
java.lang.ClassCastException: Cannot cast java.lang.String to org.teiid.adminapi.Request$ProcessingState
at java.lang.Class.cast(Class.java:3007)
at org.teiid.rhq.plugin.util.ProfileServiceUtil.getSimpleValue(ProfileServiceUtil.java:347)
at org.teiid.rhq.admin.DQPManagementView.unwrapRequestMetaValue(DQPManagementView.java:879)
at org.teiid.rhq.admin.DQPManagementView.getRequestCollectionValue(DQPManagementView.java:707)
at org.teiid.rhq.admin.DQPManagementView.getPlatformMetric(DQPManagementView.java:126)
at org.teiid.rhq.admin.DQPManagementView.getMetric(DQPManagementView.java:108)
at org.teiid.rhq.plugin.PlatformComponent.getValues(PlatformComponent.java:126)
at sun.reflect.GeneratedMethodAccessor1238.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:525)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
> Teiid Plugin shows zero for all metrics except Session Count
> ------------------------------------------------------------
>
> Key: TEIID-1794
> URL: https://issues.jboss.org/browse/TEIID-1794
> Project: Teiid
> Issue Type: Bug
> Components: Jopr Plugin
> Affects Versions: 7.4.1
> Reporter: Debbie Steigner
> Assignee: Ted Jones
> Priority: Critical
>
> Using either JON or the Admin Console no metrics appear to be collected for Data Services except Session count. All measurements are enable and set to collect every 10 minutes, but nothing happens.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months
[JBoss JIRA] (TEIID-1791) Only the first 1000 items in the IN criteria are being pushed down in the query
by Van Halbert (Updated) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1791?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-1791:
-------------------------------
Attachment: (was: 1000_cmd_log.txt)
> Only the first 1000 items in the IN criteria are being pushed down in the query
> -------------------------------------------------------------------------------
>
> Key: TEIID-1791
> URL: https://issues.jboss.org/browse/TEIID-1791
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.4.1
> Reporter: Debbie Steigner
>
> In the below query, we are expecting a large number of book codes (46987), to be passed from ledgerbookid in t_sdm_ledgerbook into the TSL_FINANCIAL_ACCOUNT_ITEMS_T2 table. We can see from the query plan that it got the correct number of rows.
> I understand that Oracle can only take 1000 items in an IN() construct, so EDS will split the criteria into multiple sets of 1000 IN criteria. I have seen this work previously.
> It seems that for some reason in this query, possibly the other dependent join or hints, EDS pushes exactly 1000 criteria. Looking at the source specific SQL command in the EDS debug log, which I have attached, I counted the number of question marks in that IN() and it comes to 1000. We have checked that all of these book codes are unique, by doing a select distinct to the source model.
> select cc.costcentreid, cc.description , ac.accountdescription, sum(func_amount)
> from TSL_FINANCIAL_ACCOUNT_ITEMS_T2 tsl
> join t_sdm_glaccount ac on tsl.account_code = ac.accountid
> join /*+ MAKEIND */t_sdm_ledgerbook lb on tsl.book_code = lb.ledgerbookid
> join /*+ MAKEIND */t_sdm_costcentre cc on lb.parentcostcentreid = cc.costcentreid
> join /*+ MAKEIND */t_sdm_desk dsk on cc.parentdeskid = dsk.deskid
> join /*+ MAKEIND */t_sdm_businessarea ba on dsk.parentbusinessareaid = ba.businessareaid
> join /*+ MAKEIND */t_sdm_division div on ba.parentdivisionid = div.divisionid
> where tsl.business_date = '2011-06-29'
> and div.divisionid = 'GBM'
> and ac.classificationid in (3,4)
> group by cc.costcentreid, cc.description, ac.accountdescription;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months
[JBoss JIRA] (TEIID-1791) Only the first 1000 items in the IN criteria are being pushed down in the query
by Van Halbert (Updated) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1791?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-1791:
-------------------------------
Attachment: (was: 1000_problem.txt)
> Only the first 1000 items in the IN criteria are being pushed down in the query
> -------------------------------------------------------------------------------
>
> Key: TEIID-1791
> URL: https://issues.jboss.org/browse/TEIID-1791
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.4.1
> Reporter: Debbie Steigner
>
> In the below query, we are expecting a large number of book codes (46987), to be passed from ledgerbookid in t_sdm_ledgerbook into the TSL_FINANCIAL_ACCOUNT_ITEMS_T2 table. We can see from the query plan that it got the correct number of rows.
> I understand that Oracle can only take 1000 items in an IN() construct, so EDS will split the criteria into multiple sets of 1000 IN criteria. I have seen this work previously.
> It seems that for some reason in this query, possibly the other dependent join or hints, EDS pushes exactly 1000 criteria. Looking at the source specific SQL command in the EDS debug log, which I have attached, I counted the number of question marks in that IN() and it comes to 1000. We have checked that all of these book codes are unique, by doing a select distinct to the source model.
> select cc.costcentreid, cc.description , ac.accountdescription, sum(func_amount)
> from TSL_FINANCIAL_ACCOUNT_ITEMS_T2 tsl
> join t_sdm_glaccount ac on tsl.account_code = ac.accountid
> join /*+ MAKEIND */t_sdm_ledgerbook lb on tsl.book_code = lb.ledgerbookid
> join /*+ MAKEIND */t_sdm_costcentre cc on lb.parentcostcentreid = cc.costcentreid
> join /*+ MAKEIND */t_sdm_desk dsk on cc.parentdeskid = dsk.deskid
> join /*+ MAKEIND */t_sdm_businessarea ba on dsk.parentbusinessareaid = ba.businessareaid
> join /*+ MAKEIND */t_sdm_division div on ba.parentdivisionid = div.divisionid
> where tsl.business_date = '2011-06-29'
> and div.divisionid = 'GBM'
> and ac.classificationid in (3,4)
> group by cc.costcentreid, cc.description, ac.accountdescription;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months
[JBoss JIRA] (TEIID-1791) Only the first 1000 items in the IN criteria are being pushed down in the query
by Van Halbert (Updated) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1791?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-1791:
-------------------------------
Attachment: (was: TSL_POC.vdb)
> Only the first 1000 items in the IN criteria are being pushed down in the query
> -------------------------------------------------------------------------------
>
> Key: TEIID-1791
> URL: https://issues.jboss.org/browse/TEIID-1791
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.4.1
> Reporter: Debbie Steigner
>
> In the below query, we are expecting a large number of book codes (46987), to be passed from ledgerbookid in t_sdm_ledgerbook into the TSL_FINANCIAL_ACCOUNT_ITEMS_T2 table. We can see from the query plan that it got the correct number of rows.
> I understand that Oracle can only take 1000 items in an IN() construct, so EDS will split the criteria into multiple sets of 1000 IN criteria. I have seen this work previously.
> It seems that for some reason in this query, possibly the other dependent join or hints, EDS pushes exactly 1000 criteria. Looking at the source specific SQL command in the EDS debug log, which I have attached, I counted the number of question marks in that IN() and it comes to 1000. We have checked that all of these book codes are unique, by doing a select distinct to the source model.
> select cc.costcentreid, cc.description , ac.accountdescription, sum(func_amount)
> from TSL_FINANCIAL_ACCOUNT_ITEMS_T2 tsl
> join t_sdm_glaccount ac on tsl.account_code = ac.accountid
> join /*+ MAKEIND */t_sdm_ledgerbook lb on tsl.book_code = lb.ledgerbookid
> join /*+ MAKEIND */t_sdm_costcentre cc on lb.parentcostcentreid = cc.costcentreid
> join /*+ MAKEIND */t_sdm_desk dsk on cc.parentdeskid = dsk.deskid
> join /*+ MAKEIND */t_sdm_businessarea ba on dsk.parentbusinessareaid = ba.businessareaid
> join /*+ MAKEIND */t_sdm_division div on ba.parentdivisionid = div.divisionid
> where tsl.business_date = '2011-06-29'
> and div.divisionid = 'GBM'
> and ac.classificationid in (3,4)
> group by cc.costcentreid, cc.description, ac.accountdescription;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months