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.
Fast Data Masker errors when attempting to select an XML root in a DB2 CLOB field
Article ID: 222288
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction
Trying to perform in-place masking of CLOB data stored in DB2 database (LUW) using FDM. The sample CLOB data looks like below.
<XMLAJBFipayRequest Version="1.0"> <IxCmd>485</IxCmd> <IxDebitCredit>GiftCard</IxDebitCredit> <IxStoreNumber>005</IxStoreNumber> <IxTerminalNumber>100</IxTerminalNumber> <IxTranType>ActivatePhysicalCard</IxTranType> <IxDate>02142017</IxDate> <IxTime>115346</IxTime> <IxAccount>25186149</IxAccount> <IxAmount>722</IxAmount> <IxInvoice>Y100185570</IxInvoice> </XMLAJBFipayRequest>
In FDM, when i select XML/JSON data, FDM is failed to parse the XML data. When I verify XML content, I don’t see any errors.
FDM Error message attached.
Error parsing MESSAGE_DATA. Error message - Start of root element expected.
I saw a patch (4.9.37) solving this issue but still I am getting the error. I have tried with FDM 4.9.1 GA, 4.9.37, and 4.9.186 (latest patch)
We are at the last stage of PoC and need your guidance on how to mask DB2 CLOB field.
DB2 Table details attached.
Cause
Defect.
Environment
Release : 4.9.1
Component : Fast Data Masker
Resolution
Provided latest FDM patch, 4.9.191, whihc resolved this issue.
Feedback
Yes
No
Powered by
