"Info not Available" on Request State on RRDI
Accepted answer
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)
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)
One other answer
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...
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...