RE: [sqr-users] Calling system command fails

["Bob Stone" <bstone@fastenal.com>]

Have you checked that the automated call knows what the D:\ drive is?  

If D:\ is a network drive, sometimes you need to put the full path in
instead.  (not that D:\ is usually a network drive...)


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Marina Piatibratov
Sent: Friday, June 06, 2008 10:39 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Calling system command fails

  Hello,

Just FYI:
I posted "(SQR 1303) Error in SQL (perhaps missing &name after 
expression)" error in March 08 and  it was resolved. It turned out that 
when users reinstalled Oracle in their test environment they didn't  
install Oracle Client properly (some settings were missing).

Now they're having another problem, again  in test  (in production the 
same sqr does work), namely, calling of MS_DOS command fails. They work 
in Windows-XP. The main sqr calls report (also sqr) using  Ms-dos and 
return status is not zero.
The piece of code:

CALL SYSTEM USING $sqr_line #status  WAIT
if (#status != 0)
   print 'Report run failed' (+1,1)
   print $sqr_line (+1,1)    
end-if;

In lis it prints out:

Report run failed
D:\Training\V13.2\RepServ\bin\sqr7w 
D:\Training\V13.2\RepServ\sqr\LPICKLST testdb/testdb@testsr -rt -s 
-eD:\Training\V13.2\RepServ\work\ok\PL393685.err 
-fD:\Training\V13.2\RepServ\work\ok\PL393685.lis 'LPICKLST' 'SA' '05 JUN

2008 12:25:22' EST

I asked the users to run this command directly from the Command Prompt 
and it ran without problems creating a report.

What can cause it?  Memory issue?... The command is long.


Thanks,
Marina


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users