Focal Point
Report Killed

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8811059752

November 19, 2007, 03:26 AM
<Navin>
Report Killed
Hi .

I have a problem using REportCaster. When i ran a report from RC , the report is not getting distributed.
When i see the log, i get the following messages ,

*******************************************

...REPORT KILLED
THE REPORT IS NO LONGER AVAILABLE
...REPORT KILLED
THE REPORT IS NO LONGER AVAILABLE
Task error: THE REPORT IS NO LONGER AVAILABLE
No report to distribute.

********************************************

Any Reason why??.

I have many jobs running, the only difference is that the query for this report is heavy that it will generate huge temp files. But we have already allocated more space .
November 19, 2007, 10:35 AM
Francis Mariani
Perhaps (but I cannot say for sure) it has something to do with IBIF_max_messages.

See this FocalPoint posting:

How to increase IBIF_max_messages?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 20, 2007, 04:10 AM
<Navin>
hi Francis ,

i chked with the configuration file and , as u said that was set to 20000 . I reverted to 0.
I restarted the server .

But again i am facing the same issue .

Note: I am giving the request via the ReportCaster. The same query runs fine in the online reporting.But it fails in the Reportcaster.

Plz give some solutions.

Thanks in Advance.
November 20, 2007, 06:25 AM
<Navin>
also plz let me know , where to change the config file.
in Server side or the client side .
November 24, 2007, 02:33 PM
FortuneCookie
You might want to review the following best practices guide: Considerations When Using ReportCaster Version 7 Release 1

http://documentation.informationbuilders.com/masterinde...siderations71_rc.pdf

With reports that are loaded with code, sometimes it's easier to split up the code.
Pre-Execution: Code that is used to generate the HOLD files and etc...
Main Procedure: The actual cosmetic part


Prod: WebFOCUS 7.1.6, Windows 2003

Dev: WebFOCUS 7.6.2, Windows 2003