Upgrading to a New Release
(And a trick for installing later releases from scratch!)
Thursday, April 30, 2009Copyright 2006,2008, R. James Holton. All rights reserved.
Although it is currently a manual process, upgrading to a later release of ESS is fairly straightforward. You are required to download the release ZIP file and basically move the contents of the ess and ess-app folders to your installation. You may then be required to add elements to configuration files. This document covers upgrading from release 4.0.3 to 6.2.0. This allows you to install the latest ESA appliance and then upgrade the software to the most recent.
Trick: A simple and quick way to install ESS from scratch, is to use the installer from release 4.0.3 and then upgrade. This is much easier than manually installing Apache, Tomcat, MySQL, the connector and finally ESS.
Here are the steps required to upgrade from a previous version of ESS to the most current:
a) {www} = “c:/ess/apache2”
b)
{app} = “c:/ess/
c) {data} = “c:/ess”
d) ConfiugrationInfo.txt = “c:/ess/ConfigurationInfo.txt”
Copy of the update.sql
USE
ADISOFT;
CREATE
TABLE FX ( CURRENCY varchar(20),
XDATE date,
HOME varchar(20),
XRATE numeric(14,4),
RATETYPE char(1),
XSOURCE char(36),
CONSTRAINT PK_RATE
PRIMARY KEY (CURRENCY, XDATE, HOME) );
CREATE
TABLE MILEAGE ( COMPANY varchar(8),
EFFECTIVE date,
UNITS varchar(10),
CURRENCY varchar(20),
RATE numeric(12,4),
CONSTRAINT PK_MILEAGE
PRIMARY KEY (COMPANY, EFFECTIVE) );
INSERT INTO
MILEAGE VALUES ( '001','2001-01-01','Miles','US
Dollars',0.4250);
DROP TABLE
COMPANY;
CREATE
TABLE COMPANY ( COMPANY varchar(8),
DESCRIP varchar(30),
PAYROLL varchar(3),
CURRENCY varchar(20),
UNITS varchar(20),
PARENT varchar(100),
LOGOFILE varchar(100),
HEIGHT varchar(3),
WIDTH varchar(3),
CLIENT varchar(8),
EXPENSE varchar(8),
PAYMENT varchar(8),
MERCHANT varchar(8),
LOCATION varchar(8),
GUIDE varchar(12),
MILEAGE varchar(8),
PROJECT varchar(8),
OFFSETS varchar(20),
STEPS varchar(20),
AUDITOR varchar(12),
LANGUAGE varchar(10),
MAPPING varchar(100),
ACTIVE char(1),
GL_COMPANY varchar(8),
PURPOSESCREEN varchar(30),
CONSTRAINT PK_COMPANY
PRIMARY KEY (COMPANY) );
INSERT INTO
COMPANY VALUES ( '001','General Company','','US
Dollar','Miles','ess-app/Report.jsp','ERaaS.gif','50','150','001','001','001','001','001','STD','001','001','generaloffset','steps','','English','','1','001','Head2b');
ALTER TABLE
account ADD COMPANY VARCHAR(8);
ALTER TABLE
charge ADD COMPANY VARCHAR(8);
ALTER TABLE
client ADD COMPANY VARCHAR(8);
ALTER TABLE
location ADD COMPANY VARCHAR(8);
ALTER TABLE
project ADD COMPANY VARCHAR(8);
ALTER TABLE
merchant ADD COMPANY VARCHAR(8);
ALTER TABLE
user ADD COMPANY VARCHAR(8) AFTER DEPART;
ALTER TABLE
report ADD COMPANY VARCHAR(8) AFTER DEPART;
ALTER TABLE
report ADD CURRENCY VARCHAR(20);
ALTER TABLE
report ADD HISTORY VARCHAR(8);
ALTER TABLE
user ADD CURRENCY VARCHAR(20);
ALTER TABLE
user ADD XFUNCTION VARCHAR(10);
ALTER TABLE
user ADD LANGUAGE VARCHAR(10);
UPDATE
account SET COMPANY = '001';
UPDATE
charge SET COMPANY = '001';
UPDATE
client SET COMPANY = '001';
UPDATE
location SET COMPANY = '001';
UPDATE
project SET COMPANY = '001';
UPDATE
merchant SET COMPANY = '001';
UPDATE user
SET COMPANY = '001';
UPDATE
report SET COMPANY = '001';
UPDATE user
SET CURRENCY = 'US Dollar';
UPDATE user
SET XFUNCTION = 'Auditor';
UPDATE user
SET LANGUAGE = 'English';
INSERT INTO
SYSTEM VALUES ( 'ESS','COMPANY_SEQUENCE','100');
INSERT INTO
SYSTEM VALUES ( 'ESS','PERSNUM_SEQUENCE','100');
INSERT INTO
SYSTEM VALUES ( 'ESS','SCAN_SEQUENCE','100');
CREATE
TABLE CURRENCY ( CURRENCY varchar(20),
XLIMIT numeric(12,2),
COMMENT varchar(60),
XSHOW char(1),
SHOWLIST char(1),
CONSTRAINT PK_CURRENCY
PRIMARY KEY (CURRENCY) );
INSERT INTO
CURRENCY VALUES ( 'US Dollar',10000,'','1','1');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'ECC Euro',10000,'','1','4');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Czech Koruna',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Isreal
Shekel',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Jordan Dinar',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Phillippines
Peso',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Saudia
Arabia Riyals',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Slovak Koruna',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'United Arab
Dirham',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( 'Uraguay
Peso',10000,'','1','5');
INSERT INTO
CURRENCY VALUES ( '
INSERT INTO
CURRENCY VALUES ( 'Specify in
Source',10000,'','1','9');
###