I'm receiving an error when applying the Unicenter Asset Portfolio Managemen cumulative 11 patch: can not locate dbo.compare_timestamp

Products

• 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

Issue:

Applying a Unicenter Asset Portfolio Management cumulative patch may encounter errors when running the patchmdb command.

The patch cannot locate either the dbo.compare_timestamp or dbo.update_mdb_sit functions.

Environment:

Unicenter Asset Portfolio Management 11.3.4, any patch level

Cause: 

If the patchmdb command was executed with the uapmadmin user (or another user), then the compare_timestamp and update_mdb_sit stored procedures will be prefixed with the schema owner 'uapmadmin' (or another user), and NOT dbo.

Solution:

Perform the steps below to resolve the error:

1. Launch SQL server management studio and login as the 'sa' user, or with a user with authority to 'alter schema'.
   
   
2. Expand the database MDB, expand Programmability, then expand stored procedures.
   
   
3.  Locate the <schemaOwner>.compare_timestamp and <schemaOwner>.update_mdb_sit procedures.
   
   
4. Run the following 2 queries to change the schema owner to 'dbo'.  Replace schemaOwner with the name from your installation: 
   
   
   • alter schema dbo transfer schemaOwner.compare_timestamp
   • alter schema dbo transfer schemaOwner.update_mdb_sit
     
     
5. Re-run the patchmdb command.

Environment

Release:
Component: ARGIS