Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQLServer2008
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
Ravikiran
Posted 10-Apr-12 2:22am
Comments
digimanus at 10-Apr-12 14:30pm
   
well...... 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 at 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... <operationcontract()> Private Function fnStoreProcedureGetDataSet(ByVal strQry As String, ByVal strpara As String) As List(Of SearchData) Try 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)) Next End If retScmd.CommandType = CommandType.StoredProcedure retScmd.Connection = retScon sadaDapt.SelectCommand = retScmd sadaDapt.Fill(datsData) retScon.Close() 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 Else StrColumnName = StrColumnName & "," & datsData.Tables(0).Columns(IntClnCnt).ColumnName End If Next Dim clsRpts As New ClsCommonRpt Return clsRpts.fnGetLargeReportData(datsData) Catch ex As Exception Return Nothing End Try End Function
digimanus at 15-Apr-12 10:49am
   
do the queries that run in error take longer than 15 seconds to process?
Roliking at 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 at 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
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 372
1 OriginalGriff 295
2 thatraja 215
3 Emre Ataseven 155
4 Shai Vashdi 125
0 Sergey Alexandrovich Kryukov 8,849
1 OriginalGriff 5,035
2 Peter Leow 3,949
3 Maciej Los 3,535
4 Abhinav S 3,148


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