HTTP Request error with Crystal Reports in InforCRM

I bumped into an issue today with a Crystal Report that would not run.  It had ran previously and other reports in the system were running fine.

wut?

unknown error

Checking the event log showed this error:

ERROR Quartz.Core.ErrorLogger – Job SlxJobService.Saleslogix.Reporting.Jobs.CrystalReportsJob threw an exception.
Quartz.SchedulerException: Job threw an unhandled exception. —> Saleslogix.Reporting.Jobs.ReportingJobContextException: The Crystal Reports Job has failed. —> CrystalDecisions.Shared.CrystalReportsException: The report may have invalid schema. Validate the tables, fields, and procedures in the main report document and all subreports. —> System.Runtime.InteropServices.COMException: The system cannot find the path specified. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)

What the… ??  Considering what I was doing, none of this made any sense.  My report was correct.  It ran fine outside of InforCRM, and Validating items in Crystal showed all items as valid.

The problem was due to a comment I had in the record selection formula.  Apparently, if you have commented-out code with no other text, the report cannot be run from InforCRM.

This is a problem

Apparently, this is an issue now.

To get around this, you have a couple options.  First of all, you could remove the commented-out code.  If the Record selection criterion is empty, then there is no issue.  If, however; you want to keep that information there (like in my case, to save testing code), then you can also add something after the comment that would resolve as “True” in crystal.  As long as it has something valid, it should be fine.

This works

So, adding something like “1=1”  Should come up as valid (no errors found), and will allow the report to run from InforCRM while also keeping your comments.

Thanks for reading!

ABOUT THE AUTHOR

Jason Buss

Jason is a senior application developer with Customer FX.

2 Comments

  1. Jason, thanks for sharing.

    Which version(s) of Infor CRM was this tested on…..and have you filed this as a bug with Infor?

    Reply
    • This specific case was in 8.2 update 02, and as far as I know, it is still an issue with 8.3. I haven’t reported this as a bug (yet). I wanted to test it on 8.3 and possibly a couple versions down first.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!