Solved

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

Posted on 2004-10-11
7
3,791 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 101

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
Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

 

Author Comment

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

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 101

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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