HPE NonStop SQL/MX Error – 20193 This operation cannot be performed under a user-defined transaction.

In this blog post, let’s learn about the error message “20193 This operation cannot be performed under a user-defined transaction.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20193 This operation cannot be performed under a user-defined transaction.

Reason for the Error

You cannot perform a POPULATE INDEX operation under a user-defined transaction.

Solution

Commit or roll back the user-defined transaction and resubmit