PostgreSQL publish post-action runs without error, but the table is not updated

Products

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

Issue/Introduction

We are using TDM Portal 4.11.74.0 to publish synthetic data to a PostgreSQL 15.7 database table. We've configured the Generator to run a post-action SQL statement that will remove entries that match specific WHERE conditions. 

For example: DELETE FROM <SCHEMA>."<TABLE>" WHERE UPPER("<COLUMN1>") = UPPER('<STRING>') OR "<COLUMN1>" IS NULL OR "<COLUMN2>" IS NULL 

The publishing job completes successfully, and the post-action is executed, but the PostgreSQL table is not updated. The rows that we expected to be deleted are still present.

Environment

TDM Portal 4.11

PostgreSQL 15.7

Cause

The Post-action was not picking up the proper connection profile.

Resolution

Reconfiguring the Publish configuration to use the Target Data base connection profile resolved the issue.