Steps to repoint a Business Objects Universe to a new reporting database (for Software Compliance Manager or Asset Portfolio Management 12.x installations)

book

Article ID: 49610

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA Compliance Manager for z/OS CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Solution:

  1. Log onto the Business Objects server. Launch the Business Objects designer from the start menu

  2. Login as Administrator and the main design window launches

  3. From the File menu, select Import to import an existing universe

  4. Click Browse to locate the CA Allegheny universe and click OK

  5. Click OK on the next screen to import the universe. You'll see a message that the universe imported successfully

  6. From the File menu, choose Parameters

  7. Click EDIT to edit the 'Allegheny' connection

  8. Change the server name and the port number to point to a new MDB server name

    For example: tcp:<MyDBServerName>,1433 (NOTE: 1433 is the port number for a sql server default instance)
    If using a named instance, use this syntax: tcp:<NamedInstance>\<MyDBServerName>,1433

  9. Click Text Connection to verify the database connectivity

  10. Click next a few times to go through all the screens (keeping defaults), then click finish.

  11. Click OK, to return to the main Universe window

  12. Close the Business Objects designer universe and save the changes on exit.

  13. Restart the Server Intelligence Agent service

On the SWCM web server machine

  1. Edit the SWCM\Web Server\web.config file

  2. Change the following keys to point to the new Business Objects machine

    <add key="ReportingWebServiceServer" value="<Your BO Server Name>:<port#>" />

    Note: Launch Business Objects Java Infoview on the Business Objects server to obtain the correct port number.

    <add key="ReportingUser" value="Administrator" />
    <add key="ReportingPassword" value="P6pGPgJ2286apvbop44mNw==" />
    <add key="ReportingWebServerVersion" value="3.0" />

    Restart IIS on both the SWCM web and application servers.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: