Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Report Caster Problem

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Report Caster Problem
 Login/Join
 
Adam_Sentz
Member
posted
Our legacy WF (7.6.1) sends out a bunch of caster reports on the weekend. Yesterday, we found that with a few reports that the server was sending out emails on an infinite loop. These procedures have been running for 2-3 years and have never seen anything like this happen. Nothing was changed on the server.

1) Our email server has been troubleshooted and it seems that this is not the problem.

2) The report caster is taking up all of the agents.

3) We currently shut down the production report caster server. this really isn't affecting the day to day operations as our caster reports run at night.

Is there anyone that would have any idea on why this would happen?

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows, All Outputs
 
Posts: 18 | Registered: November 13, 2015Report This Post
Squatch
Master
posted Hide Post
I would start by seeing if the reports causing the problem have something in common. Do they get their data from some of the same database tables? If the reports haven't changed, and Report Caster hasn't changed, and there is nothing wrong with the e-mail server, then could something have happened with the structure of the database tables? Maybe table linking has changed in a way that is generating many duplicate records, giving the appearance of an infinite loop?


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Adam_Sentz
Member
posted Hide Post
We figured it out.

The legacy SQL database was sharing resources with another application. The other application blew up and the logging went out of whack and filled up the table space.

Thus, when report caster was running its reports, it was not logging that it finished. So it just kept running over and over again because it wasn't flagged as finished.

We cleared the logs and fixed the problem.

Our DBA fixed the logging problem and other problems on the SQL side.


WebFOCUS 8
Windows, All Outputs
 
Posts: 18 | Registered: November 13, 2015Report This Post
Squatch
Master
posted Hide Post
I'll keep your experience in mind when I start working with Report Caster more.

Glad you solved the issue!


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Report Caster Problem

Copyright © 1996-2020 Information Builders