Page 1 of 1
Posted: Tue Oct 16, 2007 9:24 am
by 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.
IBM Case 704033 has been opened
Posted: Tue Oct 16, 2007 9:32 am
by 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.
IIS 8.0.1 Case 704033 Resolved
Posted: Tue Oct 16, 2007 11:28 am
by 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
IIS 8.0.1 Miscellaneous dsjob commands
Posted: Thu Oct 18, 2007 11:28 am
by 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
Posted: Thu Oct 18, 2007 3:04 pm
by 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.
IIS 8.0.1 dsjob file requires password
Posted: Wed Oct 24, 2007 11:12 am
by 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.