HPE NonStop SQL/MX Error – 20018 An internal error occurred. There is an inconsistency between the data type (type) and default state (default) for column (name).

In this blog post, let’s learn about the error message “20018 An internal error occurred. There is an inconsistency between the data type (type) and default state (default) for column (name).” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20018 An internal error occurred. There is an inconsistency between the data type (type) and default state (default) for column (name).

Reason for the Error

NonStop SQL/MX found a discrepancy while reading metadata information. The information returned is inconsistent. This is an internal error.

Solution

None. Contact your service provider