Fast Data Masker - Error scrambling xls file

Document ID : KB000110151
Last Modified Date : 09/08/2018
Show Technical Document Details
Issue:
Unable to scramble excel files [with extension XLS ] . Getting error after starting the mask.
The error message is mentioned below:
Exception in thread "main" org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException: The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF) 
at org.apache.poi.openxml4j.opc.internal.ZipHelper.verifyZipHeader(ZipHelper.java:184) 
at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipStream(ZipHelper.java:241) 
at org.apache.poi.openxml4j.opc.ZipPackage.
(ZipPackage.java:98) 
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:324) 
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:37) 
at org.apache.poi.xssf.usermodel.XSSFWorkbook.
(XSSFWorkbook.java:291)
at com.grid_tools.products.datamasker.Datamasker.doExcelFileMasking(Datamasker.java:10693) 
at com.grid_tools.products.datamasker.Datamasker.main(Datamasker.java:6354)
Environment:
Fast Data Masker, FDM versions 4.7.x
Cause:
This error comes up because XLS file extension is not supported by FDM for masking. The "excel file" type of connection in fast data masker supports only xlsx file extensions.
Resolution:
This error comes up because XLS file extension is not supported by FDM for masking. The "excel file" type of connection in fast data masker supports only xlsx file extensions. Save the XLS file as XLSX using MS-Excecl and try the masking. It should mask successfully.