IIS 8.0.1 etlrun using dsjob 'Failed to open project’
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
IBM Case 704033 has been opened
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.
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.
Pete Cundy
Leawood, Kansas
Leawood, Kansas
IIS 8.0.1 Case 704033 Resolved
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
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
Pete Cundy
Leawood, Kansas
Leawood, Kansas
IIS 8.0.1 Miscellaneous dsjob commands
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
./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
Pete Cundy
Leawood, Kansas
Leawood, Kansas
IIS 8.0.1 dsjob file requires password
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.
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.
Pete Cundy
Leawood, Kansas
Leawood, Kansas