cancel
Showing results for 
Search instead for 
Did you mean: 

Scheduled Reports are not getting generated..

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Is this application developed by you, or is the app developed by a 3rd party? Do other - non OLAP reports work?

BTW.; you are running the original, unpatched vesion of CR. This version of CR is also out of support - just an FYI...

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Former Member
0 Kudos

Hi,

Yes this is developed by us. I'm currently testing it.

The reports can be viewed when invoked directly, but there seems to be an issue with scheduling.

Also, on restarting the server, scheduling works fine for a period of 10-12 days and again starts failing.

Yes, the crystal is infact an old version and my application also was developed about 3 years back.

This issue i'm facing is actually a customer issue at a site.

Thanks

Shabnam

former_member183750
Active Contributor
0 Kudos

Since you have BOE, you may still have a valid support contract. I'd recommend creating a phone case. From the description:

"...scheduling works fine for a period of 10-12 days and again starts failing"

I am pretty sure this is not something easily solved through forums.

Ludek

Former Member
0 Kudos

Thanks Ludek. I will work with BOE and post a reply if I get a solution.

former_member183750
Active Contributor
0 Kudos

That would most certainly be appreaciated. I fish these forums a lot for KBasse, wiki and blog creation and I have a feeling this may turn out to be one of those cases.

In the meantime, happy coding,

Ludek

Answers (0)