Computed column and Timestamp datatype retained for SQL File publish
search cancel

Computed column and Timestamp datatype retained for SQL File publish

book

Article ID: 243357

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Patch 4.10.24 allow to exclude computed and timestamp fields during publish (applies only to SQL Server). This is working well when publishing into the table.

But the data published in a SQL file still contains these columns, which causes errors. 
The TDM portal does not behave the same way when publishing to tables as when publishing to an SQL file.


Find attached the SQL file resulting from a publish.

Of course, all test we done under SQl Server DBMS.


Tested on version 4.10.29 of the portal.

Environment

Release : 4.10

Component : TDM Web Portal

Resolution

The fixed binaries are available from Broadcom Support.  They are TDM_Portal_docker-4.10.35.0.tgz and TDMWeb-4.10.35.0.zip.

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

After installing the patch it is crucial to register again any table with computed/timestamp columns which you want to use for publishing!