Spira 4.8.14.2 Release Notes

Contents
- What's New
- Features
- Bug Fixes
- Known Issues
- Installation Instructions
- Upgrade Instructions
Whats New
Features
Command
Mobile
Corporate Message Processor
Bug Fixes
Known Issues
Installation Instructions
Corporate
Download the latest installation packages from
http://releasenotes.spiradata.com
Command
Download the latest installation packages from
http://releasenotes.spiradata.com
Mobile
Download the latest installation packages from
http://releasenotes.spiradata.com
Upgrade Instructions
Requirements
You may upgrade to 4.8.14.2 from:
- 11.27_to_14.2
- 12.x_to_14.2
This section will outline upgrading a complete System with the following
components:
- Corporate (Application Server + SQL Server)
- Command
- Mobile
Corporate
Corporate server upgrade is manual and requires system knowledge. This
guide will instruct you to upgrade the default Corporate installation with all
default installation directories, paths, and databases.
| Installation Directory |
C:/Program Files\Spira Data Corp\Spira |
| Application Database |
Spira |
| Messaging Database |
SpiraMessaging |
You must use OPTION2 if you are running a multi-division configuration:
\Spira_Training + \Spira_Production.
Upgrading your corporate system involves patching:
- Application files at Message Processor Application level
- Databases at SQL server
Pre-Upgrade:
- At Corporate Application Server, stop both Spira services by running :
start > run > services.msc
- Spira Message Queueing
- Spira Message Processor
- At SQL server, backup your databases:
- Spira
- SpiraMessaging
Steps
- Download Corporate Upgrade Package,
14.2-Update-Corporate from
http://releasenotes.spiradata.com
- Extract 14.2-Update-Corporate to a temporary
location,
ie.
C:\SOURCE\14.2-Update-Corporate\
It will contain folders and files:
- \1_APP
- \2_SQL
- Spira-4.8.14.2-ReleaseNotes.htm
Patch Corporate Application Files:
- Copy
- Execute Corporate48142.exe
- FFollow on screen instructions
Patch Database(s)
- Connect to your MS SQL server using SQL Management Studio (or tool of
choice)/li>
- If you are upgrading
- from 11.x to 14.2, use the 11_to_14 folder
- Execute all MPatchXXX against your "SpiraMessaging> database
- MPatch004-SpiraMessagingV2Upgrade.sql
- MPatch005_SystemContextInQueues.sql
- Execute all PatchXXX against your Spira application database
- Patch_4811_to_4812.sql
- Patch_4811_to_4812_Pre_Patch.sql
- Patch_4812_to_4814.sql
- Patch_ProductVersion.sql
- from 12.x to 14.2, use the 12_to_14 folder
- Execute all MPatchXXX on "SpiraMessaging" database:
- MPatch005_SystemContextInQueues.sql
- Execute all PatchXXX on "Spira" application database:
- Patch_4812_to_4814.sql
- Patch_ProductVersion.sql
Restart Corporate Application Messaging services:
- Spira Message Processor
- Spira Message Queueing
Command
Pre-Requirements:
- Your Command is listed in the diagram as a supported FROM version/li>
- YYour Corporate Database has been upgraded to 4.8.14.2
Steps:
- Startup Command
- Application Database Chooser: Pick the database that corresponds to the
upgraded Corporate system
- Command checks the Corporate application databse
t_ProductVersion and compares to your Command's registry version
- Spira.Client.Updater will startup and begin
downloading the Spira Command Patch
- Click 'Retry' to begin the upgrade process
- Follow on screen instructions
- You are now upgraded to 4.8.14.2
- Restart Spira Command
- Login
Send Update for Mobile Units: This step should be completed once. It
will send your mobile units a directive to update.
- Startup Command
- Open Setup > Company
- click "Unlock URL"
- Copy/Paste in the Spira provided URL for mobile provided at
http://releasenotes.spiradata.com
ie.
http://files.spiradata.com/4.8.14.2/patch/14.2-Update-Mobile.zip
to the URL text box
- click "Verify URL" to ensure the link is valid
- click "Send Update"
- The URL is inserted into the Spira
Application database in, t_ApplicationUpdate
- You can use Express Manager to monitor which laptops have received
the updates in t_ApplicationUpdateAudit
Mobile
Pre-Requirements
- Corporate has been upgraded to 14.2
- Command "Send Update" has been performed
Steps:
- Start Spira Express Client
- Click "Connect Now"
You will be notified that your Application will restart when you restart
Spira Mobile Application
- Run Start > Program Files > Spira Data Corp > Spira
Mobile
- You will be notified to exit:
- Spira Mobile and
- Spira Express Client
- When the applications are exited, click "Retry" to being the upgrade
process
- Follow the onscreen instructions
- You are now upgraded to 4.8.14.2
- Restart Spira.Express.Client +
Spira Mobile
COMPLETE