View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error DB upgrade 9.0.1 -> 9.1.0 - ProjeQtOr
 

Error DB upgrade 9.0.1 -> 9.1.0

More
16 Mar 2021 11:24 #1 by Segelohr
2021-03-16 11:20:38.684 ===== TRACE =====
2021-03-16 11:20:38.695 ===== TRACE ===== =====================================
2021-03-16 11:20:38.696 ===== TRACE =====
2021-03-16 11:20:38.696 ===== TRACE ===== DataBase actual Version = V9.0.1
2021-03-16 11:20:38.696 ===== TRACE ===== ProjeQtOr actual Version = V9.1.0
2021-03-16 11:20:38.696 ===== TRACE =====
2021-03-16 11:20:38.696 ===== TRACE ===== =====================================
2021-03-16 11:20:38.696 ===== TRACE =====
2021-03-16 11:20:38.697 ===== TRACE ===== VERSION V9.0.2
2021-03-16 11:20:38.697 ===== TRACE =====
2021-03-16 11:20:38.725 ===== TRACE ===== 1 lines updated into table "navigation".
2021-03-16 11:20:38.800 ===== TRACE ===== Index "" dropped.
2021-03-16 11:20:38.899 ===== TRACE ===== Index "" dropped.
2021-03-16 11:20:39.077 ===== TRACE ===== Index "parameterUserProject" created.
2021-03-16 11:20:39.078 ===== TRACE =====
2021-03-16 11:20:39.078 ===== TRACE ===== DATABASE UPDATED
2021-03-16 11:20:39.078 ===== TRACE ===== WITH NO ERROR
2021-03-16 11:20:39.078 ===== TRACE =====
2021-03-16 11:20:39.078 ===== TRACE ===== =====================================
2021-03-16 11:20:39.078 ===== TRACE =====
2021-03-16 11:20:39.078 ===== TRACE ===== VERSION V9.0.3
2021-03-16 11:20:39.078 ===== TRACE =====
2021-03-16 11:20:39.104 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.163 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-03-16 11:20:39.168 ===== TRACE ===== 0 lines deleted from table "audit".
2021-03-16 11:20:39.169 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.171 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-03-16 11:20:39.176 ===== TRACE ===== 0 lines deleted from table "audit".
2021-03-16 11:20:39.177 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.179 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-03-16 11:20:39.184 ===== TRACE ===== 0 lines deleted from table "audit".
2021-03-16 11:20:39.185 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.228 ===== TRACE ===== Index "" dropped.
2021-03-16 11:20:39.466 ===== TRACE ===== Index "auditSessionId" created.
2021-03-16 11:20:39.467 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.483 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-03-16 11:20:39.485 ===== TRACE ===== 0 lines deleted from table "kpihistory".
2021-03-16 11:20:39.486 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.487 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-03-16 11:20:39.489 ===== TRACE ===== 0 lines deleted from table "kpihistory".
2021-03-16 11:20:39.490 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.491 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2021-03-16 11:20:39.493 ===== TRACE ===== 0 lines deleted from table "kpihistory".
2021-03-16 11:20:39.494 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2021-03-16 11:20:39.565 ===== TRACE ===== Index "" dropped.
2021-03-16 11:20:39.608 ===== TRACE ===== Index "" dropped.
2021-03-16 11:20:39.699 ===== TRACE ===== Index "" dropped.
2021-03-16 11:20:39.836 ===== TRACE ===== Index "kpihistoryKpiDefinitionReferenceDate" created.
2021-03-16 11:20:40.051 ===== TRACE ===== Index "versionVersionType" created.
2021-03-16 11:20:41.667 ===== TRACE ===== Index "historyOperationDate" created.
2021-03-16 11:20:41.867 ===== TRACE ===== 2952 lines deleted from table "historyarchive".
2021-03-16 11:20:41.886 ===== TRACE ===== 0 lines updated into table "tender".
2021-03-16 11:20:41.944 ===== TRACE ===== 0 lines updated into table "assignment".
2021-03-16 11:20:42.197 ===== TRACE ===== Index "plannedworkProject" created.
2021-03-16 11:20:42.458 ===== TRACE ===== Index "planningelementFixplanning" created.
2021-03-16 11:20:42.459 ===== TRACE =====
2021-03-16 11:20:42.459 ===== TRACE ===== DATABASE UPDATED
2021-03-16 11:20:42.459 ===== TRACE ===== WITH NO ERROR
2021-03-16 11:20:42.459 ===== TRACE =====
2021-03-16 11:20:42.459 ===== TRACE ===== =====================================
2021-03-16 11:20:42.460 ===== TRACE =====
2021-03-16 11:20:42.460 ===== TRACE ===== VERSION V9.0.5
2021-03-16 11:20:42.460 ===== TRACE =====
2021-03-16 11:20:42.498 ===== TRACE ===== 3 lines inserted into table "referencable".
2021-03-16 11:20:42.530 ===== TRACE ===== 2 lines updated into table "referencable".
2021-03-16 11:20:42.550 ===== TRACE ===== 0 lines inserted into table "navigation".
2021-03-16 11:20:42.551 ===== TRACE =====
2021-03-16 11:20:42.551 ===== TRACE ===== DATABASE UPDATED
2021-03-16 11:20:42.551 ===== TRACE ===== WITH NO ERROR
2021-03-16 11:20:42.551 ===== TRACE =====
2021-03-16 11:20:42.551 ===== TRACE ===== =====================================
2021-03-16 11:20:42.551 ===== TRACE =====
2021-03-16 11:20:42.551 ===== TRACE ===== VERSION V9.1.0
2021-03-16 11:20:42.552 ===== TRACE =====
2021-03-16 11:20:42.575 ===== TRACE ===== 1 lines inserted into table "menu".
2021-03-16 11:20:42.634 ===== TRACE ===== 13 lines inserted into table "modulemenu".
2021-03-16 11:20:42.665 ===== TRACE ===== 2 lines inserted into table "navigation".
2021-03-16 11:20:42.753 ===== TRACE ===== 3 lines inserted into table "habilitation".
2021-03-16 11:20:42.845 ===== TRACE ===== 3 lines inserted into table "accessright".
2021-03-16 11:20:42.920 ===== TRACE ===== 1 lines inserted into table "parameter".
2021-03-16 11:20:43.683 ===== TRACE ===== Table "subtask" created.
2021-03-16 11:20:43.871 ===== TRACE ===== Table "workcommand" created.
2021-03-16 11:20:44.028 ===== TRACE ===== Table "workcommanddone" created.
2021-03-16 11:20:44.223 ===== TRACE ===== Table "workcommandbilled" created.
2021-03-16 11:20:44.257 ===== TRACE ===== Table "planningelement" altered.
2021-03-16 11:20:44.410 ===== TRACE ===== Table "project" altered.
2021-03-16 11:20:44.441 ===== TRACE ===== Table "status" altered.
2021-03-16 11:20:44.442 ***** ERROR ***** [V9.0.1] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '18' for key 'PRIMARY'
2021-03-16 11:20:44.442 ***** ERROR ***** [V9.0.1] For query : INSERT INTO `status` (`id`, `name`, `setDoneStatus`, `setIdleStatus`, `color`, `sortOrder`, `idle`, `setHandledStatus`, `isCopyStatus`, `setCancelledStatus`, `setIntoserviceStatus`, `setSubmittedLeave`, `setAcceptedLeave`, `setRejectedLeave`, `fixPlanning`, `setPausedStatus`) VALUES
(18, 'paused', '0', '0', '#BABABA', '350', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1');
2021-03-16 11:20:44.442 ***** ERROR ***** [V9.0.1] Strack trace :
2021-03-16 11:20:44.442 ***** ERROR ***** [V9.0.1] #0 Sql->query called at [/volume1/web/protestor/db/maintenanceFunctions.php:71]
2021-03-16 11:20:44.443 ***** ERROR ***** [V9.0.1] #1 runScript called at [/volume1/web/protestor/db/maintenance.php:112]
2021-03-16 11:20:44.443 ***** ERROR ***** [V9.0.1] #2 include called at [/volume1/web/protestor/tool/loginCheck.php:143]
2021-03-16 11:20:44.443 ===== TRACE =====
2021-03-16 11:20:44.443 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V9.1.0 (see above message)
2021-03-16 11:20:44.443 ===== TRACE =====
2021-03-16 11:20:44.444 ===== TRACE ===== *************************************************
2021-03-16 11:20:44.444 ===== TRACE =====
2021-03-16 11:20:44.493 ===== TRACE ===== 14 lines inserted into table "workflowstatus".
2021-03-16 11:20:44.533 ===== TRACE ===== Table "project" altered.
2021-03-16 11:20:44.791 ===== TRACE ===== Table "activity" altered.
2021-03-16 11:20:44.942 ===== TRACE ===== Table "planningelement" altered.
2021-03-16 11:20:45.015 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-03-16 11:20:45.134 ===== TRACE ===== 1 lines inserted into table "linkable".
2021-03-16 11:20:45.169 ===== TRACE ===== 12 lines inserted into table "modulereport".
2021-03-16 11:20:45.198 ===== TRACE ===== 8 lines inserted into table "habilitationother".
2021-03-16 11:20:45.216 ===== TRACE ===== 1 lines inserted into table "report".
2021-03-16 11:20:45.270 ===== TRACE ===== 2 lines inserted into table "reportparameter".
2021-03-16 11:20:45.297 ===== TRACE ===== 3 lines inserted into table "habilitationreport".
2021-03-16 11:20:45.329 ===== TRACE ===== 7 lines inserted into table "habilitationother".
2021-03-16 11:20:45.332 ===== TRACE ===== 3 lines inserted into table "report".
2021-03-16 11:20:45.373 ===== TRACE ===== 3 lines inserted into table "habilitationreport".
2021-03-16 11:20:45.377 ===== TRACE ===== 11 lines inserted into table "reportparameter".
2021-03-16 11:20:45.426 ===== TRACE ===== 4 lines inserted into table "modulereport".
2021-03-16 11:20:45.487 ===== TRACE ===== Table "document" altered.
2021-03-16 11:20:45.710 ===== TRACE ===== Table "approvalstatus" created.
2021-03-16 11:20:45.742 ===== TRACE ===== 4 lines inserted into table "approvalstatus".
2021-03-16 11:20:45.742 ===== TRACE =====
2021-03-16 11:20:45.742 ===== TRACE ===== DATABASE UPDATED
2021-03-16 11:20:45.743 ===== TRACE ===== WITH 1 ERROR
2021-03-16 11:20:45.743 ===== TRACE =====
2021-03-16 11:20:45.797 ===== TRACE ===== update assignment were cost is null [9.0.3]
2021-03-16 11:20:45.802 ===== TRACE ===== => 0 to update
2021-03-16 11:20:45.802 ===== TRACE ===== => 0 assignments updated
2021-03-16 11:20:45.803 ===== TRACE ===== update assignment with unique ressource without assignmentSelection [9.0.5]
2021-03-16 11:20:45.815 ===== TRACE ===== => 0 to update
2021-03-16 11:20:45.815 ===== TRACE ===== => 0 assignments updated
2021-03-16 11:20:45.815 ===== TRACE ===== =====================================
2021-03-16 11:20:45.815 ===== TRACE =====
2021-03-16 11:20:45.815 ===== TRACE ===== VERSION V9.0.6.lm
2021-03-16 11:20:45.816 ===== TRACE =====
2021-03-16 11:20:47.425 ===== TRACE ===== Table "livemeeting" altered.
2021-03-16 11:20:47.425 ===== TRACE =====
2021-03-16 11:20:47.425 ===== TRACE ===== DATABASE UPDATED
2021-03-16 11:20:47.426 ===== TRACE ===== WITH NO ERROR
2021-03-16 11:20:47.426 ===== TRACE =====
2021-03-16 11:20:47.426 ===== TRACE ===== =====================================
2021-03-16 11:20:47.426 ===== TRACE =====
2021-03-16 11:20:47.426 ===== TRACE ===== VERSION V9.1.0.mysql
2021-03-16 11:20:47.426 ===== TRACE =====
2021-03-16 11:20:47.443 ===== TRACE ===== Table "cataloguo" altered.
2021-03-16 11:20:47.443 ===== TRACE =====
2021-03-16 11:20:47.443 ===== TRACE ===== DATABASE UPDATED
2021-03-16 11:20:47.443 ===== TRACE ===== WITH NO ERROR
2021-03-16 11:20:47.443 ===== TRACE =====
2021-03-16 11:20:47.444 ===== TRACE ===== update document idApprovalStatus [9.1.0]
2021-03-16 11:20:47.446 ===== TRACE ===== => 0 to update
2021-03-16 11:20:47.446 ===== TRACE ===== => 0 documents updated
2021-03-16 11:20:48.809 ===== TRACE ===== =====================================
2021-03-16 11:20:48.810 ===== TRACE =====
2021-03-16 11:20:48.810 ===== TRACE ===== 1 ERRORS DURING UPGRADE TO VERSION V9.1.0
2021-03-16 11:20:48.810 ===== TRACE =====
2021-03-16 11:20:48.810 ===== TRACE ===== =====================================


Best Regards
Andreas

Please Log in or Create an account to join the conversation.

More
16 Mar 2021 12:44 #2 by mkavurcic
1. check in Configuration->List of Values->Status if entry with id 18 exists (error suggests thati it does - primary key violated); it may be that you have entered additional workflow statuses
2. insert into status table via sql
INSERT INTO `status` (`id`, `name`, `setDoneStatus`, `setIdleStatus`, `color`, `sortOrder`, `idle`, `setHandledStatus`, `isCopyStatus`, `setCancelledStatus`, `setIntoserviceStatus`, `setSubmittedLeave`, `setAcceptedLeave`, `setRejectedLeave`, `fixPlanning`, `setPausedStatus`) VALUES
(xx, 'paused', '0', '0', '#BABABA', '350', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1');
setting xx to max id +1
or
insert using status form
The following user(s) said Thank You: Segelohr

Please Log in or Create an account to join the conversation.

More
16 Mar 2021 12:53 #3 by Segelohr
Thanks.
FYI: It happened on our separate test installation, where i check operability
of updates before updating the live system

Please Log in or Create an account to join the conversation.

More
16 Mar 2021 15:01 #4 by babynus
Hi,

This is a deployment issue that will be fixed on V9.1.1

Note that this issue is minor : you will not have new status called "paused", with "isPauseStatus' = 1
But you can easily create one like this through status screen if needed.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.040 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.