session ("oRpt").ReadRecords Error - The table " could not be found

Posted on 2004-10-11
Last Modified: 2012-06-27

I am using Crystal Reports 9.0 on a Windows 2000 system.  I am receiving an intermittent error when running Crystal Reports stating 'Error Occured Reading Records : table " not found'

The below code produces this error.  This looks to me like Crystal is not finding table(s) when attempting to access the server and therefore this is probably a server problem - but I'm not sure.


' Retrieve the Records and Create the "Page on Demand" Engine Object
On Error Resume Next


if Response.IsClientConnected = False Then
End if

If Err.Number <> 0 Then
If Err.Number = -2147189544 Then
 Response.Write "<b> Sorry for the Inconvenience!<br><br> Report Server is busy! Please,Try again after few minutes!</b>"
 Response.Write "Error Occurred Reading Records: " & Err.Description
End if
 Set Session("oRpt") = nothing
 Set Session("oApp") = nothing
 If IsObject(session("oPageEngine")) Then
     set session("oPageEngine") = nothing
 End If
 set session("oPageEngine") = session("oRpt").PageEngine
End If

Has anyone encountered this type of intermittent error before and if so what did they do about it.

Thanks in advance!!
Question by:mrmartin1
LVL 100

Accepted Solution

mlmcc earned 250 total points
Comment Utility
Have not encoutered that one.

Have you installed the latest updates for CR9?

Hot fixes

Service Packs



Expert Comment

Comment Utility
Is this a multi-threaded application?
LVL 42

Expert Comment

Comment Utility
Sounds like you may be losing the session variable.  Could be a connection problem, could be a multi-threading problem.  I assume when you say "sometimes" that it's not consistently on some computers - if that was the case then it could also be browser settings as well.

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline


Author Comment

Comment Utility
After applying the patches the problems disappeared - thanks!!!
LVL 100

Expert Comment

Comment Utility
Glad i could help


Expert Comment

Comment Utility
I have a simillar problem. I am calling CR9 from FoxPro 8. Here is my code.

            * open report
            *oRpt = oCR.OpenReport(lcReport)
            oRpt = thisform.oCrystal.OpenReport(lcReport)

            * Create the Database object
            oDB = oRpt.Database()

            * Get a references to the DatabaseTables collection
            ocDBT = oDB.Tables()
            * Get a reference to the DatabaseTable object for table 1
            oDBT = ocDBT.Item(1)
            *oConnInfo = ocDBT.Item(1).ConnectionProperties
            *oConnInfo.Item("DSN") = "dev_data"

            * Set the location
            * This one works for a DSN

            if oRPt.HasSavedData
with thisform
      .lDisableToolbar = .t.

      .oPreviewForm = createobject('crpreview', lcReport)

      .oPreviewForm.WindowState = 2
I get the same error message. I tried running the hotfix. It did not solve my problem.  Thanks in  advance for any help.

LVL 100

Expert Comment

Comment Utility
swarna -  Once a question is answered, generally the only people that might look at it are the experts who made comments and then only because you added a comment.  To get a better answer and to involve other experts who might bew able tohelp, please start a new question.  There is an ASK A QUESTION link in the left column.


Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now