function EXEC() returns 0403-006 Execute permission denied.

dataservices job design
1

When I call any Unix command via the Business Objects Data Services function EXEC() I get “0403-006 Execute permission denied.”.

When I execute the same command at the Unix prompt it works correctly

bryantm :australia: (BOB member since 2010-06-21)

2

With the same user the al_jobservice process is running under?
Using the exec(’/bin/ksh’, ‘xxxx’, 8 ) syntax?

Werner Daehn :de: (BOB member since 2004-12-17)

3

thanks, I have now solved the problem,

previously I had:

print(exec(‘ksh’, ‘whoami’, 8));

which returned:

1: ksh: whoami: 0403-006 Execute permission denied.

now I have:

print(exec(‘whoami’, ‘’, 8));

returning:

0: d02adm

so the unix command is now executing correctly in BO

bryantm :australia: (BOB member since 2010-06-21)