RQM Reports with BIRT: Table Updating Issue
![]()
Hello Everyone,
I am using the BIRT plugin for RTC to create custom reports for RQM. One report that I am trying to create is the link between Execution Results and Defects. My RQM project is connected to a ClearQuest project which hosts the defects. All the information I need right now is stored in the com.ibm.rqm.execution.ExecutionResult table under the LIVE_SNAPSHOT. Data is retrieved from: stepResults.properties.key (ClearQuest Defect ID and Summary) stepResults.properties.value (link to CQ defect) where stepResults.properties.propertyType = "rtcdefectView" The data shows up fine, except now when I add new defects to Execution Result records, the table doesn't seem to update, and it's already been 24 hours. I have tried to manually update LIVE_SNAPSHOT. I am certain that the references to the new CQ defects have been created because the com.ibm.team.interop.ExternalState table shows the defect ID and summary under stringExtensions.value where stringExtensions.key = com.ibm.team.interop.xstate.WORKITEM_NAME. On a side note I have create a SQL query that queries the database (via JDBC connection) that retrieves the same results as the Jazz Data Connection report, but with the new data available: SELECT Why is the com.ibm.rqm.execution.ExecutionResult table not updating properly? Also, what is the BIRT reference to the "EXECUTION.EXECUTION_TASK_RESULT" table listed in the SQL query? Is it com.ibm.rqm.execution.ExecutionResult, or another one? Please help! Thank you in advance. Best regards, Andrew |
One answer
![]()
Note: This post is 4+ years old.
Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help). If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639). |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.