REPORT ERRORS

Hi, good day. 

Thanks for your comments and your help. 
Effectively, if SELINUX was activated, we followed an tutorial that only disable selinux for projeqtor,  we disable all the selinux and the error stopped, Now we see only an icon:

 

Also we check the Log inside ProjeQtOr but nothing was shown.
Is there any other option or recommendation for this problem?

Hi,

As a test, we installed projeQtOr again and we saw that in this way the error that appeared in the reports could be solved, we also did it because when we wanted to update to the new version we also had problems.

Now, since these errors have been fixed, we want to migrate all the data that we have in the production environment to this new instance that has no errors. Is there a safe way to do this?

We understand that a complete copy of the binaries cannot be because it would bring the errors that were corrected in this new installation that was made.

Thanks!

Hi,
Thanks for your answer.

We did the projeqtor update and we also did the steps that you mentioned in the previous post for the database; the update and load of the database was done correctly, it did not show us any errors.

We use these commands to make the copy of the database:
     mysqldump -u root -p --all-databases > /home/opc/projeqtor.dump
     mysql -u root -p < /home/opc/projeqtor.dump

The problem we now have is that when we see the list of projects, some of the names are not there (As you can see in the image), the same happens with the name of some activities, with the resources, with the dedications.



Do you know why this happens? What has to be done to solve this problem?

