This section describes how to upgrade to the latest version of SuperWEB2 from an earlier version.
Step 1 - Plan for the Upgrade
In this release there have been a number of changes to the way SuperWEB2 is configured.
For example, a number of configuration options that were previously set in <tomcat_home>\webapps\webapi\WEB-INF\faces-config.xml and <tomcat_home>\webapps\webapi\WEB-INF\web.xml are now defined in a new configuration file, <tomcat_home>\webapps\webapi\WEB-INF\classes\configuration.properties.
There are other configuration adjustments that were previously set in the configuration files and which are now set in SuperADMIN.
When you upgrade to this release, it will not be possible to simply copy across the modified configuration files from your old version. After upgrading you will need to follow the new instructions to reapply any customisations or configuration adjustments that you need.
Before starting, it is a good idea to make a note of all the configuration adjustments you have made to your existing system. You can then check Changes to Configuration Options in this Release - SuperWEB2 for details of how to reapply the customisations after you install the new version.
Step 2 - Backup Old SuperWEB2 Configuration
Although you will not be able to reuse the configuration files from your old version, you are recommended to backup these files before starting. If necessary, this will allow you to check any customisations that you had made to the old version, or roll back to the previous version if necessary.
The following files are the minimum subset that you should backup:
- Any language customisations you have made to <tomcat_home>\webapps\webapi\WEB-INF\common_labels.properties and <tomcat_home>\webapps\webapi\WEB-INF\message.properties (and the corresponding versions for other languages)
- Any custom UDF and TXDs saved in <tomcat_home>\webapps\webapi\WEB-INF\resources
- Any HTML info pages saved in <tomcat_home>\webapps\webapi\info
- All files in <tomcat_home>\webapps\webapi\WEB-INF\data\.repository
- <tomcat_home>\webapps\webapi\WEB-INF\classes\configuration.properties (only required if upgrading from 9.0 or above; this file was added in release 9.0, and will contain many of your configuration settings)
You may wish to backup the whole of the <tomcat_home>\webapps\wepapi directory just in case.
Step 3 - Install SuperWEB2
- Stop Tomcat if it is running.
- Delete the following files and directories (some of these files may not exist on your system, depending on which version you are upgrading from):
If applicable, prepare the User Data Repository for the upgrade by making sure that the SuperWEB2 user that writes to your external database has both ALTER and CREATE privileges over the tables in that database. If your database administrator will not allow the SuperWEB2 user to have ALTER and CREATE privileges, you will need to manually upgrade the databases. See the steps below for more information.
- Extract the SuperWEB2 ZIP file.
- Copy War Files\webapi.war from the extracted files to <tomcat_home>\webapps
- Copy tomcatLibs\spring-agent.jar from the extracted files to <tomcat_home>\lib
- Start Tomcat and verify that you can connect to SuperWEB2 in a web browser.
Step 4 - Reapply any Customisations
You will now need to reapply any customisations from your previous deployment. See Changes to Configuration Options in this Release - SuperWEB2 for help with this step as many settings have moved between version 8 and version 9.
If the version you are upgrading from is 9.0 or above, then you will need to reapply your changes to configuration.properties. It is important not to simply reuse your backup, as other settings may have been added to the file in this release.
Manual Upgrade of User Data Repository
If your database administrator will not allow the SuperWEB2 user to have CREATE TABLE and ALTER TABLE privileges, then you will need to manually upgrade the tables in the User Data Repository database.
If SuperWEB2 does not have the appropriate privileges, you will see an "insufficient privileges" error message similar to the following in the SW2.log file:
To resolve this:
- Run Tomcat at least once so that the SuperWEB2 war file gets extracted.
- Browse to the extracted files and locate <tomcat_home>\webapps\webapi\WEB-INF\classes\au\com\str\services\repository\dao\impl\sql\upgrade_9_0_0_<db>.sql (where
<db>is the type of RDBMS you are using for the UDR).
Provide this file to your database administrator and ask them to execute the SQL commands to upgrade the databases to the correct version.
In addition, ask your database administrator to execute the following SQL (this sets the internal version number of the UDR database to the current version, version 3):
Step 5 - Advise Users that the Upgrade is Complete
Once you have finished reapplying any customisations, you can advise your users that the upgrade is complete. In some cases, users may need to manually refresh their browsers to see the latest version of SuperWEB2. This is because their web browser may have cached the resources from the previous version (such as the product logo and the stylesheets).
If users are still seeing the old look and feel of SuperWEB2, this can be resolved in most cases by pressing F5 to refresh the web browser.