Re: [sqr-users] Calling system command fails

["Don Mellen" <donm@ontko.com>]

Have you checked if it makes an err file?  If so, what's in it?

Have you checked the value of #status?  The OS error number could also help
in pointing out the problem.

On Fri, Jun 6, 2008 at 12:11 PM, Marina Piatibratov <marinal@rogers.com>
wrote:

> It's a local drive on the server.
> ---
>
>
> Bob Stone wrote:
>
> 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 <sqr-users-bounces%2Bbstone>=
>> 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
>>
>>
>>
>
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>



-- 
-----------------------------------------------------------------------
Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com | "In the beginning, there was nothing, which exploded"
(Terry Pratchett)

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