Re: Reports Not Producing Output

[Praveen Gopu <Praveen.Gopu@AXACS.COM>]

Make sure that you have recompiled or relinked the SQR libraries. I have
see some strange problems at one of my client and after relinking libraries
then everything worked fine.


Praveen




"Hallmark, Robert J" <robert.j.hallmark@LMCO.COM>@list.iex.net> on
01/12/2001 10:48:31 AM

Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR, Brio Technology's database reporting
      language" <SQR-USERS@list.iex.net>


To:   SQR-USERS@list.iex.net
cc:

Subject:  Reports Not Producing Output


SQR Workbench 4.1.1
Oracle 8

For several months we have been experiencing an unusual problem which is
now
beginning to occur on a more frequent basis.
When we execute an SQR program it will frequently return all zeros when it
should be returning positive numbers, or if it is a text output it will
return no data at all.  We can re-run the report immediately and it will
pull often produce the proper output.  Sometimes it is necessary to re-run
the report again and again for up to an hour before it will pull the data.
This is happening on a wide variety of our reports.  We have checked with
our DBA and they are unable to see any reason for the problem.  Has anyone
out there ever run into this type of problem? Any ideas where we might
start
looking for the culprit?


Thanks


Bob H