Scheduled Reports are not getting generated..
Hi,
I have a setup which has BOE XI , CRXI and OLAP XI installed. (CR version is 11.0.0.895)
There are reports which can be scheduled from our Application. However, the scheduled reports are not getting generated. Instead there is an error seen in event viewer.
Error in File C:\DOCUME1\ADMINI1.DHD\LOCALS~1\Temp\{F480C639-85FF-4F85-9CBF-57E54F10EEC3}.rpt:
Unable to open OLAP cube.Unable to open OLAP cube.
Details: Failed to execute command (Set name __CRYSTAL_SET_ON_AXIS_0__ is not valid.)
Failed to export the report
Create HTML file FAILED
at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase. (Exception )
at CrystalDecisions.ReportSource.EromReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.GetLastPageNumber(ReportPageRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.
..ctor(FormatEngine formatEngine, ExportRequestContext requestContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at AEAReportLauncher.ReportGenerator.GenerateRPT_HTMLInstance(ReportDocument& objReportDocument, EnterpriseSession& objEnterpriseSession, String strBasePath)
Alos note that the same report can be invoked and viewed in crystal designer.The error is seen when the report schedules are executed.
Any suggestions will be of great help.
Thanks
Shabnam