It's all about the answers!

Ask a question

Why does the STATE table under the WORKITEMS snapshot in BIRT not display all states?


Andrew Trobec (49712144139) | asked Oct 08 '12, 2:11 a.m.
Hello,

I am using RTC 3.0.1.1.

I have a data set based on the WORKITEMS snapshot and the STATE table to retrieve all states.  For a custom work item I can see all but one state!  The states are numbered s1 to s12, but s11 is not being displayed.  I have no idea why.

I have run all the data collection jobs for the data warehouse but that doesn't work.  I have set the application to use the data mart and re-run the data collection jobs but that doesn't work either.

How can I update the STATE table?

Thank you and best regards,

Andrew

One answer



permanent link
Andrew Trobec (49712144139) | answered Oct 08 '12, 3:02 a.m.
After doing some extensive analysis, it turns out that the Closed state for my work item was not associated with a state group.  After associating it with the Closed state group and ran the data mart collection jobs everything sorted itself out.

Your answer


Register or to post 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.