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

Article Id: 49610
Status: Published
Updated On: 14-02-2018 08:04
Legacy Id: TEC566166
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: