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
