HPE NonStop SQL/MX Error – 3226 SHOWLABEL failed for physical location name location-name. Object does not exist or object type is not supported. SHOWLABEL supports only SQL/MX tables, views, and indexes.

In this blog post, let’s learn about the error message “3226 SHOWLABEL failed for physical location name location-name. Object does not exist or object type is not supported. SHOWLABEL supports only SQL/MX tables, views, and indexes.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3226 SHOWLABEL failed for physical location name location-name. Object does not exist or object type is not supported. SHOWLABEL supports only SQL/MX tables, views, and indexes.

Reason for the Error

SHOWLABEL was given an invalid physical location as an argument.

Solution

Reissue the command with a valid location name