In this blog post, let’s learn about the error message “1192 SQL/MP system catalog catalog-location could not be found -FILE_GETINFOBYNAME_ error error-number.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1192 SQL/MP system catalog catalog-location could not be found -FILE_GETINFOBYNAME_ error error-number.
Reason for the Error
Unable to find SQL/MP system catalog table $vol.sql.catalogs.
Solution
Check that the SQL/MP system catalog table $vol.sql.catalogs exists. If it does, contact your service provider