It is a bug, already identified, and fixed in V4.1.1.

sorry but i've already upgraded to 4.1.1, and i've the same problem

thank you

Hi,

Could you check for any Javascript error in the browser concole and post it here please ?
Thanks.

I execute debugger Firefox, and when i launch my request, I don't have an error.
However, in the debugger, the result of this request show us that several records exist with the same ID

(see attached file)

Maybe it's the origin of our trouble

Thank you

(see attached file)

No file attaches 🙁

But your explanation gives an hint.
You may have 2 records of workelement referencing the same ticket.

Look for workelements that have same refType and refId.
Query lilke this one should help :

select refType, refId, count(*) from workelement
group by refType, refId
having count(*) >1

Delete extra one...

In the attached file, you will find the result of your query

It's very strange you have so much double workelement :dry:
I never faced this on workelement (had it once on planningelement, fixed for long), and could not find a way to get this strange behavior. :huh:

Do you have any idea of how you could have got it ?

Anyway, you'll have do delete the extra line.

First display all :

select * from workelement where refType='Ticket' and refIdin(3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21, 23, 24, 25, 29, 31, 39, 43, 45, 47, 48, 50, 51, 52, 53, 57, 61, 62);

Please report result here. There may be some hint on how it happend.

Then delete some line so that there in no dupplicate for reftType / refId.

Hi

As asked, you will find as usual, a attached file with all informations.
Sorry but i don't know the origine of this problem. I use your solution and i don't have error message
However, perhaps this problem is function of the brower. I use Mozilla Firefox et IE 10.

I hope that you will find a explanation. I'm available if you need other things

Yannick

Very strange indeed.
Unfortunatly the data do not give any clue.

I compared to Track database : no duplicate found within 1229 tickets.
I really cannot understand how you got this issue.

How many tickets do you manage ?
I see id up to 142. Do you have much more or is the last one a recent one ?

I just noticed that tickets from id 3 to 62 almost have the issue.
But tickets over 63 do not.

Can you give any clue that could bring the difference ?
Import ?
New version installed ?

Did you ever delete tickets manually in the table (for some tests for instance) ?

Below some answers :

I use projeqtor since Octobre 2013 and i followed all évolutions/versions.
Today, i have 4.1.1 version.
I have never modify a recording directly in the database.

With respect to recording duplicated, can i remove them to keep just one ?

However, i will be vigilent and i will check regulary

Yannick

With respect to recording duplicated, can i remove them to keep just one ?

Yes. Try to keep the most relevant one.

However, i will be vigilent and i will check regulary

Yes, please. And report any new dupplicate.

Hi
I need information because in the workelement table, for duplicated recording, could you confirm that the "Id" field in the workelement table correspond with "id Ticket" ?
If it's right, i can't remove this duplicated record because there are not relation between them.

see attached file

No.
Id in workelement is the key of the line.
Id of ticket is referenced in the refId field of workelement, with refType='Ticket'.