Click here to Skip to main content
11,934,425 members (52,376 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL SQL-Server-2008
Hello All,

When i am trying to execute a stored procedure and get the result set to fill in a grid from a silverlight application i am getting the error message as

The Remote server returned an error: Not found

While most of the stored procedures are working without any problem only 2 stored procedures are returning this error while executing from a silverlight enabled WCF service. When the same procedure is being executed on the SQL server query browser it is working fine, but when called from the silverlight application it is showing the error.

Is this due the large number of rows in stored procedure output or the execution time of the stored procedure or is it anything else?

Can somebody help me out with this issue please ??

Thanks in advance
Posted 10-Apr-12 3:22am
digimanus 10-Apr-12 14:30pm
what is the time out setting?
are all the queries run by the same connectionstring (user!)? Maybe some code to show to elaborate the question?
Roliking 11-Apr-12 0:13am
yes, all the queries are run by the same connection string but i am executing only one stored procedure at a time and not all the stored procedures together...

Private Function fnStoreProcedureGetDataSet(ByVal strQry As String, ByVal strpara As String) As List(Of SearchData)
retScon.ConnectionString = settings.ConnectionString
retScmd.CommandText = strQry
If strpara.Trim.Length > 0 Then
Dim strPar() As String = Split(strpara, "!@!") // The parameters are concatenated with !@! and later split to individual parameters.
For intcount = 0 To strPar.Length - 1
retScmd.Parameters.AddWithValue(strPar(intcount).Split("|").ElementAt(0), strPar(intcount).Split("|").ElementAt(1))
End If
retScmd.CommandType = CommandType.StoredProcedure
retScmd.Connection = retScon
sadaDapt.SelectCommand = retScmd
Dim IntClnCnt As Integer = 0
Dim StrColumnName As String = String.Empty
For IntClnCnt = 0 To datsData.Tables(0).Columns.Count - 1
If StrColumnName = String.Empty Then
StrColumnName = datsData.Tables(0).Columns(IntClnCnt).ColumnName
StrColumnName = StrColumnName & "," & datsData.Tables(0).Columns(IntClnCnt).ColumnName
End If
Dim clsRpts As New ClsCommonRpt
Return clsRpts.fnGetLargeReportData(datsData)
Catch ex As Exception
Return Nothing
End Try
End Function
digimanus 15-Apr-12 10:49am
do the queries that run in error take longer than 15 seconds to process?
Roliking 16-Apr-12 0:17am
yes it is and the number of rows fetched is also significantly large...
but there are other procedures with large output and which takes more than 15sec to execute but they work well.. cannot understand whats happening in this case..
is there any specific issue??
digimanus 16-Apr-12 9:16am
what is your connection time out setting?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151126.1 | Last Updated 10 Apr 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100