Getting this error when running a Crystal Report

Kinetic ERP
1

Getting this when running Crystal Report.

System Information

==================

AppServer Connection: (unsure if I should post the server url here or not)
Form Name: EpiCrystalViewer
Customization Name:
Menu ID:
Software Version: 4.1.200.9

============

Application Error

Exception caught in: mscorlib

Error Detail

============
##!Message:##! Unable to cast COM object of type ‘CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass’ to interface type ‘CrystalDecisions.ReportAppServer.Controllers.ISCRReportSource’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{98CDE168-C1BF-4179-BE4C-F2CFA7CB8398}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
##!Program:##! CommonLanguageRuntimeLibrary
##!Method:##! GetCOMIPFromRCW

Client Stack Trace

==================
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Refresh()
at CrystalDecisions.ReportSource.EromReportSourceBase.Refresh(RequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Refresh(RequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Refresh()
at CrystalDecisions.CrystalReports.Engine.Table.SetDataSource(Object val, Type type)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet)
at Ice.Lib.Report.EpiCrystalPushRpt.SetRptDataSource(DataSet dtsData, ReportDocument oRpt)
at Ice.Lib.Report.EpiCrystalPushRpt.Process(List`1 rptDocList, String dataFile, String rptFile, DataSet dtsData, Session session)
at Ice.Lib.Report.EpiCrystalViewer.LoadReport(Object state)

Saw another post saying use personalization purge but I’m unsure how that would effect it and which personalization to purge. Can’t run any Crystal reports from my account as of right now. Haven’t tried any other accounts though.

2

Do you have the Epicor Crystal Reports Runtime Installed on your client machine?

Are you SaaS? or OnPrem?

If on Prem - do you have read access to the Epicor Server “AppData” folder?

DaveO

3

Yes I do have it installed. But I did just install the visual studio .net extension so maybe that screwed it up?

SaaS.

4

Looks like I figured it out. Sort of.

It happened when I installed Crystal Reports for Visual Studio.

What I ended up doing to fix it was to:
Uninstall crystal reports on my machine but not the new Visual studio crystal reports extension.
Reinstall crystal reports
Reboot - Unsure if it matter but I did anyways.

All was good after that.

5

Still not resolved.

Looks like the issue is Visual Studio Crystal Reports extension. My guess is because Epicor is 32 bit. My OS is 64. Visual studio is 64 and so is Crystal Reports extension.

32 bit version of Crystal Reports was installed on my machine and it worked previously. Once I install Visual Studio with the Crystal Reports extension it breaks.

Tried to install all 32 bit but Crystal Reports extension always comes in as 64 bit since the OS is 64 bit.

Seems like the only way to edit Crystal Reports is setup another machine and do the editing on that and testing on my main machine. Tried making this work every way but cannot seem to get it to work.

Looks similar to this… (though this is old)