sessionState mode="SQLServer" causes an error

2 posts, 0 answers
  1. Bernard
    Bernard avatar
    2 posts
    Member since:
    Nov 2011

    Posted 18 Feb 2013 Link to this post


    I would like to implement the SessionState mode = "SqlServer" (not the InProc).



          allowCustomSqlDatabase = "true"

          sqlConnectionString="Data Source=mySource;Initial Catalog=MyDB ;Persist Security Info=True;User ID=Myuser;Password=MyPwd"




    Everything works well behalf Telerik Reporting !!!

    I join the complete message I receive in Report viewer:

    Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.
       at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
       at Telerik.Reporting.Service.SilverlightClient.RenderAndCacheEventArgs.get_RenderingResult()
       at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnRenderAndCacheCompleted(Object sender, RenderAndCacheEventArgs e)

    ------------- InnerException: -------------

    System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
       at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
       at proxy_4.EndRenderAndCache(IAsyncResult )
       at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndRenderAndCache(IAsyncResult result)
       at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)

    ------------- InnerException: -------------

    System.Net.WebException : The remote server returned an error: NotFound.
       at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
       at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)

    ------------- InnerException: -------------

    System.Net.WebException : The remote server returned an error: NotFound.
       at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
       at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
       at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)

    Any ideas ?
  2. Steve
    Steve avatar
    10941 posts

    Posted 19 Feb 2013 Link to this post

    Hi Bernard,

    We have not been able to reproduce such a problem in our local tests and suspect there is something else wrong in your scenario, as the Not Found error is a generic one. In order to get more information about the actual problem try the following:
    • show the Output window in Visual Studio and check whether there is an exception when you're running your application in debug mode.
    • access the .svc file directly in your browser to see if it reports any problems.
    • enable the CLR exceptions from Debug --> Exceptions menu in Visual Studio and run your project in debug.
    Additionally, you already have a runnable sample at your disposal - the Visual Studio examples we install along with the product. You can use the Silverlight application and configure it to use Out-Proc session.

    the Telerik team

    See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

Back to Top