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

   I've seen the formatter error occur because you don't have the environment variables PRINTER and/or ORACLE_PRINTER set (I think you only need one or the other, but I'm not positive).

Later,
Bob Wall

Patny wrote:
>
> "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 [Quoted] [Quoted]
> > 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 Mon Jul 09 2001 - 22:38:21 CEST