 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [SOLVED] No report from ReportCaster, but runs fine on its own???
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] No report from ReportCaster, but runs fine on its own??? Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] No report from ReportCaster, but runs fine on its own??? | Login/Join |
| Platinum Member |
I have a report that resides in IA and it runs fine if I run it from the web interface, but the Reportcaster schedule log says "No report from Task" and "No report to distribute". There are no errors in the log. What is going on? As far as I know, this is the only report that is happening to and it hasn't changed since long before this issue started. What am I missing? Thanks.This message has been edited. Last edited by: DWaybright, WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | ||
|
| Expert |
ReportCaster can be very finicky. Have you tried running with tracing on, when you edit the schedule ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
Waz, I don't know how to do that. Is that something done in the console? WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Virtuoso |
Is this a Document, Chart or Report? What's the output format? Did it used to work and stop or did you just create the schedule? WebFOCUS 8206, Unix, Windows | |||
|
| Platinum Member |
This is a report, output format is PDF, not overriding that in the schedule. The schedule has been running for months on a monthly basis. Last month was the first time it didn't work. Now that I think about it, I did change the recipients, but that shouldn't cause the report to not generate, right? If that was a problem wouldn't it give an error to that effect? There are no error messages in the log. WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Virtuoso |
Can you try a test schedule using this report and see if that works? If that works, something is causing the original schedule to break. If it doesn't work even in a new schedule, then the scheduler is having a problem. In this test, I would also test other formats to see if that's an issue. Is this report in the Domain or on the app directory? WebFOCUS 8206, Unix, Windows | |||
|
| Platinum Member |
I created a new schedule for the report and that didn't work either -- same thing: No report to distribute. This time I noticed in the log the line "SET DISTRIBUTE=OFF" but I don't see that line in the report code and there are no INCLUDE statements in the report. I'm guessing that is why no report from ReportCaster. Where could that be coming from? The Task status is Enabled, the Distribution email status is Enabled. WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Expert |
IF you can find the schedule, double click on it, then in the top row, there is a run button with a drop down next to it. the run with traces is there. But, not sure if you can get to the trace, as it is on the Web Client. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
Waz, I never noticed that before! I ran it with trace, but I didn't see anything... where does the trace go? The log looked the same as if I ran it without trace. Thanks. WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Virtuoso |
Can you test this new schedule with SET READLIMIT=10 SET RECORDLIMIT=10 in the very beginning of the report? WebFOCUS 8206, Unix, Windows | |||
|
| Expert |
It gets written to trace files on the Web Client. ibi/WebFOCUS82/ReportCaster/trc So depends on whether you have access to the server its on. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
Waz, I was able to get access to that directory, however, there were no files with yesterday's date (or this morning's as I tried again). Is it possible that the trace facility is disabled? Babak - I can do that, but I don't know how that will help since no report is generated of any size when ReportCaster runs it. It generates the report if I run it from the web interface. WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Virtuoso |
It seems like the problem is specific to this report not all scheduled reports. I assume a TABLE FILE CAR will successfully run and email you the output. No Report Generated could mean the size of the sort blew you out of the water and what you thought should be sent was never there. Consequently, eliminating the internal sort by limiting the number of records helps narrow down the problem. WebFOCUS 8206, Unix, Windows | |||
|
| Platinum Member |
Babak - I put these lines at the beginning of the report and they gave me an error. Yes, all other reports run fine, it is just this one. Thus my frustration! I may just recreate it and the schedule and see if that fixes it.This message has been edited. Last edited by: DWaybright, WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Expert |
Did you do a run with traces ?, this is not a setting, it will run the report and create the trace files. There should be a folder under the location I gave, and it will have the trace information. I am also thinking you should open a case with Tech Support Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
Waz, I ran with traces but I could never find the trace files. I tried recreating the report but had the same issue. I think I will have to open a case. Thanks. WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Virtuoso |
Deb The traces will be on the server where the WebFOCUS client is installed under \ibi\WebFOCUS82\ReportCaster\trc. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Platinum Member |
Thank you everyone who offered suggestions. I forgot this report is a compound report. Even though it had been running fine and the last change to the report was only to the SQL code, it suddenly fell victim to the compound report ReportCaster bug. When I changed the schedule to override the output (but told it to override it to the same output format), it started working again. Gotta love those WebFocus quirks!  WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] No report from ReportCaster, but runs fine on its own???
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] No report from ReportCaster, but runs fine on its own???Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |