Forum

[SOLVED] Problem wi...
 
Notifications
Retirer tout

[SOLVED] Problem with update from 9.0.2. to 9.0.3 version

4 Posts
2 Utilisateurs
0 Reactions
1,679 Vu
 Stas
(@airsnake)
Posts: 2
New Member
Début du sujet
 
[#7268]

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?


 
Posté : 3 Fév PM 12:022
(@babynus)
Posts: 14952
Membre Admin
 

Ticket #5254 recorded


 
Posté : 3 Fév PM 20:022
(@babynus)
Posts: 14952
Membre Admin
 

Issue fixed on V9.0.4


 
Posté : 3 Fév PM 21:022
 Stas
(@airsnake)
Posts: 2
New Member
Début du sujet
 

Thanks for being quick! Update from 9.0.2 to 9.0.4 was successful, users are happy.:)


 
Posté : 4 Fév AM 06:022
Share:
Retour en haut