HPE NonStop SQL/MX Error – 20403 The REORG operation on object-type object-name is already running.object-typeis the type of the affected SQL/MX table or index.object-nameis the ansi-name of the affected SQL/MX table or index.

In this blog post, let’s learn about the error message “20403 The REORG operation on object-type object-name is already running.object-typeis the type of the affected SQL/MX table or index.object-nameis the ansi-name of the affected SQL/MX table or index.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20403 The REORG operation on object-type object-name is already running.object-typeis the type of the affected SQL/MX table or index.object-nameis the ansi-name of the affected SQL/MX table or index.

Reason for the Error

You issued MODIFY REORG on an object on which a REORG command is already running.

Solution

Wait until the already started REORG command completes