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

Posted on 2004-10-11
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 101

Accepted Solution

mlmcc earned 1000 total points
ID: 12281597
Have not encoutered that one.

Have you installed the latest updates for CR9?

Hot fixes

Service Packs



Expert Comment

ID: 12282662
Is this a multi-threaded application?
LVL 42

Expert Comment

ID: 12286557
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.

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.


Author Comment

ID: 12347417
After applying the patches the problems disappeared - thanks!!!
LVL 101

Expert Comment

ID: 12354149
Glad i could help


Expert Comment

ID: 13862711
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 101

Expert Comment

ID: 13873136
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 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