Article - CS251374
"Failed to validate workbook" is reported when saving a Excel model in ThingWorx Analytics Manager 52.2
Modified: 24-Nov-2016
Applies To
- ThingWorx Analytics 52.2
Description
- Following error is reported in TW_AS_ExcelAgent.exe window when Saving an Excel Model
ERROR excel - Failed to validate workbook
System.NullReferenceException: Object reference not set to an instance of an object.
at ExcelAnalysisService.excel.WorkBookImp.hasXMLMap(String name)
at ExcelAnalysisService.excel.WorkBookImp.Validate()
ERROR AnalysisSDKAgentThing - Model deploy failed System.Exception: WorkBook is invalid.
at ExcelAnalysisService.excel.ExcelHelper.DeployModel(Model res)
at AnalysisSDKAgentLib.AnalysisSDKAgentThing.deployModel(InfoTable modelData)
System.NullReferenceException: Object reference not set to an instance of an object.
at ExcelAnalysisService.excel.WorkBookImp.hasXMLMap(String name)
at ExcelAnalysisService.excel.WorkBookImp.Validate()
ERROR AnalysisSDKAgentThing - Model deploy failed System.Exception: WorkBook is invalid.
at ExcelAnalysisService.excel.ExcelHelper.DeployModel(Model res)
at AnalysisSDKAgentLib.AnalysisSDKAgentThing.deployModel(InfoTable modelData)
- This occurs when selecting Analysis Models > New , fill the relevant information and Save in Analytics Manager
- Validation is successful using command VerifyModel.exe -d ExcelFilename.xlsx, though it reports an error
Checking model file ExcelFilename.xlsx
Error occured during cleanup The process cannot access the file 'ExcelFilename.xlsx' because it is being used by another process.
The model file is valid for analysis services framework.
Error occured during cleanup The process cannot access the file 'ExcelFilename.xlsx' because it is being used by another process.
The model file is valid for analysis services framework.
This is a printer-friendly version of Article 251374 and may be out of date. For the latest version click CS251374