DV008 error message when exporting to Excel

[Neil Allen]

Hi folks,

I have a dashboard that displays my results in a grid which is working fine, however when I right click to export that data I get the error message DV008 and the data won't export from the grid. I get the option to and it looks like it's generating the excel or csv file then i get the DV008 error message. I have a similar dashboard that works fine and I can't figure out what is causing the problem if anyone can shed some light on it?

Thanks,

Neil.

System.AggregateException: One or more errors occurred.   at Syncfusion.Dashboard.Base.Data.SqlQueryBuilder.ExecuteScalarQueryAsync(String query, String connectionString, ConnectionProviderType type)

   at Syncfusion.Dashboard.Base.Data.ServerDataProvider.GetRowCount(ServerDataProviderParameters parameter)

   at Syncfusion.Dashboard.Base.Engine.RelationalEngine.GetRawDataCountforWidgetsFromMainSource(List`1 schemaInfoCollection, List`1 viewerFilterList, RelationalReport report, Boolean isNotControlFilter, String username, Boolean showAllFields)

   at Syncfusion.DashboardService.Base.DashboardServiceBase.getResultTableDataForExcelAndCSVExport(RelationalEngine controlEngine, DashboardServiceArguments arguments, List`1 controlSchemas, List`1 filterColumns, RelationalReport currentReport, Boolean isHigherRowCount, String username, GridSettings gridSettings, Int32 start, Int32 end)

   at Syncfusion.DashboardService.Base.DashboardServiceBase.SetWorkBook(DashboardServiceArguments arguments, IWorkbook newbookWorkbook, IApplication application)

   at Syncfusion.DashboardService.Base.DashboardServiceBase.ExportAsExcel(DashboardServiceArguments arguments)

   at Syncfusion.DashboardService.Base.DashboardServiceBase.GetServiceResponse(DashboardServiceArguments arguments)

  at lambda_method(Closure , Object , Object[] )

   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.b__9(Object instance, Object[] methodParameters)

   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)

   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Controllers.ApiControllerActionInvoker.d__0.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Controllers.ActionFilterResult.d__2.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Filters.AuthorizationFilterAttribute.d__2.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Controllers.AuthenticationFilterResult.d__0.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Controllers.ExceptionFilterResult.d__0.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Web.Http.Controllers.ExceptionFilterResult.d__0.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__1.MoveNext()

[Soundarya Mani Meharan]

Hi Neil Allen,

Thank you for reaching out to us. Based on the information provided, we are currently unable to determine the root cause of the issue. To facilitate further investigation, we kindly request the following details:

• Please provide the HAR file when loading the dashboard from the server. If the dashboard loads in the designer, kindly share the event logs by following the KB article - Steps to Share Windows Event Logs. (boldbi.com).
• A screenshot of the widget along with its configuration.
• The version of the Dashboard platform with which you encountered this issue.
• Please provide the logs from the following location when,
  - Loading Dashboard from Designer: %ProgramData%\Syncfusion\DashboardDesigner\DashboardDesigner_Version\IISExpress_DashboardService\ErrorLog
  - Loading Dashboard from Server: C:\Syncfusion\Dashboard Server\DashboardServer.Web\API\ErrorLog
  - Loading Dashboard from SDK: %localappdata%\Syncfusion\Dashboard Platform SDK\Service\ErrorLog

Thanks,

Soundarya