Skip to main content

I have been playing with v11.7 of assyst and uncovered a few minor issues during the DB upgrade in a DEV environment (from v11.3.8), so I am just posting those for your information:

  1. The DB upgrade script fails when trying to add the stored procedure RESET_EVENT_HKS, which already exists in our schema.
    Mitigation: delete the stored procedure before running the upgrade.
    Long term solution suggestion: Ideally have the upgrade script always drop the stored proc prior to creation.
  1. Migration of forms will fail if they have multiple Web Custom Groups with the same label (in design mode), DB upgrade SQL fails with a duplicate error.
    Mitigation: before the upgrade, change the labels in design mode to make them unique, and then add the proper display label as a customization at the Global-English level.
    Long term solution suggestion: allow renaming of the label during DB migration to add a suffix, for example: “…_1”, “…_2” etc.

Dear customer,

Thank you for the feedback provided 

And for more information regarding upgrading assyst database , please check the wiki link below :

https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Installation:Upgrading_a_Previous_Version_of_the_assyst_Database

 

Kindest regards,

 

 


Reply