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
Solved

overflow exception in system.data

Posted on 2006-11-19
6
298 Views
Last Modified: 2010-04-16

Hi -

Short description

My web app is running fine when I run it in the debugger on my dev machine, but fails with an overflow exception in system.data when I run it on the server.

Question

is there some way I can get a better error than just the overflow? Can I somehow step into code when it is executing on the server? Alternatively, is there some way I could reproduce the error on my dev machine?

Thanks!



Detailed Problem Description
 
I've written a C# web app that filters a DataSet with ADO. I am using the DataTable.select method. I am creating the filterexpression argument dynamically in order to filter one table with data from a related table.
 
The first table named "cruises" holds data about river boat cruises. Each cruise stops at a number of ports during the cruise. This is determined by a "cruiseports" table that relates cruises to ports by cruise id. I am needing to build the cruise itinerary of ports from this table. "cruises" does not have any port id values. Instead this table is normalized and port ids must be derived via the cruise id in the "cruiseports" table. In other words, a single cruise will relate to multiple records in the cruiseports table. There will be one record for each stop that each cruise makes in a port.
 
Perhaps I should have used a DataRelation class object, but it didn't seem to give me much more? I am new to ADO.
 
Unfortunately, the related table is quite large and my design has turned out not to be scalable. Things worked fine with test data, but my code failed with a overflow exception error in System.data with real data.
 
I was able to fix this error on my local machine by breaking up my filterexpression into multiple DataTable.select calls. But this approach is still failing when I run the app on the server. I don't understand why this would happen since I was assuming that running the app on my dev server would be the same as running the app with a true client and server environment?
 
There is very little data being sent in both the request and response, so I don't think the problem is likely to be a race condition caused by latency. I am wondering if there is more memory available on my dev machine when the web app is run in in debug mode? I don't know enough about server memory. This seems like something that might come up with memory intensive apps such as search engines?
 
Questions
 
Do you have any idea why I would get this overflow exception in System.data?  Is there some way that I can step through the code when it is failing on the server? Alternatively, is there a way I can cause my dev server to fail in this way? I'm stuck without a line number or even a more meaningful error message. Also, is there some known design pattern that deals with this problem? Thanks!

Peter
0
Comment
Question by:coltrane2003
  • 2
6 Comments
 
LVL 12

Expert Comment

by:deanvanrooyen
ID: 17977239
hey you can debug the process on the server from your dev box, but you might need some security permissions added to you..
0
 
LVL 2

Author Comment

by:coltrane2003
ID: 17981255
Ok this sounds promising. Can you list the steps that I will need to take to do this? Thanks!

Peter

0
 
LVL 12

Accepted Solution

by:
deanvanrooyen earned 250 total points
ID: 17985405
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

861 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