View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Planning - Unkown activities appearing - ProjeQtOr
 
 

Planning - Unkown activities appearing

More
25 Jun 2014 21:42 - 25 Jun 2014 21:45 #1 by francis2301
Hi,
In the planning screen, Projeqtor is showing some activities which seems not to exist.

This error occured after deleting some activities. I had a set of activities structured similar to the one shown below.
I started to delete the activities (some were deleted one by one and some were deleted through the parent activity. No error appeared during the operations.
After that, I set up a bunch of milestone and went to the planning screen and realized the issue.

When you click in the activity, no information is shown in the bottom section. A print screen can be seen as attachment.
Regards,


Structure of Activities deleted.
Parent Activity 1
Child Activity 1
Child Activity 2
Child Activity 3
Child Activity 4

Parent Activity 2
Child Activity 1
Child Activity 2
Child Activity 3
Child Activity 4

Parent Activity 3
Child Activity 1
Child Activity 2
Child Activity 3
Child Activity 4
Attachments:
Last edit: 25 Jun 2014 21:45 by francis2301.

Please Log in or Create an account to join the conversation.

More
25 Jun 2014 23:47 #2 by babynus
You must have in your database some line of planningelement with refType / RefId referencing a deleted activity.
Could you check this, and confirm thos analysis.
Could you also identified how these activities where deleted ? Possibly these are activities deleted through parent deletion.

I recorded Ticket #1419 to investigate.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
26 Jun 2014 14:58 #3 by francis2301
I'll check the database. I'll have to ask our IT personnel to give these info.
About the deletion procedures:

At first, I started deleting each activity separetely. Id did that for all child activities below Parent Activity 03 (according to the structured shown in the previous post).
Then I started deleting the activities through parent deletion.

PS: Althought in the structured shown in the previous post I had only 03 Parent Activities, in real life I had 04 parent activities, and deleted 03 parent activities, which matches with the number of tasks appearing in the planning screen.

Not sure if it is related or not, but when you delete a child activity which has an Assignment, first you have to delete the assignment then de activity (it doesn't have cascade deletion). But, when you delete a Parent activity, even if the child activities have Assignments, the deletion occurs in cascade mode and there's not system message requesting to first delete the Assignments (similar to child activity deletion).

Thanks.

Please Log in or Create an account to join the conversation.

More
27 Jun 2014 14:27 #4 by francis2301
Hi,
I get the result from planningelement table and found 04 records which doesn't exist anymore in the activity table.

I'll have to do is to delete those 04 records in planningelement table, correct? Is there any other table which needs maintenance?

Kind Regards,
Attachments:

Please Log in or Create an account to join the conversation.

More
27 Jun 2014 15:35 #5 by babynus

I'll have to do is to delete those 04 records in planningelement table, correct?

Yes

Is there any other table which needs maintenance?

No, no other.

A patch will soon be proposed.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
01 Jul 2014 15:25 #6 by francis2301
Thank you very much indeed. Kind regards.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.037 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.