GT Subset Create Table as Select not working as expected for Build MS SQL Direct Insert scripts
search cancel

GT Subset Create Table as Select not working as expected for Build MS SQL Direct Insert scripts

book

Article ID: 272636

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to create subsets by using the MS SQL Direct Insert scripts and selecting Create Table as Select option while doing it. It doesn't seem the generated SQL scripts correctly. They fail to properly check if the tables exist on the target and create and insert the data there. The image below shows how my options are selected. 


 
While running the insert script, we see the following error:

Error executing insert SQL
Changed database context to 'DatabaseName'
Msg 301, Level 11, State 5, Server XXXXXX, Line 3
Cannot drop the table 'DatabaseName.Schema.TableName', because it does not exist or you do not have permission.
Inserts Complete

 

Solution Engineering has determined the SQL Server insert script is creating an extra "," during the generation of the script for L0 temp table, also the Use database should be the target database and not the source one.

 
 

Environment

Release : 4.10

Resolution

This is resolved in GT SubSet 4.10.125.0. The patch is available for download in the TDM Patches page.