In this blog post, let’s learn about the error message “QL 1100411004 Database object cannot be created on tables with names longer than 122 characters.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
QL 1100411004 Database object cannot be created on tables with names longer than 122 characters.
Reason for the Error
You attempted to create a trigger or materialized view on a subject table with name length exceeding 122 characters. The maximum length of a user table is 128 characters. However, triggers and materialized view require an internal temporary table whose name is derived from the subject table name, which is an additional six characters.
Solution
Drop and recreate the subject table with a name less than or equal to 122 characters, and then create the trigger or materialized view