Details
-
Fix
-
Status: Dismissed (View Workflow)
-
Minor
-
Resolution: Works as designed
-
1.10
-
None
Description
Current Situation
When updating JobScheduler from 1.9. to 1.10. the tables SOSFTP_FILES* have to be renamed. This will be done by the script sosftphistory_to_jadehistory_rename.sql which should be called by scheduler_install_tables.sh.
As the script is not executed, the renaming will not be done. As an result the old tables still exist and the new tables are created but empty.
Desired behaviour
When updating from 1.9. to 1.10. the script sosftphistory_to_jadehistory_rename.sql should be executed to rename the YADE db tables.
Workaround:
Delete the empty tables JADE_FILES* and start install tables manually with scheduler_install_tables.cmd sosftphistory_to_jadehistory_rename.sql
Maintainer Note
- The sql script sosftphistory_to_jadehistory_rename.sql was not created to execute during the setup
- It is provided for an easy migration of the data from the "old" SOSFTP table to the new YADE tables.
- Here, the empty YADE tables have to drop after JobScheduler installation and the sql script is executed with
./install/scheduler_install_tables.sh sosftphistory_to_jadehistory_rename.sql
- Here, the empty YADE tables have to drop after JobScheduler installation and the sql script is executed with