In this blog post, let’s learn about the error message “13074 One or more of the three parts of the externally qualified module name module-name is longer than 128 characters.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
13074 One or more of the three parts of the externally qualified module name module-name is longer than 128 characters.
Reason for the Error
An externally qualified module name consists of three parts: a catalog, a schema, and a one-part module name that has been qualified with Module Group Specification String (MGSS), Module TableSet Specification String (MTSS), or Module Version Specification String (MVSS). If module name is longer than 128 characters (because of adding MGSS, MTSS, or MVSS) or if the catalog or schema is longer than 128 characters, this error message is generated.
Solution
Reinvoke the preprocessor, this time supplying a shorter value for any or all the MGSS, MTSS, MVSS, or for the one-part module name coded in the embedded SQL source file’s MODULE directive
