Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-75

Setup should execute the YADE rename script for database

    XMLWordPrintable

Details

    • Fix
    • Status: Dismissed (View Workflow)
    • Minor
    • Resolution: Works as designed
    • 1.10
    • 1.10.6
    • 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
          

      Attachments

        Activity

          People

            oh Oliver Haufe
            ur Uwe Risse
            Santiago Aucejo Petzoldt Santiago Aucejo Petzoldt
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: