Reporting Parameters returns 500 Error

3 posts, 0 answers
  1. Frank
    Frank avatar
    2 posts
    Member since:
    Apr 2018

    Posted 26 Jun 2018 Link to this post

    I am receiving the following error (used Fiddler to find it) when attempting to load ReportViewer on IIS 10 on Windows Server 2016. I do not receive the error when running locally (from VS 2015). I am using v12.0.18.227 of Telerik.Reporting, Telerik.ReportViewer.Mvc, and Telerik.Reporting.Services.WebApi. The process runs using telerikReportViewer-12.0.18.227.js.

    This report has additional lookups defined for drop-downs (as partially displayed in "Localhost_working.png").

     

    HTTP/1.1 500 Internal Server Error
    Cache-Control: no-cache
    Pragma: no-cache
    Content-Type: application/json; charset=utf-8
    Expires: -1
    Server: Microsoft-IIS/10.0
    X-AspNet-Version: 4.0.30319
    Persistent-Auth: true
    X-Powered-By: ASP.NET
    Date: Tue, 26 Jun 2018 15:14:11 GMT
    Content-Length: 5953
    {"message":"An error has occurred.","exceptionMessage":"Exception has been thrown by the target of an invocation.","exceptionType":"System.Reflection.TargetInvocationException","stackTrace":"   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlCommandProvider.cs:line 175\r\n   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlCommandProvider.cs:line 311\r\n   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommandCore(IDbConnection connection, Boolean evaluateParameters) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlQueryProvider.cs:line 119\r\n   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlQueryProvider.cs:line 91\r\n   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlDataEnumerable.cs:line 117\r\n   at Telerik.Reporting.Processing.Data.SeedDataAdapter.GroupData(IEnumerable`1 rawData) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SeedDataAdapter.cs:line 144\r\n   at Telerik.Reporting.Processing.Data.SeedDataAdapter.Execute(IEnumerable`1 data) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SeedDataAdapter.cs:line 119\r\n   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Execute(IEnumerable`1 data) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\ResultSet.cs:line 22\r\n   at Telerik.Reporting.Processing.Data.MultidimentionalDataProvider.Execute(MultidimensionalQuery query) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\MultidimentionalDataProvider.cs:line 48\r\n   at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameterProperties(P parameter, IReportParameter parameterDef, IDictionary`2 parameterValues, Boolean parentChanged) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\ReportParametersManager.cs:line 317\r\n   at Telerik.Reporting.Processing.ReportParametersManager`1.Calculate(P parameter, IDictionary`2 parameterValues, Boolean parentChanged, Boolean& valueChanged) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\ReportParametersManager.cs:line 267\r\n   at Telerik.Reporting.Processing.ReportParametersManager`1.RecalculateParameters(IDictionary`2 parameterValues) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\ReportParametersManager.cs:line 172\r\n   at Telerik.Reporting.Processing.DocumentParametersManager`1.CalculateParameters(IDictionary`2 values) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\DocumentParametersManager.cs:line 113\r\n   at Telerik.Reporting.Processing.DocumentParametersManager`1.GetMergedParameters(IDictionary`2 values) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\DocumentParametersManager.cs:line 129\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Services.WebApi\\ReportsControllerBase.cs:line 166\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.<GetExecutor>b__3(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()"}

  2. Frank
    Frank avatar
    2 posts
    Member since:
    Apr 2018

    Posted 26 Jun 2018 in reply to Frank Link to this post

    Using the path "/api/reports/formats" returns valid formats.
  3. Silviya
    Admin
    Silviya avatar
    414 posts

    Posted 28 Jun 2018 Link to this post

    Hi Frank,

    I will post my reply from the support ticket #1173958 you've opened on the same topic:

    "The exception occurred is generic and usually is associated with data retrieving. Based on the stack trace it looks like a problem with the connection to the database.

    In general, the SqlDataSource component uses standard ADO.NET classes, the corresponding .NET data providers installed on the machine and the set connection string to establish a connection and retrieve data. Please check if you are using proper .NET data provider, allowing you to execute standard queries and stored procedures.

    Also, we would need details about the following:
    - The hosting environment on which the project is hosted 
    - Is the hosting have any limitations? 
    - Do you use the same ADO.NET data provider?"

    Let's continue the discussion in only one of the threads in order to prevent duplication and overhead.

    Regards,
    Silviya
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top