When running Upgrade in Wise Repository Database, actions do not complete for SW manager when using Terminal Service.

Article:TECH37395  |  Created: 2005-11-18  |  Updated: 2009-05-14  |  Article URL http://www.symantec.com/docs/TECH37395
Article Type
Technical Solution

Product(s)

Issue



During the Database Setup in the Wise Repository Manager, the different setups remain at pending after clicking Run, Run All, or Upgrade. How do I force the install?


Solution



Are Terminal Services being used to install/upgrade WPS?  If so, this may be what is causing the actions not to complete.  Currently, Symantec does not support the use of Terminal Services to install Wise Package Studio, but some customers have been successful getting their upgrade to complete by following the steps below.

Two issues that cause the upgrade not to complete are that the service used to upgrade the databases may not start through Terminal Services, and Terminal Service does not refresh as it is running through the upgrade.

Follow these steps to upgrade WPS using Terminal Services:

1. Access the Wise Repository Manager through the Wise shortcut.
2. Select the Upgrade icon at the top of the Wise Repository Manager window.  This starts the service and the upgrade process.
3. Allow the upgrade some time to process the upgrade. 
4. To check on the upgrade process, first close then reopen the Wise Repository Manager.

If the Terminal Services is not part of the process, proceed with the following solution.



In the Wise Repository Manager:

Workbench Database and Software Manager

  1. Click on Upgrade to Baseline and copy the script found under the Details section on the right side of screen.
  2. Launch SQL Query Analyzer.
  3. If not already connected, you may be prompted for server. Select the server of the database.
  4. Then paste the SQL script in the white space and select the appropriate database from the drop-down list right above the white space.
  5. Click the green arrow to run.

In some parts of the Software Manager Database, there is no SQL Script available. You will need to run a command line to force the installation:

Upgrade Module Signature
"C:\Program Files\Altiris\Wise Package Studio\Windows Installer Editor\msiimporter.exe" /upgrademodulesignatures /connect=Data Source=<SQLSERVERNAME>;Database=Software Manager Database;Trusted_Connection=Yes

Upgrade File Languages
"C:\Program Files\Altiris\Wise Package Studio\Windows Installer Editor\msiimporter.exe"  /upgradefilelanguages /connect=Data Source=<SQLSERVERNAME>;Database=Software Manager Database;Trusted_Connection=Yes

Upgrade Format Strings
"C:\Program Files\Altiris\Wise Package Studio\Windows Installer Editor\msiimporter.exe"  /upgradeformattedstrings  /connect=Data Source=<SQLSERVERNAME>;Database=Software Manager Database;Trusted_Connection=Yes

Upgrade File Hashes
"C:\Program Files\Altiris\Wise Package Studio\Windows Installer Editor\msiimporter.exe"  /upgradefilehash /connect=Data Source=<SQLSERVERNAME>;Database=Software Manager Database;Trusted_Connection=Yes

Upgrade File Times
"C:\Program Files\Altiris\Wise Package Studio\Windows Installer Editor\msiimporter.exe" /upgradefiletimes /connect=Data Source=<SQLSERVERNAME>;Database=Software Manager Database;Trusted_Connection=Yes

Please do not include the <> around the server name in the command line. This should complete the installation on the customer's machine.


Legacy ID



3940


Article URL http://www.symantec.com/docs/TECH37395


Terms of use for this information are found in Legal Notices