Sybase Error – Force_Drop of a Join Index is not allowed on a multiplex coordinator. %1

In this blog post, you’ll learn more about the Sybase Error Force_Drop of a Join Index is not allowed on a multiplex coordinator. %1 and the reason for receiving this error

Sybase SQL Error Message

Force_Drop of a Join Index is not allowed on a multiplex coordinator. %1

Reason for this Error

A join index cannot be dropped on a multiplex coordinator when the Force_Drop option is set to ‘ON’. If it is necessary to force drop a join index on a multiplex coordinator, the server will first need to be brought up in simplex mode.