Hi,

Very strange behavior, I never faced.
Can you try and reproduce on Demo, to try and get a testable use case ?

Hi,
Try to reproduce the case on demo version = impossible

I try without hope. I think there is a record in a table wich is read when I save the activity to create it.
And this record implies a project creation.

I think about that because of the time taked by the creation process (about 50 seconds).

Could you tell me what are the table used in the project creation process ?

Thanks for your help.

Regards.

A daily ProjeQt'Or user.

Hi again,

I change the sub-project association of a project and it also create a new empty project.

See below the record created in the project table :
"1041",,NULL,NULL,NULL,NULL,NULL,NULL,"0","10","0",NULL,NULL,NULL,"00017",NULL,"OPE",NULL,NULL,NULL,NULL,NULL,NULL,"0",NULL,NULL,"0",NULL,NULL,NULL,NULL,NULL,NULL,"0","2019-03-20 09:27:19",NULL,"0","0",NULL,"0",NULL,"0","0"

Hope it helps

Thanks for your help.

Regards.

A daily ProjeQt'Or user

Hi again,

I test some cases :

1 - Changing sub-project from root to an internal "structure" project
=> It takes 80 seconds and create a new empty project

2 - Changing sub-project from an internal "structure" project to root
=> It takes 5 seconds and don't create any new empty project

3 - Changing sub-project from an internal "structure" project to another internal "structure" project
=> It takes 10 seconds and don't create any new empty project

The problem seems to be in the fact of descending the project in the "structure"

I try to create an Activity when the project is on sub-project root and It takes 67 seconds instead of 80 but create a new empty project.

Hope It helps.

Thanks for your help.

Regards.

A daily ProjeQt'Or user.

Hi again,

To be the most complete in my tests, I do creation of all the element according to a project and look at the result :

Activity : 60 seconds and a new empty project
Milestone :60 seconds and a new empty project
Meeting : 60 seconds and a new empty project
test session : 60 seconds and a new empty project
all the rest takes 5 seconds and don't create a new empty project.

Hope it helps.

Thanks for your help.

Regards.

A daily ProjeQt'Or user.

Hi,
maybe it is or seems irrelevant but did you change the user profile before having this problem? if yes try to set the initial user profile and check if the problem persists.
I had once a problem in activity and project creation and it was related to that. it was not the same problem I am just trying to help.

Thank you for your help.

If you talk about the user that make the changes (me), I didn't change anything on my profile.
Before I was administrator and I'm always be.

And my Project manager have the same issue.

I think we can delete this source of issue.

Thanks again.

A daily ProjeQt'Or user.

Check your dependency table.
those you cited (Activity, ...) have dependencies (tickets for instance do not):

Good luck

Thanks Envergus for your help.

So I check my dependency table (677 records) :
I delete dependency from and to project
=> error is always there

I check that all the predecessorRefId and successorRefId are existing
=> all Id have record in the relevant table

I check If a successor is also a predecessor
=> all is clear

I don't know what to check further. Have an Idea ?

Thanks

A daily ProjeQt'Or user

Check also planningelement table if for example there is a planning for non existing activity or project...
did you do any direct change on the database before having this problem?

Ok Envergus,

I Check planningelement table and delete non existing activity and project.
So I try to create an activity and it takes always 60 seconds but don't create another Project.

Curious thing, The modification date is updated on all the project but when I look in the history of the project, I can't find a row with a modification at the same date/hour.

And Yes you discover me, I already have made direct change on the database. But after each, It work fine.

I don't think It's the origin because I've made the last direct modification long time ago.

Thanks for your help.

A daily ProjeQt'Or user

I already have made direct change on the database.

👿
This is always a bad idea.

But after each, It work fine.

🙁
Side effects may appear later, possibly with new feature.
The framework expects some structure, that is not forced by DB model.
If you don't respect this, you may get unexpected behavior.

Try and apply consistency checks, on administration screen.
This may fix somet things.
But, as we don't know what you did on DB, possibly consistency fix will remove some data you consider valid.
So be sure to backup DB before consitency fix.

A fix has been found for "long duration" when ceating an activity.
It will be deployed on V7.4.4
Patch is attached.

Hi,

I apply consistency check in administrator scrren and It make no changes. Activity creation takes 60 seconds.
But always update time on all the project changes instead of creating one.
Regarding the update date on project, I notice that the older is on the project at the most lower level.
Like the update apply on the project at the lower level and after the higher level and so on.

After applying fix It seems to takes more time (nearly 80 seconds).

Have you some other things that I can check ?

Thanks for your help.

A daily ProjeQt'Or user.

Check last reply : patch proposed.

Babynus,

I applied the patch and no changes was made. Always 60 seconds on Activity creation.

I continue to check idProject and refId + refType on all the tables.

Is it important to delete record of non-existing element in the tables history, kpihistory and kpivalue ?

Thanks for your help.

A daily ProjeQt'Or user.

Patch was not complete.
Good one is attached.

Babynus,

I apply the last patch and now It goes too speed...;-) private joke

GREAT !!!!

Very big thanks for your help you and Envergus. I never felt abandoned in this forum.

thanks to you my team will be able to work efficiently again.

A daily ProjeQt'Or proselytist 😉