| Author |
 Topic  |
|
|
Thibault78
France
9 Posts |
 Posted - 12/29/2010 : 10:26:36
|
Hi,
I have a problem about subscription.
All seems to be ok about SMTP as I am able to send email for a particular report.
When I schedule a report, in history, I have "No data is returned.".
The report is a simple tab which return some test rows.
When I use "Link Url", it seems to work but not when I choose Attachement.
Can you help me ?
Regards,
Thibault78 |
Edited by - Thibault78 on 12/29/2010 10:36:36 |
|
|
marco
Netherlands
588 Posts |
Posted - 12/29/2010 : 11:20:51
|
Hi,
Are you using the latest build 172 and can repicate this on the demo server ?
Marco |
 |
|
|
admin
1637 Posts |
Posted - 12/31/2010 : 16:15:00
|
Under the History tab please double click to see the error and MDX. Please try to run the MDX in you get under History in SQL Server Management Studio.
Are you using SSAS Security? In other words, is the XMLA virtual directory set to use Anonymous or Basic authentication? |
|
|
|
Thibault78
France
9 Posts |
Posted - 01/03/2011 : 00:57:18
|
Hi,
I ran the query in Management Studio, no pb.
The virtual XMLA directory security is set to "Anonumous" only.
Also, I have modified some right on the server.
Now I have this error:
Cannot create ActiveX component.
at Microsoft.VisualBasic.Interaction.CreateObject(String ProgId, String ServerName)
at RpScheduler.SendEmail.EmailMessageCDONT(String sTitle, String sFromEmail, String sToEmail, String sBody)
at RpScheduler.SendEmail.EmailMessage(String sTitle, String sFromEmail, String sToEmail, String sBody)
I installed
CDONT (ExchangeMapiCdo.EXE, there is noting in C:\Windows\Temp\ReportPortal\ directory.
I use external smtp relay, not local exchange.
Also, I use .net framework 4.0.30319
Any idea ?
Regards.
Thibault78. |
Edited by - Thibault78 on 01/03/2011 09:11:59 |
|
|
|
admin
1637 Posts |
Posted - 01/04/2011 : 08:17:49
|
| It seems that the application is having a problem sending an email. Please go to Admin > Settings > Email and click “Test”. |
|
|
|
Thibault78
France
9 Posts |
Posted - 01/17/2011 : 06:48:15
|
Subscriptions work for link but not for attachment.
I have the folling error:
Error: XMLAnalysisError.0xc10e0002Parser: The syntax for ')' is incorrect.1366136601
, XmlaRequest.Execute() > GetFault()
at RpScheduler.XmlaRequest.Execute(String sMdx, String sServer, String sCatalog, String sURL)
at RpScheduler.XmlaRequest.ExecuteMdx(String sMdx, String sServer, String sCatalog, String sURL, String sOptionXml, String sConditionalFormat)
at RpScheduler.XmlaRequest.GetReportHtml(String sReportId, String sUserId, String sJobId)
at RpScheduler.Scheduler.ProcessReport(String sReportId, String sReportType, String sJobId, String sDeliveryType, String sContentType, String iLanguageId, String sToUserId, String sToUserName, String sToEmail, String sToNtUserId, String sToNtPassword, String sConditionOperator, String iConditionRow, String iConditionCol, String sConditionValue, String& sStylePage, String& sReportHtml, String& sError, String& sMDX, String& sReportDesc, String& sFilterLabel, Boolean& bConditionMet, String& sStyleThemeId); XMLA: http://X.X.X.X/YYYY/msmdpump.dll
Thibault |
|
|
|
admin
1637 Posts |
Posted - 01/18/2011 : 15:24:48
|
| If possible, please open “SQL Server Management Studio”, connect to SSAS using the XMLA URL (for Server name) provided in the error message. Next, run the MDX provided in the error message. |
|
|
| |
Topic |
|
|
|
Report Portal
Subscription problem
