Disclosure Management – installing SPs & patches via command prompt

Introduction

This document outlines how to install Disclosure Management services packs and patches via a command prompt

Why using the command prompt

When you perform the initial installation of Disclosure Management (see Installing SAP Disclosure Management 10.1 ) the system will prompt for DB server, DB name, user + pwd

All this information is stored (encrypted) in a registry key. When you run a Service Pack (or patch), this information is re-used, so that the DB can automatically be updated via scripts, without any user prompts

However, this means that if any of these parameters changes (for example, you moved servers, the pwd changed etc.) the patch installation will fail. This is a typical error message you may get

Currently, the only option is to run the SP / patch installations via the commend prompt

Note: there is no way to update the registry key with the new information

Procedure

The installation of Service packs via command prompt is explained in this note:

Install SAP Disclosure Management with SQL server parameters

Here is an example of how to perform this

1. The current version is 10.1 SP05PL01

2. The DB is also at this level (verified with “SELECT * FROM [dsm].[Setup].[DMSetupSchemaVersion]” )

3. The server and DB used (i.e. where you moved the DB to)

4. Download the SP / patch and place it in a folder on the application server

5. Open the CMD prompt (with Admin rights)

6. Go to the folder where the SP has been downloaded to

As the note explains, the syntax is:

setup.exe /v”IS_SQLSERVER_DO_NOT_USE_REG=1 IS_SQLSERVER_SERVER=UsedServer IS_SQLSERVER_DATABASE=usedDB IS_SQLSERVER_AUTHENTICATION=1 IS_SQLSERVER_USERNAME=DBUser IS_SQLSERVER_PASSWORD=DBPwd“

Note: you can replace setup.exe with the actual SP executable name