The hierarchy tab in project is not opening for some project
Hi, Can you please be more specific? Are you getting an error message when clicking on Hierarchy or is the Heirarchy tab is missing? Jerin
Have you checked the app logs for any error message(s) ?
Thanks for your reply.
we restart the services and able to open the hierarchy tab.
This also related to some query took more time to execute.
Once again Thanks for your quick response
Are you getting any Error 401 - Unauthorized..." error message?
If that is the case then may be you can try out the following steps:
1. Back up the cmn_actions table. You may copy this to a temp table or use any method that works for you.
2. Run the following sql. This will give you a list of ids that need to be repaired: select * from cmn_actions where action_code = 'service.billOfInvestments.project'
3. Run the following update statement:
update cmn_actions set policy_id = (select id from cmn_sec_policies where policy_code = 'viewHierarchyRollupTab') where id in (select * from cmn_actions where action_code = 'service.billOfInvestments.project' )
4. Restart the app service.
Let me know if that helps.
Retrieving data ...