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

[Berry Hamber]

Is the underlying data source for the broken dashboard more complex or less stable than the working dashboard?

Good luck!

[Mahendran Maragatha Patchai]

Hi Berry Hamber,

To determine the cause of the issue, we kindly request you to provide the following information, which will assist in further analysis and help us deliver an optimal solution:

- A screenshot of the query used in the data source and the associated records count.

- The version of the Dashboard platform where the issue occurred.

- Logs from the specified locations:

  - When loading the Dashboard from Designer: %ProgramData%\Syncfusion\DashboardDesigner\DashboardDesigner_Version\IISExpress_DashboardService\ErrorLog

  - When loading the Dashboard from Server: C:\Syncfusion\Dashboard Server\DashboardServer.Web\API\ErrorLog

  - When loading the Dashboard from SDK: %localappdata%\Syncfusion\Dashboard Platform SDK\Service\ErrorLog