You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

When system administrators perform upgrade, schema change or any type of activities that need to alter the mdb schedma, you may encounter this error
You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels

This tech doc provides a resolution.

Environment

Release : 17.x

Component : SERVICE DESK MANAGER

Resolution

DBA would need to disable database replication on the mdb database before such activities can be performed. After the activities done. DBA can enable database replication again.

Additional Information

An example of disable agent for pdm_publish can be found here
https://community.broadcom.com/enterprisesoftware/communities/community-home/librarydocuments/viewdocument?DocumentKey=6c81e3a2-b277-46a3-88cd-48ea978151c5&CommunityKey=e2cd3188-49bc-4f38-88f1-74260f56fa66&tab=librarydocuments