Good day!
When upgrading Projeqtor from version 9.0.2 to 9.0.2, an error occurred in the logs:
------
2021-02-03 14:21:59.343 ===== TRACE ===== =====================================
2021-02-03 14:21:59.343 ===== TRACE =====
2021-02-03 14:21:59.344 ===== TRACE ===== DataBase actual Version = V9.0.2
2021-02-03 14:21:59.344 ===== TRACE ===== ProjeQtOr actual Version = V9.0.3
2021-02-03 14:21:59.344 ===== TRACE =====
2021-02-03 14:21:59.344 ===== TRACE ===== =====================================
2021-02-03 14:21:59.344 ===== TRACE =====
2021-02-03 14:21:59.344 ===== TRACE ===== VERSION V9.0.3
2021-02-03 14:21:59.344 ===== TRACE =====
2021-02-03 14:21:59.348 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-02-03 14:21:59.370 ===== TRACE ===== 71 lines inserted into table "tempupdate".
2021-02-03 14:21:59.391 ===== TRACE ===== 71 lines deleted from table "audit".
2021-02-03 14:21:59.399 ===== TRACE ===== 71 lines deleted from table "tempupdate".
2021-02-03 14:21:59.416 ===== TRACE ===== 13 lines inserted into table "tempupdate".
2021-02-03 14:21:59.428 ===== TRACE ===== 13 lines deleted from table "audit".
2021-02-03 14:21:59.433 ===== TRACE ===== 13 lines deleted from table "tempupdate".
2021-02-03 14:21:59.446 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-02-03 14:21:59.448 ===== TRACE ===== 0 lines deleted from table "audit".
2021-02-03 14:21:59.452 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-02-03 14:21:59.486 ===== TRACE ===== Index "audit" dropped.
2021-02-03 14:21:59.615 ===== TRACE ===== Index "auditSessionId" created.
2021-02-03 14:21:59.617 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-02-03 14:21:59.729 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-02-03 14:21:59.731 ===== TRACE ===== 0 lines deleted from table "kpihistory".
2021-02-03 14:21:59.738 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-02-03 14:21:59.772 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-02-03 14:21:59.773 ===== TRACE ===== 0 lines deleted from table "kpihistory".
2021-02-03 14:21:59.778 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-02-03 14:21:59.813 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-02-03 14:21:59.815 ===== TRACE ===== 0 lines deleted from table "kpihistory".
2021-02-03 14:21:59.821 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-02-03 14:21:59.842 ===== TRACE ===== Index "kpihistoryKpiD" dropped.
2021-02-03 14:21:59.851 ===== TRACE ===== Index "kpihistory" dropped.
2021-02-03 14:21:59.858 ===== TRACE ===== Index "kpihi" dropped.
2021-02-03 14:22:00.091 ===== TRACE ===== Index "kpihistoryKpiDefinitionReferenceDate" created.
2021-02-03 14:22:00.134 ===== TRACE ===== Index "versionVersionType" created.
2021-02-03 14:22:00.612 ===== TRACE ===== Index "historyOperationDate" created.
2021-02-03 14:22:03.287 ===== TRACE ===== 122990 lines deleted from table "historyarchive".
2021-02-03 14:22:03.315 ===== TRACE ===== 0 lines updated into table "tender".
2021-02-03 14:22:04.415 ===== TRACE ===== 6467 lines updated into table "assignment".
2021-02-03 14:22:04.499 ===== TRACE ===== Index "plannedworkProject" created.
2021-02-03 14:22:04.598 ===== TRACE ===== Index "planningelementFixplanning" created.
2021-02-03 14:22:04.598 ===== TRACE =====
2021-02-03 14:22:04.599 ===== TRACE ===== DATABASE UPDATED
2021-02-03 14:22:04.599 ===== TRACE ===== WITH NO ERROR
2021-02-03 14:22:04.599 ===== TRACE =====
2021-02-03 14:22:04.604 ===== TRACE ===== update assignment were cost is null [9.0.3]
2021-02-03 14:22:04.981 ===== TRACE ===== => 1436 to update
2021-02-03 14:22:04.981 ===== TRACE ===== => setting unlimited execution time for script (more than 100 assignments to update)
2021-02-03 14:22:15.342 ===== TRACE ===== => 100 assignments done...
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] Exception-[23505] SQLSTATE[23505]: Unique violation: 7 ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "kpihistorykpidefinitionreferencedate"
DETAIL: Ключ "(idkpidefinition, reftype, refid, kpidate)=(2, Project, 30, 2021-02-03)" уже существует.
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] For query : update kpihistory set refid='30' , kpidate='2021-02-03' , day='20210203' , week='202105' , month='202102' , year='2021' , kpivalue='13.502342112429' , weight='32.13125' where id=15
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] Strack trace :
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1659]
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] #1 SqlElement->updateSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1126]
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] #2 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:790]
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] #3 SqlElement->save called at [/var/www/html/projeqtor/model/KpiValue.php:98]
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] #4 KpiValue->storeHistory called at [/var/www/html/projeqtor/model/KpiValue.php:77]
2021-02-03 14:22:20.576 ** ERROR ** [V9.0.2] #5 KpiValue->save called at [/var/www/html/projeqtor/model/KpiValue.php:150]
----- Skipped-----
------
How can we solve the problem?
Ticket #5254 recorded
Issue fixed on V9.0.4
Thanks for being quick! Update from 9.0.2 to 9.0.4 was successful, users are happy.:)