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

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
mrmartin1Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
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
 
sendmeblahCommented:
Is this a multi-threaded application?
0
 
frodomanCommented:
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
mrmartin1Author Commented:
After applying the patches the problems disappeared - thanks!!!
0
 
mlmccCommented:
Glad i could help

mlmcc
0
 
sr_chariCommented:
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
 
mlmccCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.