Forum

[SOLVED] Empty Proj...
 
Notifications
Clear all

[SOLVED] Empty Project Slots since upgrade to v8.2.4

13 Posts
2 Users
0 Reactions
6,947 Views
(@iconic)
Posts: 280
Active Member
Topic starter
 
[#6401]

Since the upgrade to version 8.2.4, we have experienced a weird thing where additional project slots have been created, but are empty with no details and we did not create them. I tried to use our administrator account to delete them, however it does not allow us to delete them.

What can we do to clear these blanks as it is very hard to navigate through them now when creating tickets and activities.


 
Posted : 06 Dec 2019 1H50
(@babynus)
Posts: 14952
Member Admin
 

It think you have an encoding issue in DB.
I guess you migrated by making a copy of the environment, but you did not care about encoding when exporting / importing dump.
If you want to be sure about the analysis, open one project that "disepeared" from the list, and remove all special or accentuated characters (keep only standard ansi letters without accents and numbers : a-z, A-Z, 0-9). If I'm right the project should reappear.


 
Posted : 06 Dec 2019 9H58
(@iconic)
Posts: 280
Active Member
Topic starter
 

Here is the thing, I opened up the project list and I checked all the projects and there is not characters or content whatsoever in the projects. I even check the database and these blank projects have not information in it except for the lastUpdateDateTime which shows the date and time the software was updated.

Here are a few photos to show you.


 
Posted : 09 Dec 2019 4H00
(@iconic)
Posts: 280
Active Member
Topic starter
 

Hi, I was wondering if there is any further help on this. What is the best way to repair or fix this problem.


 
Posted : 14 Dec 2019 2H15
(@babynus)
Posts: 14952
Member Admin
 

Very strange, I never faced such issue.
From which version did you migrate ?

NB : if these projects are not ones you created, you can delete them :
=> apply filter for "name" is empty
=> select multiple update
=> select all projects
=> click delete button.


 
Posted : 14 Dec 2019 21H27
(@iconic)
Posts: 280
Active Member
Topic starter
 

We migrated from 7.4.3

I tried to do the delete thing that you described and I had a problem at the the first step. I am in the Administrator Account, click on projects and applied the filter for "name" as empty. The results came back as 0 projects.

So I can not go to the next step.

Also, I discovered that I can I cannot delete each project individually either. The delete button is greyed out even when I click on one of these empty projects.

What can I do now?


 
Posted : 15 Dec 2019 0H29
(@babynus)
Posts: 14952
Member Admin
 

I tried to do the delete thing that you described and I had a problem at the the first step. I am in the Administrator Account, click on projects and applied the filter for "name" as empty. The results came back as 0 projects.

It seems name is not null but empty string (or just spaces)
You can possibly locate them on list of project and select them in multiple-update mode to delete them

I discovered that I can I cannot delete each project individually either. The delete button is greyed out even when I click on one of these empty projects

Strange, it seem you have no right to delete them...
Did you connect as admin ?


 
Posted : 15 Dec 2019 20H59
(@iconic)
Posts: 280
Active Member
Topic starter
 

I am connected as ADMIN Account but the the delete button is greyed out. Is there something I am doing wrong, or a feature I have to activate for Administrator to delete them one at a time.


 
Posted : 16 Dec 2019 3H49
(@iconic)
Posts: 280
Active Member
Topic starter
 

Using the Administrator Account I pressed on the multiple button (the button with the 2 save discs) displaying.
I selected these emply projects and when I clicked to delete them I receive this error.

#223 :
Invalid controls.
you don't have rights to delete this item
#197 :
Invalid controls.
you don't have rights to delete this item
#196 :
Invalid controls.
you don't have rights to delete this item
#195 :
Invalid controls.
you don't have rights to delete this item
#194 :
Invalid controls.
you don't have rights to delete this item
#193 :
Invalid controls.
you don't have rights to delete this item
#192 :
Invalid controls.
you don't have rights to delete this item
#191 :
Invalid controls.
you don't have rights to delete this item


 
Posted : 16 Dec 2019 3H51
(@babynus)
Posts: 14952
Member Admin
 

Can you chack access rights for Project ?.
On Acces Rights > Access to Data (project dependant), check that Admin profile hase mod e"Manager+" on Project.


 
Posted : 17 Dec 2019 19H12
(@iconic)
Posts: 280
Active Member
Topic starter
 

Hi,
Using my administrator access login details, I logged in and checked and under Access to data (project dependent) Administrator has Manager+ showing. In fact in almost everything it has Manager+ selected.


 
Posted : 18 Dec 2019 3H23
(@babynus)
Posts: 14952
Member Admin
 

It's very strange, I never faced such issue.
I made several migrations to V8.3, on several systems (Linux / Windows, MySql / Postgres) without reproducing such isse.
I'm afraid you'll have to delete manualy (I hate this, but it seems to be the only solution).
Here is the query to do this :

delete from planningelement where refType='Project' and refId in (select id from project where idProjectType is null and creationDate is null);
delete from project where idProjectType is null and creationDate is null;

Please be sure to backup your database before executing the query in case of too large deletion.


 
Posted : 21 Dec 2019 19H00
(@iconic)
Posts: 280
Active Member
Topic starter
 

That has worked wonders. I have tested most of ProjeQtor and the null project fields are all gone. it seems to have correctly sorted out the numbers and it seems that everything is working perfect.


 
Posted : 11 Feb 2020 12H53
Share:

Scroll to Top