This is a migrated thread and some comments may be shown as answers.

Reporting Parameters returns 500 Error

2 Answers 101 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Frank
Top achievements
Rank 1
Frank asked on 26 Jun 2018, 03:34 PM

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 Answers, 1 is accepted

Sort by
0
Frank
Top achievements
Rank 1
answered on 26 Jun 2018, 03:51 PM
Using the path "/api/reports/formats" returns valid formats.
0
Silviya
Telerik team
answered on 28 Jun 2018, 01:06 PM
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
Tags
General Discussions
Asked by
Frank
Top achievements
Rank 1
Answers by
Frank
Top achievements
Rank 1
Silviya
Telerik team
Share this question
or