In this blog post, let’s learn about the error message “11205 Java class class-file-name was not found in external path path-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11205 Java class class-file-name was not found in external path path-name.
Reason for the Error
The class file did not exist in the given directory.
Solution
Determine if the class file exists in the directory. If the SQL/MX statement is a CALL statement, determine if the class file was moved from the directory that was specified when the procedure was created. If the class file has been moved, either restore it to the original location, or drop the procedure and recreate it with the new location of the class file