It's all about the answers!

Ask a question

"Info not Available" on Request State on RRDI

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

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 (10012130) | answered Apr 20 '16, 2:08 p.m.
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

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

 Thanks for your answer Renato! I 

One other answer

permanent link
Cathy Xu (390515) | 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:
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:

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

Your answer

Register or to post your answer.