Re: [staf-users] Batch script terminates halfway under STAF.

[<san...@rs...>]

Comments inline.

Many thanks, 
Saneesh Joseph. 

________________________________

From: Sharon Lucas [mailto:lu...@us...] 
Sent: Wednesday, May 13, 2009 8:15 PM
To: Joseph, Saneesh
Cc: sta...@li...
Subject: Re: [staf-users] Batch script terminates halfway under STAF.

 


A PROCESS START request provides a STDIN option to specify a standard
input file to a command.  Try the following: 

1) STAF local PROCESS START COMMAND "C:/script/createtables.bat" WORKDIR
"C:/script" WAIT RETURNSTDOUT STDERRTOSTDOUT STDIN "password.txt" 

Does that work?  If not what is the output? If it doesn't work try: 

[Joseph, Saneesh] That works. But I cant adopt this approach in my test
environment as createtables.bat is also being run manually, not only
under STAF. Moreover, the same script has command lines taking input
from different files, not only password.txt. 

2) Create a empty file, e.g. C:/script/empty.txt, and do: 

  STAF local PROCESS START COMMAND "C:/script/createtables.bat" WORKDIR
"C:/script" WAIT RETURNSTDOUT STDERRTOSTDOUT STDIN "empty.txt" 

If that doesn't work, try removing the < password.txt  from your bat
file and then try the PROCESS START request in 1). 

[Joseph, Saneesh] That works too, but cannot be adopted. 

--------------------------------------------------------------
Sharon Lucas
IBM Austin,   lu...@us...
(512) 286-7313 or Tieline 363-7313




<san...@rs...> 

05/13/2009 08:14 AM 

To

<sta...@li...> 

cc

David Bender/Austin/IBM@IBMUS 

Subject

Re: [staf-users] Batch script terminates halfway under STAF.

 

 

 




I found out the issue is because of the input redirection from
password.txt. The less than symbol ( < ) causes the issue. But didn't
get a solution yet... :-( 
  

Many thanks, 
Saneesh Joseph. 

 

________________________________


From: Joseph, Saneesh 
Sent: Wednesday, May 13, 2009 6:30 PM
To: 'sta...@li...'
Cc: 'bd...@us...'
Subject: Batch script terminates halfway under STAF. 
  
Folks, 
  
I have a windows batch file which is running properly when I run it. But
when I run it using STAF, it doesn't complete its execution 
  
  
Createtable.bat 
======= 
@echo off 
echo create table mytable(id integer)>myscript.sql 
echo CREATING TABLES 
psql -h localhost -p 5432 -U postgres -d postgres -f myscript.sql <
password.txt 
echo DONE! 
========= 
  
When I run it manually (using command prompt), it shows 
  
C:\script>createtables.bat 
CREATING TABLES 
Password: 
CREATE TABLE 
DONE! 
  
When I run it using STAF, 
  
C:\script>staf local process start command "c:\script\createtables.bat"
WORKDIR "c:\script" wait returnstdout stderrtostdout 
Response 
-------- 
{ 
  Return Code: 255 
  Key        : <None> 
  Files      : [ 
    { 
      Return Code: 0 
      Data       : CREATING TABLES 
Password: 
CREATE TABLE 
More? 
    } 
  ] 
} 

Precisely, it executes psql command and then exits. After that it shows
"More?" in the response!!!. I have no idea what is happening... :-(
Please help me out.. 

Many thanks, 
Saneesh Joseph. 
 
------------------------------------------------------------------------
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks
to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled.
http://p.sf.net/sfu/kodak-com___________________________________________
____
staf-users mailing list
sta...@li...
https://lists.sourceforge.net/lists/listinfo/staf-users