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

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

book

Article ID: 191083

calendar_today

Updated On:

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