Updating SME

From High5Wiki
Jump to navigation Jump to search

Updating SME: 7.1 - Prelive Update Note: Updating SME requires ‘Exclusive Access’. To make sure you have Exclusive Access review the notes at the end of the document..

  • Log all users out of SME.
  • Close SQLink.
  • Log on to your server or computer hosting the SME database.
  • Browse to the SME Application folder.

The usual installation is for the application and database to reside on the same machine. - C:\Users\Public\High5software\Data\<your company data folder> If the Application and database reside on the different computers you must log on to the machine hosting the database and browse to the server/computer hosting the application. - \\Server\Users\Public\High5software\sme5.exe

  • From your Windows Start bar do Start> Run> fsmgmt.msc to check open files

All SME related files must be closed. A good check to make sure SME is not locked is to attempt to rename the sme5.exe to sme5.old.exe. If you cannot rename the file then SME is locked and the update will fail. Rename back to sme5.exe if you can rename it.

  • Open SME and login as Admin
  • Go to Help> Tech Support Utilities

TechSupportUtilitiesSm.jpg

  • Support Utilities Code window opens

SupportUtilities.png

  • Enter code 298

SupportUtilities298.png

  • Enter the Authorization Code. (in the example it is ‘some’)

EnterAuthorizationCode.png

  • SME will search for the update and download the What’s New file.

WhatsNew CheckingForUpdates.png

  • The current version will be listed. Click Ok.

WhatsNew.png

  • You will be asked to download the update files. Answer Yes.

Confirm(1).png

  • SME will display the progress bar for downloading the updates.

ProgressBar.jpg

  • The following files comprise the update set and are downloaded into the C:\\Users\Public\High5Software\Data\<your company data folder>\Updates:

CompressedFiles.jpg

  • When all required files have been downloaded you will see the following prompt. Answer Yes.

UpdatesDownloaded.jpg

  • SME will close and install the new executable and routines dll files. When SME reloads you will receive the following prompt. Note: This prompt will only come up if there are changes to the routines or database restructuring. Answer Yes.

ExitSME.png

  • You will receive the following prompt. Answer Yes.

BackupWarning.png

  • SME will back up the database and begin updating.

SettingDatabaseOptions.png

  • Enter the password: verify630
  • When the update has completed SME will reopen.

LoadingSMEVersion.png

Updating SQLink:

Go to a computer that is configured to run SQLink. It is not required to be a server.

  • Open SQLink
  • Help> Tech Support Utilities
  • Support Utilities Code window opens

SupportUtilities.png

  • Enter code 298

SupportUtilities298.png

  • Enter the Authorization Code. (in the example it is ‘some’)

EnterAuthorizationCode.png

  • SME will search for the update and download the What’s New file.

WhatsNewSQLInk.png

  • The current version will be listed. Click Ok

SQLInkCurrentVersion.png

  • You will be asked to download the update files.

Confirm(1).png

  • Click Yes
  • The update will download

DownloadingSQLinkUpdate.png

  • You will be prompted to Close SQLink to apply the update

ConfirmUpdatesHaveBeenDownloaded.png

  • Click Yes
  • The update will be applied when SQLink reopens


Notes:

The following information pertains to obtaining Exclusive access to the SME database. These steps are for advanced users. If you are not familiar with MS SQL Management Studio contact High5 Software and we will assist with the update.
- The easiest method is to attempt to rename the SME executable sme5.exe to sme5.old.exe if you cannot rename someone is still in SME.
- Alternate method is to run the following query in MS SQL Management Studio
- Open Management Studio
- New Query
- Paste the following into management Studio

USE master;

GO
ALTER DATABASE [dbname]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE [dbname]
SET MULTI_USER;
GO


- Type your database name between the brackets [mydatabase]
- Click the Execute query button
- Close Management Studio
- Proceed with the update