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.

Datamaker crashes running POST action to update table column

book

Article ID: 8601

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We tried to update an XML type column within an Oracle table. Although we could run the query in SQL Developer,  Datamaker would crash when updating the column.  Below is the sample query that was being run in SQL Developer and Datamaker


update orderxmldata 
set orderxml = XMLType('<A/>') 
where orderxmldataid = 679139;

Cause

We found out that Datamaker does not handle existing locks that are in the target database.   In the above example,  the update was performend on orderxmldata via SQL Developer,  but a commit on the update was never performed to release the locks on the table.  When Datamaker tried the same SQL,  the records were locked,  and Datamaker crashed without error.

Environment

TDM 4.X - Using Oracle 12c as both the data source and target

Resolution

If you are going in behind the scenes with a secondary SQL query tool outside of Datamaker,  and making changes to data,  please make sure you commit those changes in your tool, before having Datamaker perform any publishing jobs.   It's not supported to be updating target or source data while Datamaker is performing a publish action.