Troubleshooting
Problem
You extracted User Define Function (UDF) definitions from source server and trying to recreate the same on a target server. However, create function operation is failing with error. For example: ***** Creating function: "ADD_ELEMENT" nzsql:My_function.sql:10: ERROR: Unable to open udx source file for reading /tmp/nz_udx_object_files/9999219.oh
Cause
The object file(s) associated with the UDF are inaccessible. Check the directory and files mentioned in the error message are exist and have appropriate read/write permissions.
If you are using the 'nz_ddl_function' script for extract UDF definitions, copy all the object files under /tmp/nz_udx_object_files directory from source server to target server. Make sure directory and file permissions are same on both source and target servers. Then try to create the same function on the target server.
Important : Above are some possible cause of the problem. If this document does not give you what you need then search for other documents with the same problem.
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21681638