Schedule Reports

[Lakshmi]

hello,
In 5.5 i am trying to schedule a report. when i am schedule the report Immediately to a mail Id a new screen is displayed showing that job done sucessfully.
But,

I didnot recevie any mails. Should i need to do any thing else for this schedule jobs?
Please help me...

[nick.polites]

Re: Schedule Reports

The first thing I would check is to ensure that your app server has been configured for reports with the same configuration as your web server. The application server is what sends out the emails with all of the report parameters. Also ensure that rptapache is running on your OTM reports instance as this is what schedules the reports.

[sprabhakar]

Re: Schedule Reports

Lakshmi,
As you see the 'job scheduled successfully' screen, I would advice you to check the following :

1. Did the report complete successfully ?
2. Has the mail server been configured properly on the app server ? Details are available on the glog.properties file.
3. Do you have the correct permissions on the directory where the scheduled reports are being stored ?

- Prabhakar

[geetika]

Re: Schedule Reports

HI all,
even i am facing the same poroblem, the reports are geting stored in th server after being scheduled sucessfully,but i am not getting any mail notification for same, so to view the report i have to go and check in the server,but the requirement is to get a attachment report in the mail, please anyone help in this.

[nick.polites]

Re: Schedule Reports

HI all,
even i am facing the same poroblem, the reports are geting stored in th server after being scheduled sucessfully,but i am not getting any mail notification for same, so to view the report i have to go and check in the server,but the requirement is to get a attachment report in the mail, please anyone help in this.

Please take a look at my earlier response. You need to ensure that you have your app and web server configured correctly for reports, and have OTM rptapache running correctly on your oracle reports server. Without actually looking at your setup it is going to be very hard to determine where the issue is. You may want to contact Oracle support for assistance.

[geetika]

Re: Schedule Reports

thanks alot, i'll surely check for this,but one more thing i would to include, now i am geting the mail notification for scheduled public reports only, that too if i go to 'send report' option in Business Process Automation<Process Management<send report
no notifications are coming for user defined reports, would be highly thank ful if you could tell some more idea to solve the prob now.

[sprabhakar]

Re: Schedule Reports

Geetika,
As you are getting public reports through mails, I would suspect hat you have not used the template provided by OTM for report development.
Let me explain:
When you create a report using the standard report template, there is a piece of code in the after report trigger that generates a insert statement into the REPORT_LOG table in your reportowner schema. Once a scheduled report is generated, a REPORT_READY event is triggered inside the application with the job number of the scheduled report. The automated report job ( mentioned above in your email) picks up the job number and goes to the REPORT_LOG table and picks up the report name. It then uses the report server configuration details provided in the glog.properties of the app server and fetches the report file from the report server and sends it out.

Please check the above and advise if this resolves your problem. If not, please post your error and we will advise next steps.

Regards
Prabhakar

[geetika]

Re: Schedule Reports

thanks Prabhakar,
even though i made the chnges in the after report trigger, i am not getting any nofications for the user defined reports, these reports are there in the sheduled task in business process automation,but nothing is coming as notification even afer clicking 'send report' option.

another way i m trying is as follow, please see this as well
i am using two agents, one agent of shipment type , having action "PRINT DOCUMENT"
and other agent of report type having action of notification,the second agent has triggering event "REPORT_READY" with the restriction on the report set which need to be scheduled.
i am getting all notifications of first agent, but the second agent is not triggering at all, i tried with report set of public reports but the prob still remain same,

please suggest somthing for any of the method i tried.