ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Subscription problem

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Thibault78 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
6   L A T E S T    R E P L I E S    (Newest First)
admin 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.
Thibault78 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 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 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.
admin 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?
marco Posted - 12/29/2010 : 11:20:51
Hi,

Are you using the latest build 172 and can repicate this on the demo server ?

Marco

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page