RESTART masking option not working for SAP HANA database

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Getting below error while trying to run masking on SAP HANA DB with RESTART option enabled. DB user has ALTER table access to add column.

2026-03-03 16:45:20.358 [main] INFO - checking Pre Process results for table Name: XXXXXXXX
2026-03-03 16:45:20.358 [pool-3-thread-1] INFO -  processing table: XXXXXXXX
2026-03-03 16:45:20.358 [pool-3-thread-1] INFO - executing ...
2026-03-03 16:45:20.375 [pool-3-thread-1] INFO - Error processing sql 
2026-03-03 16:45:20.375 [pool-3-thread-1] INFO - Error Code:-11243
2026-03-03 16:45:20.375 [pool-3-thread-1] INFO - SAP DBTech JDBC: SQL statement is null or empty.
2026-03-03 16:45:20.375 [pool-3-thread-1] INFO - Failed to add restart column de_ident_ind for table: XXXXXXXX
2026-03-03 16:45:20.375 [pool-3-thread-1] INFO - Identified as main thread: false.

 

Environment

FDM < 4.11.2024

Cause

The RESTART option logic has not been implemented yet for SAP HANA DB in FDM hence the error says "empty" SQL statement.

Resolution

Download and apply the FDM patch build 4.11.2024 or above where the RESTART option logic has been implemented for SAP HANA DB.

https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649