HPE NonStop SQL/MX Error – 2009 The user transaction must be rolled back (or committed, if that makes sense in the application) before MXCMP can be restarted and proceed.

In this blog post, let’s learn about the error message “2009 The user transaction must be rolled back (or committed, if that makes sense in the application) before MXCMP can be restarted and proceed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

2009 The user transaction must be rolled back (or committed, if that makes sense in the application) before MXCMP can be restarted and proceed.

Reason for the Error

An outstanding transaction must be resolved before the MX compiler (MXCMP) can be restarted.

Solution

None