?
Solved

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

Posted on 2004-10-11
7
Medium Priority
?
3,814 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 1000 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
[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

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

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