Unknown Query Engine Error

[Guest]

Forgive me if this is the wrong forum for this question, but I'm not really
sure where I should ask it.

I am using Crystal Reports to produce a report against a SQLServer database.
Up until 2 weeks ago, the report worked fine. No event was noticed that
might explain why the report stopped working, but now running it produces an
error "Unknown Query Engine Error".

The datasource is a stored procedure joined to a view and 2 tables. I don't
know the EXACT connection string that Crystal Reports is generating, but it
would be you should be able to get the idea from this:

SELECT vwCurrentFacilityInfo.FacilityName, tblItem.DecalNumber,
tblPerson.LastName
FROM dbo.spPropertyTagLetterItems() LEFT OUTER JOIN
dbo.tblItem ON dbo.spPropertyTagLetterItems.ItemID =
dbo.tblItem.ItemID LEFT OUTER JOIN
dbo.vwCurrentFacilityInfo ON
dbo.spPropertyTagLetterItems.ParentID =
dbo.vwCurrentFacilityInfo.FDEPFacilityID LEFT OUTER JOIN
dbo.tblPerson ON
dbo.vwCurrentFacilityInfo.SiteManagerID = dbo.tblPerson.PersonnelID

As I said, this worked until 2 weeks ago, and STILL works if I try generate
the report against the a copy of the database residing on a different server
((local) on my development machine).

Any ideas?

Thanks,

Pat

 

[Sue Hoegemeier]

It's a Crystal Reports error.
For Crystal Reports for Visual Studio .NET 2003, they have a
fix for this issue on their site. I think it was in the
monthly hot fixes which you can access at:
http://www.businessobjects.com/support/default.asp.
Other versions probably have it on their site somewhere.


-Sue