Re: How can I run reports 6i in batch mode?

From: Alexander Bogomol <bogomol_at_investbank.ru>
Date: Sat, 21 Jul 2001 21:48:59 GMT
Message-ID: <9455EAF0C99FD111B85B0060B067688A04E9B416_at_E40>

Hi.
Look through your last message .You pointed that the report worked when you specifed a paramform=yes.
So there is a question. Does your report use additional parameters (user-defined)?
if it use, try specify them in command line. Hope it helps.

---

Alexander Bogomol
Patny ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ ...
>
>"Wibble" <nobody_at_Sun.COM> wrote in message
 news:3B1B8FE6.70E10343_at_Sun.COM...
>>
>> Patny wrote:
>> >
>> > Please help,
>> >
>> > We are trying to convert SQR reports to ORACLE Reports 6i, using report
>> > builder 6i in X-Windows environment. All our SQR scripts are overnight
 batch
>> > running, is that possible to run report 6i in
>> > batch mode ?
>> >
>> > If it's possible, please tell me what is the command to run them?
>> >
>> > Our environment is ORACLE 8i (v8.7), 9ias, UNIX Solaris, X-Windows.
>> >
>> > I already tried the following command in UNIX:
>> >
>> > rwrun60 module=<rep_name.rdf> userid=uname/psswd_at_conn destype=file
>> > desformat=html desname=<output.lis> batch=yes
>> >
>> > The error message was:
>> >
>> > ...
>> > REP-1800: formatter error.
>> >
>> > Thanks in advance.
>>
>> Hi
>>
>> This is the correct command. The error message implies some other error
>> internal to the report. Try running the report interactively first to
>> see if you get the same error.
>>
>> A couple of hints:
>> - if you convert the file to a ".rep" format using rwcon60 it runs
>> slightly faster (rwrun60 module=report.rep userid=...)
>> - always specify PARAMFORM=NO RUNDEBUG=NO for extra performance
>>
>> Good luck
>> JR
>
>Thanks for replying JR. I did try running interactively with a very simple
>report:
>
>rwrun60 module=<simple_rep_name.rdf> userid=uname/psswd_at_conn paramform=yes
>
>It works OK. I also tried different combinations but it's no hope.
>There maybe something with the report server configuration in 9ias ?
>
>Regards,
>Pat
>
Received on Sat Jul 21 2001 - 23:48:59 CEST