Major Upgrade

An upgrade to DreamApps installation is called a major upgrade, when there has been significant changes in database structure and/or engine features. The process involves the following steps.

Affected Items

Apart from the database itself, a major upgrade will affect the following folders:

html/
WEB-INF/lib/
WEB-INF/reports/
WEB-INF/resource/

and may optionally affect the following files and folders:

WEB-INF/classes/
WEB-INF/da.globals
WEB-INF/web.xml

It has no effects on custom, creports, assets, data, chtml and docs folders as they contain only custom items.

The Upgrade

The upgrade usually comes in two zip files, WEB-INF.zip and html.zip. Copy these from workshop into the respective folders: html.zip /usr/tomcat/webapps/da
WEB-INF.zip /usr/tomcat/webapps/da/WEB-INF

The Process

Take a database backup (Please see: PostgreSQL - Dumping and Restoring Data) and bring it to your own system or another server using sftp (probably, FileZilla). If not feasible, copy the zipped backup into /root folder (for Linux) or the Desktop (for Windows).

Take a backup of the entire system by zipping the folder da to da.zip and then setting it aside to /root folder (for Linux) or the Desktop (for Windows). It is also advisable to separately copy da.globals to a convenient place so that you don't have to open the entire archive, in case you need to compare it with the new file later.

cd /usr/tomcat/webapps
zip -r /root/da.zip da
cp da/WEB-INF/da.globals /root

Delete the folders html/, WEB-INF/lib/, WEB-INF/reports/ and WEB-INF/resource/. You must delete them totally or otherwise results could be unpredictable.

cd /usr/tomcat/webapps/da
rm -rf html
rm -rf WEB-INF/lib
rm -rf WEB-INF/resource
rm -rf WEB-INF/reports

Copy html.zip into folder da/ and extract it there, overwriting whatever that may come in it's way.

cd /usr/tomcat/webapps/da
unzip html.zip

Copy WEB-INF.zip into folder da/WEB-INF/ and extract it there, overwriting whatever that may come in it's way.

cd /usr/tomcat/webapps/da/WEB-INF
unzip WEB-INF.zip

Check da.globals to reinsert custom parameters, if any, by comparing it with the old one.

Restart tomcat.

Run initdb with option Upgrade All Tables.

Log in to any one of the businesses and set portal?page=catest in the URL to bring up Test page. In Method field, enter call caupgrade54 and then click on Run.

Logout and restart tomcat.