Planning seems not working anymore after upgrading to 4.5.3

Hello,

I'm upgrading only from stable to stable version, I just upgraded from 4.4.2 to 4.5.3 and after clicking on the planning button, now all the planned work that was displayed in the planning reports has disappeared. Only real work is displayed.
And in the report 'synthesis of availability' no more planned work seems to be present.

I checked into the database and the table 'plannedwork' is empty. I don't know if the table has been erased at the upgrade or when launching the recalculation of the planning.

Any idea?

Thanks
Jean Pierre

Hi Jean Pierre,

if you have a backup of database, then you could restore and start migration with admin user again. ProjeQtor recognizes, if you restored database is from a previous version and migrates automatically.
May this helps.

Best regards,

Klaus

Hi,
Thanks for the suggestions.
I've restored the last backup done before upgrading.
Then starting the migration has given an error on table "tempupdate" because it was already present, I think this was not an issue, so I've dropped this table from the db and done again the restore.
This time the migration went fine, and the planning reports were showing the planned work.
I've then relaunched the planning calculation and planned work is gone, the table is empty and no error has been shown nor recorded. Here follow the log of what I've done. I'll have a look at what has been changed in planning calculation between the 2 versions.

Ciao
Jean Pierre

2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== =====================================
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== DataBase actual Version = V4.4.2
2015-01-08 09:33:57 ===== TRACE ===== ProjeQtOr actual Version = V4.5.3
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== =====================================
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== VERSION V4.5.0
2015-01-08 09:33:57 ===== TRACE =====
2015-01-08 09:33:57 ===== TRACE ===== 1 lines updated into table "accessprofile".
2015-01-08 09:33:57 ===== TRACE ===== 1 lines updated into table "accessprofile".
2015-01-08 09:33:57 ===== TRACE ===== 1 lines inserted into table "dependable".
2015-01-08 09:33:57 ===== TRACE ===== 2 lines updated into table "planningmode".
2015-01-08 09:33:57 ===== TRACE ===== 1 lines inserted into table "accessscope".
2015-01-08 09:33:58 ===== TRACE ===== Table "audit" altered.
2015-01-08 09:33:58 ===== TRACE ===== 11 lines deleted from table "columnselector".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines updated into table "assignment".
2015-01-08 09:33:58 ===== TRACE ===== Table "assignment" altered.
2015-01-08 09:33:58 ===== TRACE ===== Table "planningelement" altered.
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== DATABASE UPDATED
2015-01-08 09:33:58 ===== TRACE ===== WITH NO ERROR
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== =====================================
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== VERSION V4.5.3
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== Table "tempupdate" created.
2015-01-08 09:33:58 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines inserted into table "tempupdate`
(SELECT".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2015-01-08 09:33:58 ===== TRACE ===== 0 lines deleted from table "workelement".
2015-01-08 09:33:58 ===== TRACE ===== ACTION '' NOT EXPECTED FOR QUERY : DELETE FROM `tempupdate` WHERE 1=1;
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== DATABASE UPDATED
2015-01-08 09:33:58 ===== TRACE ===== WITH NO ERROR
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== =====================================
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V4.5.3
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:33:58 ===== TRACE ===== =====================================
2015-01-08 09:33:58 ===== TRACE =====
2015-01-08 09:34:03 ===== TRACE ===== NEW CONNECTED USER 'jph'

Hi,

I've restored the previous version to check that the last changes done will not have broken something into the database, but adding the last imputations and running the planning again is done with success.
Can you precise me which are the source files involved in the planning calculation, I can try to find where the bug is.

Thanks in advance.
Ciao
Jean Pierre