[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1570
  • Last Modified:

Crystal Reports Error message

Hi All,
We have created a C# remoting application that uses CR 10 for report writing.  Crystal gets the information from an XSD that we create and pass to Crystal.  We get an error message at times (I can not find a pattern) when a report is going to be displayed as follows:

CrystalDecisions.CrystalReports.Engine.DataSourceException: Unknown Query  Engine Error  
 
Error in File  
 
C:\DOCUME~1\GORDON~1\LOCALS~1\Temp\{57DDE6FF-72DE-4A03-946C-E317DF263410}.rpt:  
 
Unknown Query Engine Error ---> System.Runtime.InteropServices.COMException  
 
Unknown Query Engine Error  
 
Error in File  
 
C:\DOCUME~1\GORDON~1\LOCALS~1\Temp\{57DDE6FF-72DE-4A03-946C-E317DF263410}.rpt:  
 
Unknown Query Engine Error  

I have only found one other posting that has the same problem.  It is located here:
http://www.eggheadcafe.com/ng/microsoft.public.vb.crystal/post20450279.asp

No one ever answered the question, so I do not know what might be causing the problem.  Has anyone seen this problem before?  

Any help would be greatly appreciated.

Scott
0
smpross
Asked:
smpross
  • 2
1 Solution
 
topdog770Commented:
I see this error when the report does some kind of joining/selection record operation and the datasource doesn't contain relevant data.

For example say TableShape has a shape_id field and TableSquare has a shape_id field that references the TableShape.shape_id
so the query would be something like select * from TableSquare, TableShape where TableSquare.shape_id = TableShape.shape_id.

If one or both of these tables are empty, the report(s) always give me the same error as you are seeing.

0
 
smprossAuthor Commented:
Thanks.  But the strange thing is that if I exit the application and restart the application and run the same report with the same parameters, the report runs fine.  Any ideas what might cause that?

Scott
0
 
topdog770Commented:
Sorry, Scott.

My experts-exchange emails started getting treated as spam so I missed your original response.

Does your report have the Discard saved data option checked or unchecked..

another out there possibility.. are you doing trying to reintialize the com objects when running the report for the second time in your application.. OR cleaning up all of the com / crystal stuff and then trying to re-communicate?

0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now