Share this page

# Configure the Change Management Module

1. Add sysmodtime and orig.date.entered fields to the cm3r table.

   Note: If you are on Service Manager version 9.20 or later, these two fields may already exist in your system sample data. You can skip adding these two fields.

   1. Type `dbdict` in the Service Manager command line and press Enter.

      The Database Dictionary window opens.

   2. Type `cm3r` in the File Name field and click Search.

   3. Select cm3r in the File Name section.

      The `cm3r` dbdict displays.

   4. Click the Keys tab.

   5. Scroll down to the bottom of the form and place your cursor in the empty key.

   6. Click New Field/Key.

      The key.window page opens.

   7. Add a new key to the database table. The key should be of the type "Not Null" and should contain the sysmodtime field. If the Service Manager system uses another field to contain the last modified date/time of the record, use that field instead.

      1. In the key.window page, from the Type drop-down list, select no nulls.

      2. Type `sysmodtime` in the Fields textbox.

      3. Click Add Key.

   8. Add a new key to the database table. The key should be of the type "Not Nulls" and should contain the orig.date.entered field, for use in the initial load mode (for more information, see the initial-load-state adapter attribute in Configuring the Service Manager Adapter Attributes).

      1. In the key.window page, from the Type drop-down list, select no nulls.

      2. Type `orig.date.entered` in the Fields textbox.

      3. Click Add Key.

2. Make sure that the required fields are exposed through the Change Management Web Services:

   1. For Service Manager version 7.01, select Menu Navigation > Tailoring > WSDL Configuration.

      For Service Manager version 7.10, version 9.20 or later, select Menu Navigation > Tailoring > Web Services > WSDL Configuration.

      For Service Manager version 9.40 or later, select Menu Navigation > Tailoring > Web Services > Web Service Configuration.

   2. Type `Change` in the Service Name field and click Search.

      For OpenText PPM version 9.10 or 9.11, select Change in the Object Name section.

      For OpenText PPM version 9.12 or later, select ChangePPMIntALM in the Object Name section.

   3. Click the Fields tab and add fields with captions and types to the table as follows:

      New Field | New Caption | Type
      --- | --- | ---
      sysmodtime | sysmodtime | DateTimeType
      header,orig.date.entered | origDateEntered | DateTimeType

   4. For Service Manager version 9.20 or later, change existing WSDL captions as follows:

      Field | Original Caption | New Caption
      --- | --- | ---
      header,number | ChangeID | changeNumber
      header,brief.description | Title | briefDescription

3. Import the unload file provided with OpenText PPM to set up the Change Management Web service for the integration with OpenText PPM.

   1. Type `db` in the Service Manager command line and press Enter.

      The Database Manager window opens.

   2. Select More > Import/Load.

      The Service Manager File Load/Import screen opens.

   3. For the File Name field, browse to select the file to load.

      - For integration with OpenText PPM version 9.10 and 9.11, the load file is located at:

            <PPM_Home>\conf\sdi\serviceManagerFiles\sm_operations

      - For integration with OpenText PPM version 9.12 or later, the load file is located at:

            <PPM_Home>\conf\sdi\serviceManagerFiles\PPMIntALMWebService.unl

        Where `<PPM_Home>` represents the path where the OpenText PPM instance is installed. For example: `xyzserver/E/PPMServer`.

   4. Click Load FG.

      A message stating that the unload file is loaded displays.

   5. Click Back.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: