Page 1 of 1

Problem while executing a job

Posted: Sat Apr 02, 2005 10:02 pm
by pravesh_kushwaha
Hi,
We had exported one of our running job from one project p1 to project p2 on the same datastage server. Now while running the job in project p2 we are getting the following error:

Transformer_LA_CUSTOMER_Reject_Records: Failed to load the library "V0S2_CTCTReject0005AirCustomer_Transformer_LA_CUSTOMER_Reject_Records.sl". Either the directory containing the library file is not on the library search path, or the library was compiled on a system that is incompatible with this system. Could not load "V0S2_CTCTReject0005AirCustomer_Transformer_LA_CUSTOMER_Reject_Records": Permission denied.

If we do a force compile of the job then we are able to execute the job.

Can anyone please tell us why this error is occuring and the possible solution for the same.

Posted: Sun Apr 03, 2005 12:47 am
by ray.wurlod
Check that the library search path (SHLIB_PATH, LIBPATH or LD_LIBRARY_PATH, depending on your Unix) is correctly specified in the dsenv script in the DataStage Engine directory. This script defines environment variables for all DataStage processes, including agent processes of connected clients.

Posted: Sun Apr 03, 2005 7:41 pm
by T42
I suspect that the path you have for that library is different on both projects. If you migrate to different projects that points to different libraries, a force-compile is necessary, even if you migrate the executables.

A better solution would depend on your setup.