TDM GT Subset Error - 'schema does not exist' during XML Derived Table Export

Products

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

Issue/Introduction

When attempting to export data for derived tables registered via an XML object in TDM portal the export fails with the following error:

"Database Error Message: schema does not exist"

Environment

Product: CA Test Data Manager (Data Finder / Grid Tools)

Database: Microsoft SQL Server

Resolution

To resolve this issue, you must configure the connection profile to allow dynamic schema resolution:

1. Navigate to the Connection Profile settings used for the problematic export.
2. Locate the schema configuration field.
3. Change the setting to "Do not specify schema names".
4. Save the profile changes.
5. Re-run the export for the derived tables.