|
I am running a C# 2010 windows application that calls a C# 2008 console application to make various calls to a web service. I am getting the following timeout error. I am wondering what part of the application I should look at to determine what is causing the timeout? Both applications are compiled in debug mode.
I am wondering if you can tell in the application what timeout parameter(s) need to be changed? What coding changes would I make to prevent the timeout errors from occuring?
Here is the error message:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
2013-01-24 16:40:03.3082|ERROR|Sample|************* Stack Trace *******************
2013-01-24 16:40:03.3238|ERROR|Sample| at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
|
|
|
|
|
As your stack trace mentions SQLClient in almost every line I would suspect it is your database query that is timing out, that will live in your WCF. You can change both the the connection timeout and/or the command timeout.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
dcof wrote: I am wondering what part of the application I should look at to determine what is causing the timeout
If it is a large application and especially if it is a system (multiple applications like you're having) you might want to consider some serious logging. The timestamps in the log can immediately tell you where the culprit is.
I suggest thinking the logging mechanism over for a while before jumping in a quick and dirty solution. Good logging saved my day in numerous times.
Hope this helps.
|
|
|
|
|
dcof wrote: What coding changes would I make to prevent the timeout errors from occuring?
What you need to do FIRST is determine what is being processed (presuming some SQL.)
The SECOND you need to determine what a reasonable time for that process to take - especially from the business side.
As an example it unreasonable to expect a user to wait for an hour for a web site to finish processing a request (where the web app is blocked until it is done.)
To "fix" a problem like this depends on the specifics of the problem but some or all of the following might be necessary but this is not a complete list.
- Tune the database/schema
- Adjust the SQL operation parameters or SQL itself.
- Rearch/design the interface to preclude such operations.
- Rearch/design the interface to create a batch processing system where a request is posted, some other process processes each request, and some time later a result is created, then the caller at some later time, may submit another (different) request to retrieve the result.
|
|
|
|
|
Hi,
It is never easy!! We have a response file which has two types of decisions, ACCEPT and DECLINE with in the comma separated name/value pair. I am inserting this information in to the database and want only the decision ACCEPT. In cases in line contains DECLINE, I want to skip this current line and go to the next line.
I am using the StreamREader to read the file.
Thanks!
|
|
|
|
|
Very simplistic, but something along the lines of:
if (line.Contains("ACCEPT"))
else
Just some pseudo code but that might set you off in the right direction. Might have been useful to see some code.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
try something like this.
using (StreamReader sr = new StreamReader(path))
{
while (sr.Peek() > -1)
{
string line = sr.ReadLine();
if( line.Contains("Accept"))
{
}
}
}
Jibesh V P
modified 24-Jan-13 16:53pm.
|
|
|
|
|
Thanks!
Line.Contains("ACCEPT") worked perfect!!
Wanted to find out, since you are already doing a PEEK, why are you still checking to see of the line is NULL?
|
|
|
|
|
arr... my bad, remove the null checking.. i modified the sample.
Jibesh V P
|
|
|
|
|
Load them all into a staging table and only process the ones you want from there.
|
|
|
|
|
Trying to add multiple markers based on coordinates in Google Maps API but it doesn't work.
What am I doing wrong?
Please help
Here is my code :
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Tirana Public Transport</title>
<!DOCTYPE html>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
<style type="text/css"> html { height: 100% } body { height: 100%; margin: 0px; padding: 0px } #map_canvas { height: 100% } </style>
<script src="http://maps.google.com/maps/api/js?sensor=false"
type="text/javascript">
var locations = [
['St1', 41.338089, 19.821689, 1]
['St2', 41.339926, 19.825723, 2]
['St3', 41.339733, 19.829285, 3]
['St4', 41.3368, 19.831345, 4]
['St5', 41.333159, 19.833877, 5]
['St6', 41.330581, 19.833834, 6]
['St7', 41.329647, 19.83156, 7]
['St8', 41.32752, 19.827225, 8]
['St9', 41.325232, 19.824436, 9]
['St10', 41.336027, 19.817097, 10]
['St11', 41.337123, 19.810488, 11]
['St12', 41.334319, 19.80654, 12]
['St13', 41.32752, 19.827225, 13]
['St14', 41.331967, 19.804394, 14]
['St15', 41.32536, 19.803879, 15]
['St16', 41.322557, 19.805081, 16]
['St17', 41.322331, 19.806712, 17]
['St18', 1.323201, 19.812891, 18]
['St19', 41.323975, 19.817784, 19]
];
var map = new google.maps.Map(document.getElementById('map'), {
zoom: 10,
center: new google.maps.LatLng(-33.92, 151.25),
mapTypeId: google.maps.MapTypeId.ROADMAP
});
var infowindow = new google.maps.InfoWindow();
var marker, i;
for (i = 0; i < locations.length; i++) {
marker = new google.maps.Marker({
position: new google.maps.LatLng(locations[i][1], locations[i][2]),
map: map
});
google.maps.event.addListener(marker, 'click', (function (marker, i) {
return function () {
infowindow.setContent(locations[i][0]);
infowindow.open(map, marker);
}
})(marker, i));
}
function initialize() {
var latlng = new google.maps.LatLng(41.331645, 19.817441);
var myOptions = { zoom: 15, center: latlng, mapTypeId: google.maps.MapTypeId.ROADMAP, draggable: false, zoomControl: false, scrollwheel: false, disableDoubleClickZoom: true };
var map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
}
</script>
</head>
<body onload="initialize()">
<form id="form1" runat="server">
<div>
</form>
</body>
</html>
|
|
|
|
|
I'm looking, and I'm not seeing any C# in there. So, why have you asked this in the C# forum? Why not post it in the web dev forum?
|
|
|
|
|
WinForms, of course.
Any idea why the overwrite prompt is popping up behind everything, rather than in front of everything where it might be useful?
Pushing the Alt key brings it immediately up where it belongs.
(As an aside, why are there two different SaveFileDialogs, depending on whether you choose to "ShowHelp"?)
|
|
|
|
|
Can you share the code how you invoke the SaveFileDialog, in my application its in front of the Winform UI.
It's the same SaveFileDialog with an additional button "Help" pressing the Help button should display a page on how to use this dialog. however when i tested in my PC pressing the Help buttons pops nothing.
Jibesh V P
|
|
|
|
|
jibesh wrote: Can you share the code how you invoke the SaveFileDialog
if (saveProjectDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
SaveProject(saveProjectDialog.FileName);
etc.
But I just found out it isn't just the SaveFileDialog doing it. Every MessageBox is doing the same. (No, nothing in the project is set to TopMost.)
I don't have anywhere to post screen captures at the moment, but the dialogs are different when ShowHelp is used or not. One is a huge Windows 7 Explorer-ish box, the other is a small dialog with the 5 icons down the left side for Recent Places, Desktop, Libraries, Computer, Network.
|
|
|
|
|
You can use this link [^]to upload your image and share the link here if you want to do so in future
Jibesh V P
|
|
|
|
|
Not from here. Not allowed by the organization.
"The request was denied due to a content categorization online-personal-storage."
|
|
|
|
|
Quote: Every MessageBox is doing the same
so this is nothing to do with the SaveFileDialog. Is just the MessageBox in your application behaves like this or same for the whole PC?
Jibesh V P
|
|
|
|
|
Just my app. (And on this and my home machine)
|
|
|
|
|
can you provide some more information about your Form where you display the saveFileDialog. how the form is displayed? was it a MDI Child? or a simple winform.
Jibesh V P
|
|
|
|
|
It's just the main form of a winforms app. The only settings on it that aren't the default are:
DoubleBuffered : True
StartPosition: CenterScreen
|
|
|
|
|
that's strange  . hmmm.. lets try all other possibilities then.
1. Clean and Rebuild all your solution
2. create a new sample winformn with one button on it and to call the same method, if it works there something is modified in your code.
handled any other events?
Jibesh V P
|
|
|
|
|
1. Done multiple times
2. other events:
Closing (prompts to save files)
Load (sets an MRU menu and lcoses the Splash form.
Thought it might be the Splash, but taking that out didn't fix it.
At this stage, I think I'll just go with a home-built prompt form instead of the MessageBox. At least that I can set to topmost...and it works. (It's also nice to have it look like the rest of the program instead of generic Windows box popping up.)
|
|
|
|
|
FYI, the Help button raises the HelpRequest event. It won't bring up the context sensitive help available via F1 or the ? button in the title bar, which probably comes courtesy of the Control.HelpRequested event.
Alan.
|
|
|
|
|
This will happen if you're creating the message box in a different thread. Make sure that any event handlers on asynchronous processes (network communication, serial ports, BackgroundWorker, TPL or ThreadPool background tasks, etc) that refer to the UI get BeginInvoke'd.
You mentioned a splash screen ... that is often done on a separate thread to the main UI, so check you haven't ended up creating message boxes in that thread.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
