Return
-
Title
MTP is deadlocked. Table "OWNER"."TABLE" has a bitmap index -
Description
MTP with status idle
sp_ctrl reads "error in cnc".
Post queue growing -
Cause
MTP is deadlocked on table with a bitmap index.
-
Resolution
Perform the following to resolve this issue.
1) Stop post
3) Convert Bitmap index to B-tree or optionally drop Bitmap index
4) Restart post