ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

After upgrade to FDM 4.8, Masking with excel does not work

book

Article ID: 133601

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Subject:-

TDM: After upgrade, Masking with excel does not work

Description:-

************** 

I need assistance ASAP, we migrated to FDM 4.8.4.0 in our Production environment but now excel masking does not work.

Environment:

***************

FDM 4.8.4.0

Error:

*******

>2019-05-17 11:26:04.235 Fastdatamasker version: 4.8.4.0

>2019-05-17 11:26:04.250 Fastdatamasker build date - May 3 2019

>2019-05-17 11:26:04.266 PID:[email protected]

>2019-05-17 11:26:04.266 Java version 1.8.0_201

>2019-05-17 11:26:04.266 OPERATING SYSTEM USER: <<USER_NAME>>

...

>2019-05-17 11:26:04.281 Cloakware configuration initialized.

>2019-05-17 11:26:04.319 ************************

>2019-05-17 11:26:04.319 Checking license

>2019-05-17 11:26:04.328 Valid license key found

>2019-05-17 11:26:04.328 LICENSE DETAILS

>2019-05-17 11:26:04.328 License Type: FULL

>2019-05-17 11:26:04.328 Company Name: <<COMPANY_NAME>>

>2019-05-17 11:26:04.328 Site Id: <<SITE_ID>>

>2019-05-17 11:26:04.328 Product Id: TDMMAS990

>2019-05-17 11:26:04.328 Valid to: 06-29-2019

>2019-05-17 11:26:04.328 ************************

>2019-05-17 11:26:04.344 Masking will be as follows

>2019-05-17 11:26:04.344 ***************************

>2019-05-17 11:26:04.360 ***************************

>2019-05-17 11:26:04.360

>2019-05-17 11:26:04.360 starting masking at 2019.05.17 11:26:04.360 EDT

>2019-05-17 11:26:04.391 java.lang.NoClassDefFoundError: org/dom4j/DocumentException

> at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:149)

> at org.apache.poi.openxml4j.opc.OPCPackage.(OPCPackage.java:136)

> at org.apache.poi.openxml4j.opc.Package.(Package.java:54)

> at org.apache.poi.openxml4j.opc.ZipPackage.(ZipPackage.java:98)

> at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:199)

> at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:178)

> at org.apache.poi.util.PackageHelper.open(PackageHelper.java:53)

> at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:176)

> at com.grid_tools.products.datamasker.Datamasker.doExcelFileMasking(Datamasker.java:8259)

> at com.grid_tools.products.datamasker.Datamasker.main(Datamasker.java:4795)

>Caused by: java.lang.ClassNotFoundException: org.dom4j.DocumentException

> at java.net.URLClassLoader.findClass(Unknown Source)

> at java.lang.ClassLoader.loadClass(Unknown Source)

> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

> at java.lang.ClassLoader.loadClass(Unknown Source)

> ... 10 more

>

Observations:

*****************

Client discovered that on a working 4.7 environment, there is a file that is not in 4.8; file below:

dom4j-1.6.1.jar in folder :\Apps\CA\TDM\FastDataMasker\lib

Also file: xml-apis-10.b2.jar should also be there.

Also needed: poiooxml3.16.jar

Cause

Missing files.

Environment

Release : 4.8

Component : CA Test Data Manager - Fast Data Masker

Resolution

FastDataMasker-4.8.7.0 resolves this issue.  Please contact BC support for this version or a later version.  Please note this is NOT in the 4.8 TDM GA release.  If you are install a GA Release after 4.8, please verify with BC Support that this FDM version made it into the GA version in question.  There is no reason for it NOT to make it into the next GA version after 4.8.