LBI Schedule runs but report is not produced

Check the SystemOut.log (WebSphere log) file and the crystalras_date_time_ras.log (Report Application Server log) file.
You should find a cause or a reason in one and/or both of these.

I beleive on reporting services administration there is a report schedul queue that records several statuses when a report schedule was sucessful or errored out or whether the email was delivered successfully in case of bursting a report and emailing the report. This feature will gather information only when the audit on the schedule is turned on. Accordingly you can get the status of a schedule whether it failed or not. I know this feature exists in the most recent versions of LBI.

Jan: I'll offer something to you and your IT department. And others as well :-) We've had huge turnover here in the past several years, or people get reassigned responsibilities, etc. I wrote a simple Perl script to go through the SystemOut.log file and check for a specific error message: 'No recipients to whom to send content'.

When it finds this in the log file, it basically means that there is either no delivery device for this user set up in LBI, or this user is on a report somewhere, and is no longer in the "system" ie Termination.

I've scheduled it from my LBI server to run twice a day, and send email to the LBI report admins. It has helped a lot!

The script isn't real pretty, and sends out an email even when it doesn't find anything in the logs to report, but the report admins here feel it has been beneficial.

Feel free to modify the script as you need to. I just ask that you leave me in the comments as original author.

-Greg

Nice Greg, thanks for sharing

To piggyback on the original question: Is there a log that I can check if a specific user has received (or not) his report?
I ask this, because I have faced an issue where half of the users got the report while the other half did. And Im 100% sure that all of them are still with the hospital.

Check the websphere logs...I recall the email address being logged there. There is nowhere in LBI to see this.

Thanks. I will check it.

I understand that once we get to LBI v 10, there will be lots of 'auditing' capabilities including report recipients and if they have gotten the report (or not).

If the report is not burted but just scheduled look at the report users on the schedule to check and see whether the user is added to the report users list on the schedule. Sometimes when you have a report that has been running and want to add a user to it, you should add the user on report users to the main report but also check to see whether the report users on the schedule for the report has the user or manually add it.

I juust read you message that a particular user has not received it - so if this is a bursted and distributed report then we had a similar issue. the way we resolved it was to go to your rs table and cehck for

ERS_STructure to look at the id that the structur has.

After this go to your ers_rule master table and look for all users who have a different structure id than the one they should have. If you delete the struture on LBi and readd the users to the structure it will update the structure id to the right structure.

Hi All,
I'd like to tag onto this thread and ask this: I have a similar issue, but the burst report is being delivered, and the attachment is "there", but when the recipient goes to open the attached file, an error window pops up "Missing file, etc". I suppose this is in the error logs as well....I do not have access to the log files, what and where should I tell the IT folks to look for?

Thanks in advance..

PS....I have checked the rights, etc...when user logs into LBI to see report, it opens OK to their section, so I have deduced that it is a delivery issue, not a rights issue..