Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Project Pr...
 
Notifications
Clear all

[SOLVED] Project Product link problem

17 Posts
2 Users
0 Reactions
6,601 Views
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 
[#7469]

Hi,

I am asking for your help with a problem for which I am unable to identify the cause.

When linking a product to a project, I notice these unexpected behaviors :

  • The project product version links, created automatically, are directly and systematically "closed".

           

  • If I try to uncheck "closed" on these links, the system does not save any changes and the link remains "closed".
  • The product is not offered in the "Product" list of the elements of this project (for example on the tickets), although this is the desired objective.

           

I see this for any project and product.
The affected products and product versions are not closed.
These issues are seen on ProjeQtOr V9.0.6, but I don't think the version or the app is to blame.
These actions do not produce an error in the logs.
In the past, it worked fine on this same basis.
I do not reproduce these behaviors on another test installation of ProjeQtOr, nor on demo.projeqtor.org.

What setting could be causing this problem ?
Could this be caused by an error in the database ? If yes, what to do ?
If not, what do you advise me to do to try to fix this ?

Thanks


Tony44

 
Posted : 05 Apr 2021 22H53
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

It is not the links that are closed, it is the versions.


 
Posted : 06 Apr 2021 14H42
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Thanks for the reply.

It is not the links that are closed, it is the versions.

Unfortunately no, the product versions are not closed :
 

When the product version is closed, the project version link is locked closed (the closed box is checked and grayed out) :
 

Here it is not the case, I can uncheck "closed" on the link project version, but when validating the system indicates that there is nothing to save and check the box again :
 

Do you have another idea ?


Tony44

 
Posted : 07 Apr 2021 0H55
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

I don't understand where is the issue.
You have close property on Version and on Project-Version relationship.
If Project-Version relationship is closed, you cannot use the version on the project.
if Version is closed, all its Project-Version relationship are also automatically closed.


 
Posted : 08 Apr 2021 23H00
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Yes, I understood the expected behavior

The issue is that we cannot uncheck the close property on project-version relationship.
This for some unknown reason (the version is not closed) 


Tony44

 
Posted : 08 Apr 2021 23H56
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Strange.
I tried again and there is not issue to check / uncheck link.
Checkbox is readonly only when version is closed.
Maybe you can delete the link and re-create it.
 


 
Posted : 09 Apr 2021 18H36
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Yes, strange.

babynus post=30127
I tried again and there is not issue to check / uncheck link.
Checkbox is readonly only when version is closed.

Of course, this is not a general anomaly of the application but specific to our database or configuration, see my 1st post :

I do not reproduce these behaviors on another test installation of ProjeQtOr, nor on demo.projeqtor.org.

 

babynus post=30127
Maybe you can delete the link and re-create it.

Remove link is useless: the box is automatically checked for all new links, including a new version and a new project.

Can this be caused by an error in the database ?

Thanks for your help


Tony44

 
Posted : 10 Apr 2021 1H07
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Just re-reading the full post, I noticed the Version used (1-0) is closed.
 

This may explain the behavior


 
Posted : 13 Apr 2021 15H51
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

No problem for closed versions, for which the project-version relationship is necessarily closed.

The issue is for unclosed versions.
It occurs for all versions of all products and on all projects.

Example:

  • I am creating a new project.
  • I am creating a new product.
  • I am creating a new version on this product.
  • I associate the product with the project.
  • The project-version relationship is immediately closed by the system.
  • It is not possible to reopen the project-version relationship.

Can this be caused by an error in the database ?


Tony44

 
Posted : 14 Apr 2021 0H46
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

I don't know what can cause this behavior as I do not reproduce.
I just tried use case on demo, and all works fine.
You can have a look on demo (connect as manager) on project 'PROJECT'.
Can you please try and reproduce your use case on demo ?


 
Posted : 14 Apr 2021 10H52
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Indeed, the issue cannot be reproduced on demo.projeqtor.org, as I indicated in my 1st post :

I do not reproduce these behaviors on another test installation of ProjeQtOr, nor on demo.projeqtor.org.

The problem is specific to our database, that's why I suspect an error in the database.
What can I provide to help identify the source of the problem?

Thank you again for your help


Tony44

 
Posted : 14 Apr 2021 12H08
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

Only solution would be to send us a dump (possibly anonymized) of your DB, for us to analyse.
But this is out of scope of free community support.


 
Posted : 14 Apr 2021 19H27
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Ok I understand, thanks


Tony44

 
Posted : 15 Apr 2021 2H38
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

Luky you !
I found the issue.
Will be fixed in V9.1.3


 
Posted : 19 Apr 2021 18H23
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Hi,

Very good news 
Did you finally reproduce the issue ?

Thanks for the information


Tony44

 
Posted : 21 Apr 2021 0H54
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Yes, I reproduced the issue...
... and fixed it.
Fix will be deployed in V9.1.3.


 
Posted : 21 Apr 2021 11H07
Tony
 Tony
(@tony44)
Posts: 131
Active Member
Topic starter
 

Hi,

We have installed version 9.1.3 and the issue is fixed.
Thanks again


Tony44

 
Posted : 10 May 2021 1H59
Share:

Scroll to Top