| Author |
 Topic  |
|
|
blairk
4 Posts |
 Posted - 09/06/2007 : 13:42:05
|
Hi
I have recently installed build 144. I have setup subscriptions for a number of users but it doesn't work consistently. Sometimes nobody will receive an e-mail, other times some users receive it but not others.
Any advice on this would be appreciated. |
|
|
marco
Netherlands
588 Posts |
Posted - 09/06/2007 : 14:21:32
|
Hi,
Which Report type and are you using User Filter Value and which exported format: excel, pdf or html ?
Marco |
 |
|
|
blairk
4 Posts |
Posted - 09/06/2007 : 15:06:08
|
Hi
I'm trying to delivery standard OLAP reports, I'm not using user filter values and am using Excel as the delivery format.
Thanks for your reply.
Blar.
quote:
Originally posted by marco
Hi,
Which Report type and are you using User Filter Value and which exported format: excel, pdf or html ?
Marco
|
|
|
|
admin
1637 Posts |
Posted - 09/07/2007 : 14:16:03
|
When you go to the Subscription History tab do you see that the email was generated?
If yes, please try to troubleshoot your SMTP service by stopping it and looking under the SMTP Pickup folder (C:\Inetpub\mailroot\Pickup). |
|
|
|
blairk
4 Posts |
Posted - 09/07/2007 : 15:56:15
|
Hi
The subscription history tab is blank. Even on occasions where the e-mail has been received the history is still blank. I have tried using local smtp server and external with same intermittent result. |
|
|
|
admin
1637 Posts |
|
|
blairk
4 Posts |
Posted - 09/09/2007 : 14:00:06
|
Hi
The RP Scheduler service is installed and running.
Blair. |
|
|
|
marco
Netherlands
588 Posts |
Posted - 09/10/2007 : 06:32:02
|
Hi,
I would advise you doing the following steps:
- Install SMTP server as IIS component
- Register CDO for sending emails
- Restart IS Admin in Services (incl. SMTP server)
- Restart RP Schedulder in Services
- Add the name of the local SMTP server in Settings
- Test email sending by just sending an email from ReportPortal OLAP report. If this is working than SMTP and CDO are installed ok.
- Add a URL Tricker schedule
- Add a Subscrpition based on the schedule for sending an Excel sheet as attachement for an OLAP report without any User Filter Values
If this is working you can try to use User Filter Values, sending PDFs, Making Excel files on the server and ftp publish and try Subscription with SQL Reports.
If you have any problems, please let me know.
Marco
|
|
|
|
vane307
Argentina
25 Posts |
Posted - 06/14/2010 : 12:41:50
|
Hi, I have the same problem with all the users.
- I have installed build 170
- Nobody will receive an e-mail
- The RP Scheduler service is installed and running.
- The subscription history tab is blank.
With the build 168 it works fine.
Any advice on this would be appreciated.
Regards,
Vane |
|
|
|
admin
1637 Posts |
Posted - 06/14/2010 : 16:39:21
|
Vane,
Are you able to send an email using Admin > Settings > Email > test?
|
|
|
|
vane307
Argentina
25 Posts |
Posted - 06/15/2010 : 11:28:20
|
Yes, I sent an email using Admin > Settings > Email > test and then I have received it. But the subscriptions don't work.
Regards, |
|
|
|
admin
1637 Posts |
Posted - 06/15/2010 : 21:19:00
|
If the report is not private, did you select the user(s) that should receive the report subscription?
Please open the subscription (right clicking on the report and select Subscription) and click on the History tab. Do you see any record? If you see an error, double click on item to see the error description. |
|
|
|
vane307
Argentina
25 Posts |
Posted - 06/16/2010 : 06:31:45
|
Hi,
Yes, i do have a designed user on the subscription. When I click on the History tab, it is blank. If i do double click on the blank space I obtain the following error:
[Exception: Incorrect Sintax near of '='.;SQL: Select u.FirtName, u.LastName, h.StartTime, h.EndTime, h.Status, h.ReturnText, h.FilePath, h.CommandText Fron JobHistory h inner join AppUser u on h.ReceiverID = u.UserId where h.HistoryId =
ReportPOrtal. Helper.GetDataReader(string sSQL) +277
ReportPortal.ViewHistory.() +86
ReportPortal.ViewHistory.Page_Load (Object sender, EventArgs e) +81
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesBeforeAsyncPoint) +627
Regards |
|
|
|
admin
1637 Posts |
Posted - 06/16/2010 : 10:02:16
|
The error you see is a bug that comes up when you click on an empty History page. It will be fixed in the next build.
Does the user you have selected have an email? |
|
|
|
vane307
Argentina
25 Posts |
Posted - 06/16/2010 : 10:30:16
|
Yes, the user I have selected have an email. When I test to send an email it works fine.
Regards, |
|
|
|
admin
1637 Posts |
Posted - 06/17/2010 : 23:29:21
|
| Please send the screenshots of the Subscription Dialog’s General tab and Schedule tab to support@ReportPortal.com. |
|
|
| |
Topic |
|
Report Portal
Report Subscriptions Problem
