Nikolaj Posted September 12, 2019 Share Posted September 12, 2019 Hello Support, Can you please help me? I would like to cancel a project but i get an error project tasks or milestones still exist but there is no milestone or task anymore. What can i do? Can you please delete this project? Project Name: 360-ATSG7 Thanks Nikolaj Link to comment Share on other sites More sharing options...
Nikolaj Posted September 17, 2019 Author Share Posted September 17, 2019 @AlexTumber I need your help, can please someone delete this project or make sure that when all tasks and milestones deleted that its possible to cancel a project? Thanks Nikolaj Link to comment Share on other sites More sharing options...
AlexTumber Posted September 17, 2019 Share Posted September 17, 2019 @Nikolaj I suspect that there are still tasks associated to the project even though they are not showing in the UI. We saw this problem several months ago with selected projects. If you query the database for all project tasks that are associated to that project, how many are shown compared to what you see in the UI? Alex Link to comment Share on other sites More sharing options...
Nikolaj Posted September 17, 2019 Author Share Posted September 17, 2019 @AlexTumber In the UI it shown 0 and also for query on the database. Best Regards Nikolaj Link to comment Share on other sites More sharing options...
AlexTumber Posted September 17, 2019 Share Posted September 17, 2019 @Nikolaj in the UI, attempt to cancel the project (so that it reproduces the error saying there are outstanding milestones and project tasks), then look in in the admin tool under the server service log and filter by sql. The system has to find a related record for that error to be shown. Hopefully this will show us what the issue is. Alex Link to comment Share on other sites More sharing options...
Nikolaj Posted September 17, 2019 Author Share Posted September 17, 2019 @AlexTumber Can you see something? 327741 13:19 17-09-2019 info sql 2712 select COUNT(*) AS activeMilestoneCount, (SELECT COUNT(*) FROM h_sys_tasks WHERE h_sys_tasks.h_obj_ref_urn = CONCAT("urn:sys:entity:com.hornbill.projectmanager:Projects:",60) AND h_sys_tasks.h_state = 1 AND h_sys_tasks.h_progress != 100) AS activeProjectTaskCount from h_project_project_milestones where h_project_id = 60 AND h_status = "status.inProgress" [2266 us] Link to comment Share on other sites More sharing options...
AlexTumber Posted September 17, 2019 Share Posted September 17, 2019 @Nikolaj if you run these 2 separate statements: SELECT COUNT(*) AS activeProjectTaskCount FROM h_sys_tasks WHERE h_obj_ref_urn = "urn:sys:entity:com.hornbill.projectmanager:Projects:60" AND h_state = 1 AND h_progress != 100 SELECT COUNT(*) AS activeMilestoneCount FROM h_project_project_milestones WHERE h_project_id = 60 AND h_status = "status.inProgress" Do either of them return any results? Link to comment Share on other sites More sharing options...
Nikolaj Posted September 17, 2019 Author Share Posted September 17, 2019 @AlexTumber Link to comment Share on other sites More sharing options...
AlexTumber Posted September 17, 2019 Share Posted September 17, 2019 @Nikolaj ok so the underlying system task still exists. This will need to be completed or deleted. In the UI, from the Home icon, select My Activities and locate the task in question. What happens when you try and complete it? Alex Link to comment Share on other sites More sharing options...
Nikolaj Posted September 17, 2019 Author Share Posted September 17, 2019 @AlexTumber thanks for that tip. I had one task in my activities called project planning for that project. But it wasn't shown in the project himself. Nevertheless i could not open it or set it to complete. The only thing i could do was delete it. And now it is possible to change the status to cancel. Best regards Nikolaj 1 Link to comment Share on other sites More sharing options...
AlexTumber Posted September 17, 2019 Share Posted September 17, 2019 @Nikolaj glad to hear that's resolved the issue. I'll ask our development team to see if they can replicate the issue as I suspect it was caused by a problem that occurred when the project task was initially deleted, causing the underlying system task to be left orphaned in the system. Alex Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now