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

Document ID : KB000021963
Last Modified Date : 14/02/2018
Show Technical Document Details

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.