In this blog post, let’s learn about the error message “20020 An internal error occurred. The number of columns (num1) defined for the referenced table table1 does not match the number of columns (num2) defined on the referencing table table2 for constraint const.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20020 An internal error occurred. The number of columns (num1) defined for the referenced table table1 does not match the number of columns (num2) defined on the referencing table table2 for constraint const.
Reason for the Error
NonStop SQL/MX found a discrepancy while reading metadata information. The information returned is inconsistent.
Solution
None. This is an internal error. Contact your service provider