I also attach the detail of the log file2021-11-19 15:46:59.403 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-11-19 15:56:02.205 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 15:56:03.496 ===== TRACE ===== NEW CONNECTED USER 'admin' (using remember me feature)
2021-11-19 15:56:26.376 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 15:57:15.597 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-11-19 15:57:36.797 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== =====================================
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== DataBase actual Version = V9.1.2
2021-11-19 16:00:47.104 ===== TRACE ===== ProjeQtOr actual Version = V9.3.2
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== =====================================
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== VERSION V9.2.0
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.107 ===== TRACE ===== 3 lines inserted into table "parameter".
2021-11-19 16:00:47.114 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:47.165 ===== TRACE ===== Table "activity" altered.
2021-11-19 16:00:47.178 ===== TRACE ===== Table "statusperiod" created.
2021-11-19 16:00:47.180 ===== TRACE ===== 6 lines inserted into table "habilitationother".
2021-11-19 16:00:47.182 ===== TRACE ===== 5 lines inserted into table "habilitationother".
2021-11-19 16:00:47.184 ===== TRACE ===== 1 lines updated into table "status".
2021-11-19 16:00:47.188 ===== TRACE ===== Table "delay" altered.
2021-11-19 16:00:47.194 ===== TRACE ===== Table "project" altered.
2021-11-19 16:00:47.203 ===== TRACE ===== Table "activityworkunit" created.
2021-11-19 16:00:47.204 ===== TRACE ===== 0 lines inserted into table "activityworkunit".
2021-11-19 16:00:47.207 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.213 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.216 ===== TRACE ===== Table "workcommanddone" altered.
2021-11-19 16:00:47.217 ===== TRACE ===== 0 lines updated into table "planningelement".
2021-11-19 16:00:47.217 ===== TRACE ===== 0 lines deleted from table "workcommanddone".
2021-11-19 16:00:47.218 ===== TRACE ===== 0 lines inserted into table "workcommanddone".
2021-11-19 16:00:47.309 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.381 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.467 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.520 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.584 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.616 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.675 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.710 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.713 ===== TRACE ===== Table "ticket" altered.
2021-11-19 16:00:47.716 ===== TRACE ===== Table "ticket" altered.
2021-11-19 16:00:47.719 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:47.721 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:47.723 ===== TRACE ===== 1 lines inserted into table "navigation".
2021-11-19 16:00:47.725 ===== TRACE ===== 3 lines inserted into table "habilitation".
2021-11-19 16:00:47.728 ===== TRACE ===== Table "documentdirectory" altered.
2021-11-19 16:00:47.731 ===== TRACE ===== Table "documentdirectory" altered.
2021-11-19 16:00:47.772 ===== TRACE ===== Index "documentdirectoryResource" created.
2021-11-19 16:00:47.781 ===== TRACE ===== Index "documentdirectoryUser" created.
2021-11-19 16:00:47.784 ===== TRACE ===== 13 lines updated into table "documentdirectory".
2021-11-19 16:00:47.788 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:47.797 ===== TRACE ===== Table "documentright" created.
2021-11-19 16:00:47.800 ===== TRACE ===== 143 lines inserted into table "documentright".
2021-11-19 16:00:47.803 ===== TRACE ===== 3 lines updated into table "type".
2021-11-19 16:00:47.805 ===== TRACE ===== 5 lines inserted into table "report".
2021-11-19 16:00:47.806 ===== TRACE ===== 5 lines inserted into table "habilitationreport".
2021-11-19 16:00:47.809 ===== TRACE ===== 26 lines inserted into table "reportparameter".
2021-11-19 16:00:47.810 ===== TRACE ===== 5 lines inserted into table "modulereport".
2021-11-19 16:00:47.821 ===== TRACE ===== Table "macrostatus" created.
2021-11-19 16:00:47.867 ===== TRACE ===== 3 lines inserted into table "macrostatus".
2021-11-19 16:00:47.869 ===== TRACE ===== 3 lines deleted from table "accessright".
2021-11-19 16:00:47.873 ===== TRACE ===== Table "subtask" altered.
2021-11-19 16:00:47.910 ===== TRACE ===== Table "workcommanddone" altered.
2021-11-19 16:00:47.991 ===== TRACE ===== Table "workcommandbilled" altered.
2021-11-19 16:00:48.027 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.089 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.124 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.191 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.227 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.284 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.318 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.321 ===== TRACE ===== Table "asset" altered.
2021-11-19 16:00:48.331 ===== TRACE ===== Table "kpivaluerequest" created.
2021-11-19 16:00:48.366 ===== TRACE ===== Index "kpivaluerequestReference" created.
2021-11-19 16:00:48.367 ===== TRACE ===== 1 lines inserted into table "cronexecution".
2021-11-19 16:00:48.369 ===== TRACE ===== 1 lines inserted into table "parameter".
2021-11-19 16:00:48.379 ===== TRACE ===== Table "pokercomplexity" created.
2021-11-19 16:00:48.389 ===== TRACE ===== Table "pokersession" created.
2021-11-19 16:00:48.399 ===== TRACE ===== Table "pokerresource" created.
2021-11-19 16:00:48.413 ===== TRACE ===== Table "pokeritem" created.
2021-11-19 16:00:48.422 ===== TRACE ===== Table "pokervote" created.
2021-11-19 16:00:48.424 ===== TRACE ===== 4 lines inserted into table "menu".
2021-11-19 16:00:48.426 ===== TRACE ===== 4 lines inserted into table "navigation".
2021-11-19 16:00:48.428 ===== TRACE ===== 11 lines inserted into table "pokercomplexity".
2021-11-19 16:00:48.430 ===== TRACE ===== 2 lines inserted into table "type".
2021-11-19 16:00:48.432 ===== TRACE ===== 1 lines inserted into table "module".
2021-11-19 16:00:48.434 ===== TRACE ===== 4 lines inserted into table "modulemenu".
2021-11-19 16:00:48.435 ===== TRACE ===== 9 lines inserted into table "habilitation".
2021-11-19 16:00:48.438 ===== TRACE ===== 11 lines inserted into table "habilitation".
2021-11-19 16:00:48.466 ===== TRACE ===== 16 lines inserted into table "accessright".
2021-11-19 16:00:48.469 ===== TRACE ===== Table "workunit" altered.
2021-11-19 16:00:48.472 ===== TRACE ===== 6 lines inserted into table "cronexecution".
2021-11-19 16:00:48.476 ===== TRACE ===== Table "navigation" altered.
2021-11-19 16:00:48.478 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.481 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.483 ===== TRACE ===== 4 lines inserted into table "menu".
2021-11-19 16:00:48.485 ===== TRACE ===== 4 lines inserted into table "habilitation".
2021-11-19 16:00:48.487 ===== TRACE ===== 3 lines inserted into table "accessright".
2021-11-19 16:00:48.489 ===== TRACE ===== 1 lines inserted into table "module".
2021-11-19 16:00:48.490 ===== TRACE ===== 3 lines inserted into table "modulemenu".
2021-11-19 16:00:48.504 ===== TRACE ===== Table "localizationtranslator" created.
2021-11-19 16:00:48.514 ===== TRACE ===== Table "localizationtranslatorlanguage" created.
2021-11-19 16:00:48.523 ===== TRACE ===== Table "languageskilllevel" created.
2021-11-19 16:00:48.525 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:48.526 ===== TRACE ===== 1 lines inserted into table "habilitation".
2021-11-19 16:00:48.528 ===== TRACE ===== 1 lines inserted into table "accessright".
2021-11-19 16:00:48.530 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:48.532 ===== TRACE ===== 1 lines inserted into table "habilitation".
2021-11-19 16:00:48.574 ===== TRACE ===== Table "localizationrequest" created.
2021-11-19 16:00:48.576 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:48.587 ===== TRACE ===== Table "localizationItem" created.
2021-11-19 16:00:48.590 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:48.592 ===== TRACE ===== 1 lines inserted into table "habilitation".
2021-11-19 16:00:48.595 ===== TRACE ===== 2 lines inserted into table "mailable".
2021-11-19 16:00:48.599 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:48.602 ===== TRACE ===== 13 lines inserted into table "navigation".
2021-11-19 16:00:48.604 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.606 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.608 ===== TRACE ===== 3 lines inserted into table "modulemenu".
2021-11-19 16:00:48.611 ===== TRACE ===== 3 lines inserted into table "languageskilllevel".
2021-11-19 16:00:48.613 ===== TRACE ===== 3 lines inserted into table "type".
2021-11-19 16:00:48.616 ===== TRACE ===== 2 lines inserted into table "eventformail".
2021-11-19 16:00:48.617 ===== TRACE ===== 2 lines inserted into table "parameter".
2021-11-19 16:00:48.619 ===== TRACE ===== 1 lines inserted into table "mailable".
2021-11-19 16:00:48.621 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.623 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.625 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.627 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.628 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.630 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.633 ===== TRACE ===== Table "message" altered.
2021-11-19 16:00:48.665 ===== TRACE ===== Table "message" altered.
2021-11-19 16:00:48.667 ===== TRACE ===== 11 lines inserted into table "reportparameter".
2021-11-19 16:00:48.680 ===== TRACE ===== Index "indicatorvalueType" created.
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.681 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:48.681 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.681 ===== TRACE ===== =====================================
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.681 ===== TRACE ===== VERSION V9.2.1
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:48.683 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== =====================================
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== VERSION V9.3.0
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.687 ===== TRACE ===== Table "pokeritem" altered.
2021-11-19 16:00:48.691 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.694 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.697 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.790 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.864 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.897 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.934 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.965 ===== TRACE ===== Table "pokercomplexity" altered.
2021-11-19 16:00:48.967 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:48.969 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.971 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.973 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.975 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.977 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.979 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.981 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.983 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.986 ===== TRACE ===== Table "pokerresource" altered.
2021-11-19 16:00:48.989 ===== TRACE ===== 1 lines inserted into table "planningmode".
2021-11-19 16:00:48.990 ===== TRACE ===== 4 lines inserted into table "accessright".
2021-11-19 16:00:48.993 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.995 ===== TRACE ===== 3 lines updated into table "navigation".
2021-11-19 16:00:48.996 ===== TRACE ===== 1 lines inserted into table "navigation".
2021-11-19 16:00:49.006 ===== TRACE ===== Table "highlight" created.
2021-11-19 16:00:49.008 ===== TRACE ===== 1 lines inserted into table "cronexecution".
2021-11-19 16:00:49.010 ===== TRACE ===== Table "module" altered.
2021-11-19 16:00:49.066 ===== TRACE ===== Table "module" altered.
2021-11-19 16:00:49.069 ===== TRACE ===== 6 lines inserted into table "module".
2021-11-19 16:00:49.071 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.073 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.075 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.076 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.078 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.080 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.082 ===== TRACE ===== 2 lines updated into table "module".
2021-11-19 16:00:49.084 ===== TRACE ===== 2 lines updated into table "module".
2021-11-19 16:00:49.086 ===== TRACE ===== 2 lines inserted into table "modulemenu".
2021-11-19 16:00:49.099 ===== TRACE ===== Index "historyarchiveRef" created.
2021-11-19 16:00:49.101 ===== TRACE ===== Table "messagelegal" altered.
2021-11-19 16:00:49.103 ===== TRACE ===== 1 lines inserted into table "copyable".
2021-11-19 16:00:49.106 ===== TRACE ===== Table "command" altered.
2021-11-19 16:00:49.109 ===== TRACE ===== Table "inputmailbox" altered.
2021-11-19 16:00:49.111 ===== TRACE ===== 1 lines inserted into table "notifiable".
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.111 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:49.111 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.111 ===== TRACE ===== =====================================
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.111 ===== TRACE ===== VERSION V9.3.1
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== 2 lines updated into table "reportparameter".
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:49.114 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== =====================================
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== VERSION V9.3.2
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.117 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:49.165 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:49.165 ===== TRACE =====
2021-11-19 16:00:49.165 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:49.165 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:49.165 ===== TRACE =====
2021-11-19 16:00:49.167 ===== TRACE ===== update workCommandDone [9.2.0]
2021-11-19 16:00:49.480 ===== TRACE ===== => 0 to update
2021-11-19 16:00:49.482 ===== TRACE ===== => 0 workCommandDone updated
2021-11-19 16:00:49.482 ===== TRACE ===== update project [9.2.0]
2021-11-19 16:00:49.482 ===== TRACE ===== => 1 project updated
2021-11-19 16:00:50.069 ===== TRACE ===== =====================================
2021-11-19 16:00:50.069 ===== TRACE =====
2021-11-19 16:00:50.069 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V9.3.2
2021-11-19 16:00:50.069 ===== TRACE =====
2021-11-19 16:00:50.069 ===== TRACE ===== =====================================
2021-11-19 16:00:50.069 ===== TRACE =====
2021-11-19 16:01:16.811 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-11-19 17:10:34.173 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 17:10:35.602 ===== TRACE ===== NEW CONNECTED USER 'admin' (using remember me feature)
2021-11-19 17:19:53.798 ===== TRACE ===== NEW CONNECTED USER 'admin'