IIS 8.0.1 etlrun using dsjob 'Failed to open project’

[ray.wurlod]

Looks like the shared library search path (LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH) is incomplete for the executing user. This might be because the script (or its executing user) failed to run the dsenv script.

[cundyp]

I'm working with the IBM engineer and trying different options:
Nothing is working yet.

$ cd /IBM/InformationServer/Server/DSEngine
$ . ./dsenv
$ cd bin
$ ./dsjob -run -wait -mode NORMAL -warn 0 -domain antares:9080 -server AURIGA:31801 -user dsadm -password ***** HMKSandboxv801 E1XA570

send me the resulting error, then try:

$./dsjob -domain antares:9080 -server AURIGA:31801 -user dsadm -password ***** -lprojects

and send me the result.

[cundyp]

Step 1: We first successfully listed the projects on our server.
This required setting up a /tmp/serv.txt file.
$ cd /IBM/InformationServer/Server/DSEngine
$ . ./dsenv
$ cd bin
$ ./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -lprojects

Where the /tmp/serv.txt file contains:
ANTARES:9080,AURIGA:31801,dsadm,***pwd**
~
"serv.txt" [Read only] 1 line, 43 characters

Step 2: We then successfully executed a job then a sequence using dsjob.
Note: This required setting up a /tmp/serv.txt file (done in step 1).
$ cd /IBM/InformationServer/Server/DSEngine
$ . ./dsenv
$ cd bin
$ ./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -run -wait -mode NORMAL -warn 0 HMKSandboxv801 rpcE1XA570

./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -run -wait -mode NORMAL -warn 0 HMKSandboxv801 rpcE1XA570_EtlrunTest

[cundyp]

Similar to the other case we worked on, you always need to provide the first part: IBM Case 704277
./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801

And then add on the actual command like -lognewest HMKSandboxv801 rpcE1XA570

So the command for -lognewest would be:
./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -lognewest HMKSandboxv801 rpcE1XA570

For -logdetail:
./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -logdetail HMKSandboxv801 rpcE1XA570

For -logsum:
./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -logsum HMKSandboxv801 rpcE1XA570

For -jobinfo:
./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -jobinfo HMKSandboxv801 rpcE1XA570

For -run:
./dsjob -file /tmp/serv.txt ANTARES:9080 AURIGA:31801 -run -wait -mode NORMAL -warn 0 HMKSandboxv801 rpcE1XA570

[lstsaur]

Pete,
Followed every step of your notes, I still get the same error "Failed to open project". I guess that IBM's solution works only in your environment.
Did IBM tell you why the password must be provided in the .txt file? In my shop that's absolutely disallowed to do thing like that.

[cundyp]

Question: Followed every step of your notes, I still get the same error "Failed to open project". I guess that IBM's solution works only in your environment.
Answer: When i implemented the IIS 8.0.1 dsjob commands in the etlrun script it required testing out each command to arrive at the correct syntax.
Also, make sure you execute the . ./dsenv command. I could post the etlrun script if that would help.

Question: Did IBM tell you why the password must be provided in the .txt file? In my shop that's absolutely disallowed to do thing like that.
Answer: IBM specifically stated that the password was required in the file. They could not provide a means of encrypting the password.
Resolution: We are working with our mid-range group to come up with an encryption method.