It's all about the answers!

Ask a question

"Info not Available" on Request State on RRDI


Cesar Sasaki (511166105) | asked Dec 10 '15, 3:06 p.m.
edited Dec 10 '15, 3:37 p.m.
 Hi

I'm making a report on RRDI and I'm using the Request Area.  Why is that on some records it shows "Info not available"?
I have run the "Full Job" but I can not fix the problem. When I go to the workitem IDit is all fine it works normal but not on the report. 

Accepted answer


permanent link
Renato Mori (10011829) | answered Apr 20 '16, 2:08 p.m.
JAZZ DEVELOPER
edited Apr 20 '16, 2:09 p.m.
Hi Cesar,
The error may be related to the groups where the state belongs. Appears the "Info not available" when the group is missing on each state.
In the workflow configuration, select a group for each state , and update the Job..
That happened to me and worked!.

(The  marked actions, are the same. Before / After group update)
 
Cesar Sasaki selected this answer as the correct answer

Comments
Cesar Sasaki commented Apr 20 '16, 3:44 p.m.

 Thanks for your answer Renato! I 

One other answer



permanent link
Cathy Xu (375411) | answered Dec 14 '15, 12:58 a.m.
Hi Cesar,

The "Info not available" usually indicates that Request's corresponding "Request_State_ID" is -1.
You can validate that by running this query:
select REFERENCE_ID, REQUEST_STATE_ID, PROJECT_ID
from RIODS.REQUEST
where REFERENCE_ID in (10000,10147,10198);

To investigate, I would go from the ODS tables...
What are the "problem" requests' "state" from work item UI?
What is the "REQUEST_STATE_ID" corresponding to such "state" in its project?
(This query will list all state id and state name along with project id:
 - select REQUEST_STATE_ID,REFERENCE_ID,PROJECT_ID from RIODS.REQUEST_STATE
)

You may need to dig further depending on where the data discrepancy sit...

Your answer


Register or to post your answer.