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     Way to know if the report is still running...

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Way to know if the report is still running...
 Login/Join
 
shravan
Gold member
posted
Hi Everybody,

Is there a way to know whether the Report is still running or done running (just like the way to know if there are zero records in a report 
  
IF &LINES EQ 0...
)?

Thanks.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Francis Mariani
Expert
posted Hide Post
Log in to the WebFOCUS Server Console (http://your-server:8121/cgiatt.exe) and then navigate to Workspace > Monitor > Connections to view a list of active agents. If there is an agent running with the User ID and Date/Time of the request, then the request is still running.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
shravan
Gold member
posted Hide Post
Not that way,Francis. From within a procedure. The purpose is.... if the the report is still running, I am going to show some dummy report, when the report is done running I am going to the show original report.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Francis Mariani
Expert
posted Hide Post
"From within a procedure" - I thought that was what you wanted, but I'm not sure what you mean.

"From within a procedure" - it's always running. If it's not running, then the procedure has completed.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
shravan
Gold member
posted Hide Post
Ok, I will be clearer. Just the way when there are no records in the report we show a "Blank colorful Report" saying "Sorry ! No records for this selection.", I want to show a "Colorful Report" saying "Please Wait ! This report is still running." while the users wait for the report output.

So, is there any code that tells us that the report is still running just the way there is a code(
 IF &LINES EQ 0
) to show us whether there are no records in the report ?

Thanks.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Francis Mariani
Expert
posted Hide Post
You already asked this question and this is what was suggested.

Search for "Please Wait" on this forum and you will find some other ideas.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Darin Lee
Virtuoso
posted Hide Post
Follow Francis' suggestion to search for "Please Wait".

Also, if you think about your question, if a report is still running then there is not possibly a way to include any code in the fex that would return a value to tell you such. If a value could be returned, then the code would never be running. Nothing can be returned anywhere until the fex has completed.

The browser, however, would know if a result set has been returned. See above suggestion.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
shravan
Gold member
posted Hide Post
Thanks, Darin.

Opening a new HTML window does not work for me. I will try something else. I will let you know if I find something.


7.7.03, Windows 7, SQL Server 2005
 
Posts: 92 | Location: Carmel, IN | Registered: May 09, 2008Report This Post
Francis Mariani
Expert
posted Hide Post
This link shows you how to have an animated "Please Wait" message without opening a new window, but using an iFrame within the form page.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Hey Francis,

Congratulations on reaching 3000 posts today, U-DA-MAN!!!


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
YIKES! I didn't even notice. I guess that's why my head feels like it's about to explode!

Thanks!


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     Way to know if the report is still running...

Copyright © 1996-2020 Information Builders