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 (49712137138) | 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 (49712137138) | 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.