Fast Data Masker - Error scrambling xls file

book

Article ID: 110151

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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)

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.

Environment

Fast Data Masker, FDM versions 4.7.x

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.