Upgrade Notes MQAttach v1.14.3.4,5 - v1.15.0.19 - Major Release Date Released: 01 September 2013 - 20 June 2015 ================================ If you are upgrading to this patch and you already have 1.14.3.4,1.14.3.5 installed: 1. Stop MQALauncher 2. Download the server update - MQ Client V7.1.0.2 or higher -------------------------- http://www.mqattach.com/download/public/MFT/Upgrade.zip MQ Client V7.01.04 or higher ---------------------------- http://www.mqattach.com/download/public/FTE/Upgrade.zip and unzip to a temp area 3. Run the database upgrade dataupdate.sql contained in the zip file against your mqattach database (make sure you select the correct database) 4. Run the MQ Script - ALTER.MQ.TXT against your MQ Environment changing the subscription values to meet your enviroment (only do this if you are running 1.14.0.x) 5. copy the folders (MQAdmin, MQACMD, MQALauncher) in the zip and replace the contents of c:\program files\mqattach\ 6. navigate to c:\program files[x86]\mqattach\mqaweb\ 7. backup the current web.config to web.config.old 8. copy web.config from the temp area to c:\program files[x86]\mqattach\mqaweb\ overwritting existing 9. edit in notepad the web.config.old created in step 7 and note the "impersonate" user and password where applicable 10. edit the web.config and change the impersonate" section to be uncommented and include the name of the user and password from step 9 11. navigate to the temparea\mqaweb\ 12. select all files and copy overwritting c:\program files[x86]\mqattach\mqaweb\ 10. clear the windows event log MQAttach (optional) 13. restart IIS 14. Restart MQALauncher 12. Navigate to http://localhost/MQAttach/Forms/frmLogin.aspx and ensure no errors MQA Exits ---------- Download the version appropriate to your fte environment If you are support customer or seriously considering support contracts send us an email to sales@mqattach.com or support@mqattach.com and we would be happy to provide download locations read http://www.mqattach.com/download/docs/FTE_Exits.pdf - for functionality MQAttach v1.14.3.4 - v1.14.3.5 - Patch Release Date Released: 19 December 2012 ================================ If you are upgrading to this patch and you already have 1.14.3.4 installed: 1. Stop MQALauncher 2. Download the server update - MQ Client V7.1 or higher -------------------------- www.mqattach.com/updates/MQAServerV11435.zip MQ Client V7.01 ----------------- www.mqattach.com/updates/701/MQAServerV11435.zip and unzip to a temp area 3. Run the database upgrade dataupdate.sql contained in the zip file against your mqattach database 4. copy all folders in the zip and replace the contents of c:\program files\mqattach 5. Download the web update 6. copy all files in the unzipped folder replacing c:\program files\mqattach\mqaweb\ 10. clear the windows event log MQAttach 11. restart MQALauncher and wait about 2 min for launcher processes to take effect 12. Navigate to http://localhost/MQAttach/Forms/frmLogin.aspx and ensure no errors MQAttach v1.14.3.0 - v1.14.3.4 - Patch Release Date Released: 03 October 2012 ================================ If you are upgrading to this patch and you already have 1.14.3.0 installed: 1. Stop MQALauncher 2. Download the server update - www.mqattach.com/updates/MQAServerV11434.zip and unzip to a temp area 3. Run the database upgrade dataupdate-14-3-0-14-3-4.sql contained in the zip file against your mqattach database 4. copy all folders in the zip and replace the contents of c:\program files\mqattach 5. Download the web update www.mqattach.com/updates/MQAWebV11434.zip and unzip to a temp area 6. copy all files in the unzipped folder replacing c:\program files\mqattach\mqaweb\ 10. clear the windows event log MQAttach 11. restart MQALauncher and wait about 2 min for launcher processes to take effect 12. Navigate to http://localhost/MQAttach/Forms/frmLogin.aspx and ensure no errors MQAttach v1.14.3.0 Date Released: 14 August 2012 ================================ Due to tha various patches and timing of updates done by customers, when upgrading the following steps should be taken: 1. Send your current database creation script to us by emailing it to prodsupport@mqattach.com this can be done by: a) going into sql server management studio - right click on the database - tasks - generate scripts - script all objects and send us the resulting script 2. Receive the updated script from us that is configured for your environment 3. Stop MQALauncher Service 4. Open the script we provided in SQL Managementn Studio and execute it AGAINST your MQAttach Database (select the database in the top right hand corner) If there are errors please report to us immediatly 5. Unzip the update www.mqattach.com/updates/MQAServerV11434.zip and replace all files in c:\program files [x86]\mqattach\ 6.Unzip the update www.mqattach.com/updates/MQAWebV11434.zip and replace all files in c:\program files [x86]\mqattach\mqaweb\ 7. Backup your existing web.config - c:\program files[x86]\mqattach\mqaweb\web.config 8. Get the latest web.config from www.mqattach.com/updates/Web.config and replace the existing one 9. If you used impersonation in your old web.config apply it to the new web.config (look for impersonate) 10. restart MQALauncher and clear the windows event log MQAttach 11. Restart IIS 12. Navigate to http://localhost/MQAttach/Forms/frmLogin.aspx and ensure no errors Contact us if you have any problems - prodsupport@mqattach.com MQAttach v1.14.2.0 Date Released: 03 March 2012 ================================ 1a.The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) 1b. Send your db script to support@mqattach.com - in the management studio - right click the mqattach db, generate scripts all objects save and send to us, we will reply with a script catered for your environment 2. Stop the MQALauncher Service 3. Copy all files from the zip overwriting those in c:\program files (x86)\MQAttach 4. Clear MQAttach Event Logs 5. Restart MQALauncher 6. Restart IIS 7. Navigate to http://servername:serverport(default 80)/MQAttach/Forms/frmLogin.aspx MQAttach v1.14.1.0 Date Released: 15 December 2011 ================================ 1a.The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) If you have an older version that 1.14.0.0 then follow the upgrade instructions for 1.14.0.0 described If your version is 1.14.0.0: 1b. Update the Version Indicator in the Database by executing the following in versionupdate.sql script http://www.mqattach.com/updates/versionupdate.sql 2. Stop the MQALauncher Service 3. Copy all files from the zip overwriting those in c:\program files (x86)\MQAttach 4. Clear MQAttach Event Logs 5. Restart MQALauncher 6. Restart IIS 7. Navigate to http://servername:serverport(default 80)/MQAttach/Forms/frmLogin.aspx MQAttach v1.14.0.0 Date Released: 5 December 2011 ================================ 1a. The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) 1b. Obtain the Database Upgrade script from our website - for upgrading from 1.13.0.20 to 1.14.0.0 additonally the Database script http://www.mqattach.com/updates/dataupdate.sql needs to be run against the database to update the database If you are updating from an older or later release or are unsure of your version , please send us your database creation script - by going into SQL Management - Select your DB, Right click, Tasks - Generate Scripts - Script entire database - Save to file (Single File) and send us the file generated to support@mqattach.com, we will then respond with a script that will work for environment 2. Stop the MQALauncher Service 3. Web System Update Due to the fact that MQA is now moving to a web based interface - we require changes be made to your MQAWeb config files a) go to c:\program files (x86)\MQAttach\MQAWeb\ and rename web.config to webconfig.old b) now copy an updated web.config from http://www.mqattach.com/updates/web.config to c:\program files (x86)\MQAttach\MQAWeb\ c)Navigate to c:\program files (x86)\mqattach\mqaweb\bin d) delete any files containing the words 7.3 if any 4. Update MQALauncher Please update your launcher configuaration a) Go to c:\programdata\MQAttach\ [WINDOWS 2008, WINDOWS 7] Or C:\Documents and Settings\All Users\Application Data\MQAttach\ [windows 2003] and copy launcher.xml to launcher.old b) Edit launcher.xml add a new process as follows: after the last process tag c) Create a new queue MQA.ERROR on your MQ Environment hosting MQA Additionally due to speed improvements, we suggest the following - that agent status messages be separated from transaction log messages. To this end we suggest you do the following: c.1) Create a new queue in the MQ Environment called MQA.FTELOG.AGNT C.2) Re-Direct the FTE Agent Messages to the new MQA.FTELOG.AGNT queue - this can be done by redirecting subscriptions to the topic string Agents/# to the MQA.FTELOG.AGNT queue c.3) In launcher.xml add the following process d) Run the CMDFix to generate Encryption Keys for Existing Agents Please run c:\program files (x86)\MQAttach\MQACMD\MQACMDFIX -method=Version21Update 5. Clear MQAttach Event Logs 6. Restart MQALauncher 7. Restart IIS 8. Navigate to http://servername:serverport(default 80)/MQAttach/Forms/frmLogin.aspx MQAttach v1.13.0.20 Date Released: 16 March 2011 ================================ The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) Be sure to stop and start the MQALauncher service before performing the update and restart after complete additonally the Database script http://www.mqattach.com/updates/dataupdate.sql needs to be run against the database to update the database Restart MQALauncher Be sure to restart IIS after the server zip update MQAttach v1.13.0.19 Date Released: 06 February 2011 ================================ The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) Be sure to stop and start the MQALauncher service before performing the update and restart after complete additonally the Database script needs to be run against the database to update the database Existing Data Upgrade --------------------- Once the files and database has been upgrade, please complete the following from the server command line (please complete in sequence) C:\Program Files (x86)\MQAttach\MQACMDFIX –method=SLARuleXMLUpdate C:\Program Files (x86)\MQAttach\MQACMDFIX –method=SLADataUpdate1 C:\Program Files (x86)\MQAttach\MQACMDFIX –method=performanceUpdate This will update existing data Restart MQALauncher Be sure to restart IIS after the server zip update MQAttach v1.13.0.17 Date Released: 27 October 2010 ================================ The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) additonally the Database script needs to be run against the database to update the database Be sure to restart IIS after the server zip update Be sure to stop and start the MQALauncher service before performing the update and restart after complete To facilitate the changes the following needs to be done 1. Please create the queue MQA.PCF.REPLY on the main MQA Queue Manager 2. Please choose your default company 3. For the SLA Monitor place the following in your launcher config 4. For the agent restart it's the following 5. Change your ping process in the launcher to have a mode 6. Be sure to set you parameters - default company, default SLA, time parameters, email parameters MQAttach v1.13.0.14 Date Released: 31 August 2010 ============================== The update is in a zip format, that can be unziped overwriting the MQA server MQAttach directory (c:\Program Files [x86]\MQAttach\) additonally the Database script needs to be run against the database to update the database Be sure to restart IIS after the server zip update Be sure to stop and start the MQALauncher service before performing the update and restart after complete To faciliate the new changes, we have had to introduce a new process into the launcher, as the launcher will be responsible for performing the agent pings so on on your launcher config, you need to add the following process node Launcher config file can be found in c:\programdata\mqattach\launcher.xml (windows 2008) or c:\documents & settings\all users\application data\mqattach\launcher.xml (windows 2003) Be sure to stop the MQALauncher service before updating launcher.xml