In this blog post, let’s learn about the error message “1004 Object object-name does not exist or object type is invalid for the current operation.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1004 Object object-name does not exist or object type is invalid for the current operation.
Reason for the Error
You attempted an operation on an object that does not exist or attempted an operation on an object with the wrong type. For example, you tried to drop a view but specified a table name.
Solution
Check that an object object-name exists. If you did not fully qualify the name, check that the defaults generate the correct fully qualified name and resubmit