ExecSH File not found (not permissions)

Triton46 · Post by **Triton46** » Fri Sep 30, 2005 9:30 am

Hi all. :D

We are migrating jobs over to a new 7.5 server. So far, everything works except our before and after scripts.

The only thing I notice that is different between our 5.2.2 server (where these worked) and this one is that you have to put ./ before you can run anything. So, to run this from the command line on the 5.2.2 server you type drop_indexes.txt and on 7.5 you have to type ./drop_indexes.txt.

Running from the command line works. I tried putting ./ in the Job Properties Input Value but it didn't work. I also set the drop_indexes.txt file to chmod 777. Help!

PROTDdwFactLoader..BeforeJob (ExecSH): Error when executing command: /datastage/Projects/DRDWSrProtDev/ds_scripts/drop_indexes.txt
*** Output from command was: ***
SH: /datastage/Projects/DRDWSrProtDev/ds_scripts/drop_indexes.txt: not found

kcbland · Post by **kcbland** » Fri Sep 30, 2005 9:46 am

To execute anything within your directory you need to make sure your PATH has "./" in it. Setup your user profile.

Make sure that the permissions to this script include read/execute access to your ds_scripts directory.

ray.wurlod · Post by **ray.wurlod** » Sat Oct 01, 2005 12:46 am

Check that the executing user has at least read and execute permission to every directory in the file's pathname.