Not able to approve/reject a item in the Identity Portal UI
Article ID: 279355
Updated On:
Products
Issue/Introduction
When a user tries to approve or reject a item in the Identity Portal Tasks, an error is generated and not able to process the item.
Environment
Identity Portal 14.x
Cause
Some information was deleted from the Identity Manager Task Persistence database, the option is to update the WorkPoint database manually.
Resolution
To remove the items from the work list you need to change the item in the database.
1. Open the Identity Portal UI
2. Open the Task to list the items
3. Select the problematic item
4. Copy the URL and paste it to the notepad, below is an example
https://<hostname_IdP>/sigma/app/index#/tasks/approval/252___1%204%20303:WPDS___1abfc4d4-f612e12b-1154018f-68087a___Approval
5. Copy the value between "%20" and ":WPDS", in the above case the value is 303
6. Connect to the database and run the following query to check the record
select * from WP_WORK_ITEM where ACTI_ID=303;
7. Run the following queries to update the record ( work_state_id=5 means complete)
update WP_WORK_ITEM set work_state_id=5 where ACTI_ID=303;
commit;
8. Refresh the Identity Portal Task to check if the record was removed from the list
9. Do the same steps to all records you have the problem.
Note: We do recommend taking a backup of the WP_WORK_ITEM table before running the queries above.
Additional Information
If you have the same problem in the Identity Manager "View My Work List", see the KB article below
Feedback
