In this blog post, let’s learn about the error message “2205 A temporary filename could not be created.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2205 A temporary filename could not be created.
Reason for the Error
You invoked mxCompileUserModule on an application file that has many embedded module definitions. The tool cannot create another temporary file name to hold the contents of an embedded module definition. The tool used tmpnam() to create a string that is not the name of an existing file which tmpnam() could not do.
Solution
Clean up TMPDIR (the directory where temporary files are created) by deleting unused temporary files. Retry the command
