Implementation Plan for Live (changes to format of Excel file)

Implementation to Live 30 September 2013

Log in

Log into the server fin-app-kb1.is.ed.ac.uk as the efin user.

Disable the cron that schedules the hourly process (it is commented ' Journal auto-upload HOURLY schedule').

 
This implementation will include only the jamsProcess application. Only one file has been changed in this release (jamsProcess/src/service/XmlConvert.java).
 
There is a  tagged release in SVN which can be found at:
 
 
 
 
Copy jamsProcess application code 
 
Replace the jamsProcess code with that from SVN:
 
 
 
Complete all properties files
 
Edit the file jamsProcess/resources/local.properties.
 
Set the env variable to live.
 
Set the database properties - host, port and SID (FINLIVE) (do not change the values for password or passwordkey)
 
Set the recipients variable to fisload@ed.ac.uk
 
Make sure that all other properties in the file have been set.
 
Check that jamsProcess/resources/log4j.properties contains the correct path to write the log file to.
 
 
 
Compile the code
 
Set the PATH to include ant:
 
> export PATH=$PATH:/home/efin/efin/jams/apache-ant-1.8.4/bin
 
cd to /home/efin/efin/jams/jamsProcess
 
> ant clean
 
> ant compile
 
 
 
Test the application is able to run
 
Check that the directory /home/efin/efin/jams/jamsfiles/pickuparea is empty.
 
Check that the jamsCleaup process is not currently running (check the crontab).
 
cd to the directory /home/efin/efin/jams/scripts.
 
> ./run_hourly.sh
 
Check that it ran OK by looking at the output displayed on the screen and the log in /home/efin/efin/jams/logs/jamsProcess.log.
 
 
 
Re-enable the cron
 
Finally, re-enable the cron that was disabled earlier.
 
 
 
Repeat on failover server
 
Repeat the process on fin-app-at (the cron should not be set on fin-app-at1).