BMXAA6418E - There was an error reloading the MAXPROP cache

Technote (FAQ)


Question

BMXAA6418E - There was an error reloading the MAXPROP cache: The SELECT permission was denied on the object 'maxprop', database 'MAXIMO', schema 'dbo'.p

Cause

The above error message can be caused when a database is backed up and restored to another SQL Server with incorrect permissions.

Answer

When restoring from backup you need to ensure the proper privileges have been created and a dbo is assigned to the database. The following command should be run in your query tool to grant a user as the dbo for the restored database.


sp_changedbowner MAXIMO


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM SmartCloud Control Desk 7.5, 7.5.1
Systems and Asset Management Tivoli Service Request Manager 7.1, 7.1.2, 7.2, 7.2.1
Systems and Asset Management Tivoli Asset Management for IT 7.1, 7.1.1, 7.1.2, 7.2, 7.2.1, 7.2.2
Systems and Asset Management Tivoli Change and Configuration Management Database 7.1, 7.1.1, 7.1.2, 7.2, 7.2.1, 7.2.2

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management

Software version:

7.1, 7.1.1, 7.1.2, 7.2, 7.2.1, 7.5

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1637238

Modified date:

2013-05-22

Translate my page

Machine Translation

Content navigation