Solved

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

Posted on 2004-10-11
7
3,782 Views
Last Modified: 2012-06-27
Hi,

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


session("oRpt").ReadRecords

if Response.IsClientConnected = False Then
 Server.Transfer("cleanup.asp")
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>"
Else
 Response.Write "Error Occurred Reading Records: " & Err.Description
End if
 Set Session("oRpt") = nothing
 Set Session("oApp") = nothing
 Session.Abandon
 Response.End
Else
 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!!
Mike
0
Comment
Question by:mrmartin1
[X]
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
7 Comments
 
LVL 100

Accepted Solution

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

Have you installed the latest updates for CR9?

Hot fixes
http://support.businessobjects.com/fix/hot/mhf/crystalreports.asp#01

Service Packs
http://support.businessobjects.com/fix/hot/si75/default.asp#Crystal%20Reports%20Service%20Packs

mlmcc

0
 
LVL 1

Expert Comment

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

Expert Comment

by:frodoman
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.

frodoman
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 

Author Comment

by:mrmartin1
ID: 12347417
After applying the patches the problems disappeared - thanks!!!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12354149
Glad i could help

mlmcc
0
 

Expert Comment

by:sr_chari
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
            oDBT.SetLogOnInfo("sms_data")

            if oRPt.HasSavedData
              oRPT.DiscardSavedData()
            endif
with thisform
      .lDisableToolbar = .t.
      .SetActionMode()

      .oPreviewForm = createobject('crpreview', lcReport)

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


swarna
0
 
LVL 100

Expert Comment

by:mlmcc
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.

mlmcc
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 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