We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Getting the DV008 Error. Please help

Thread ID:

Created:

Updated:

Platform:

Replies:

140936 Nov 15,2018 06:51 AM UTC Nov 15,2018 09:04 AM UTC Dashboard Platform 1
loading
Tags: Dashboard Designer
Langa Kambi-Shamba
Asked On November 15, 2018 06:51 AM UTC

Hi when i attempt to publish a specific dashboard via embed or data agent the publishing is successful but when I go to view dashboard I get DV008 error with the following details:

Syncfusion.XlsIO.Implementation.Exceptions.ParseException: IFS isn't custom function.  at position 9. Formula: iferror(IFS(J2<AH2,"2",J2>AI2,"2")), Position: 12
   at Syncfusion.XlsIO.Implementation.FormulaTokenizer.RaiseException(String msg, Exception ex)
   at Syncfusion.XlsIO.Implementation.FormulaParser.CreateCustomFunction(Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments, Boolean registerFunction)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFunction(Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFirstOperand(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions& options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ParseExpression(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ExtractOperands(ExcelParseFormulaOptions options, ParseParameters arguments, ExcelFunction functionId)
   at Syncfusion.XlsIO.Implementation.FormulaParser.CreateFunction(ExcelFunction functionId, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFunction(Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFirstOperand(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions& options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.ParseExpression(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaParser.Parse(String formula, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
   at Syncfusion.XlsIO.Implementation.FormulaUtil.ParseString(String strFormula, IWorksheet sheet, Dictionary`2 indexes, Int32 i, Dictionary`2 hashWorksheetNames, ExcelParseFormulaOptions options, Int32 iCellRow, Int32 iCellColumn)
   at Syncfusion.XlsIO.Implementation.FormulaUtil.ParseSharedString(String strFormula, Int32 iFirstRow, Int32 iFirstColumn, IWorksheet sheet)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.SetSharedFormula(WorksheetImpl sheet, String strFormulaString, String strCellsRange, UInt32 uiSharedGroupIndex, Int32 iRow, Int32 iCol, Int32 iXFIndex, Boolean bCalculateOnOpen)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseFormula(XmlReader reader, IInternalWorksheet sheet, Int32 iRow, Int32 iCol, Int32 iXFIndex, CellType cellType)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseCell(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, Int32 rowIndex, Int32 columnIndex, List`1 cellStyleIndex)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseRow(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, String cellTag, Int32 generatedRowIndex)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheetData(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, String cellTag)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheet(XmlReader reader, WorksheetImpl sheet, String strParentPath, MemoryStream& streamStart, MemoryStream& streamCF, List`1 arrStyles, Dictionary`2 dictItemsToRemove, Dictionary`2 dictUpdatedSSTIndexes)
   at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParseWorksheetData(WorksheetImpl sheet, Dictionary`2 dictUpdateSSTIndexes, Boolean parseOnDemand)
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.GetUsedRange(Boolean isUsedRange)
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.get_UsedRange()
   at Syncfusion.Dashboard.Base.DataExtracter.SQLiteExtracter.ExcelToSQLite(String path, SchemaInfo selectedSchema, String sqliteDBName, IWorkbook workbook, Boolean isLoadAllData, String destinationPath)
   at Syncfusion.DashboardService.DashboardService.MoveToSqLite(String path, SchemaInfo selectedSchema, ConnectionProviderType connectionType, Char separator, ObservableCollection`1 jsonTableInfoCollection, String sqliteDbName)
   at Syncfusion.DashboardService.DashboardService.<>c__DisplayClass341_13.<FillRelationalDataManager>b__23(SchemaInfo s)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Syncfusion.DashboardService.DashboardService.FillRelationalDataManager(String key, Boolean cacheable, String modifiedConnectionStrings, String token, String itemId, String reportId, Boolean hasMultipleDashboard, DashboardParametersModel dashboardParameterSettings)
   at Syncfusion.DashboardService.DashboardService.InitializeControls(DashboardServiceArguments arguments)
   at SyncInvokeInitializeControls(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

Renuka N [Syncfusion]
Replied On November 15, 2018 09:04 AM UTC

Hi Langa, 
 
We have checked the reported issue but, we are not able to reproduce the mentioned issue in our end. Could you please share the issue reproducing sydx file or sample excel data that would be helpful to investigate further on this issue. 
 
Thanks, 
Renuka N. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;