400: A table with the specified name does not exist

Products

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

Issue/Introduction

While trying to add seed list connection for database, I am getting below error in TDM portal.

"Failed to save DB Seedlist configuration

400: A table with the specified name does not exist for this connection profile"

The table "gtsrc_reference_data" does exist in database "Scramble" and I am able to query it also.

Environment

Release : 4.10

Cause

Insufficient access for the user being used in connection profile.

Resolution

Granting required permissions to the DB user configured in the connection profile resolved the issue.

Additional Information

For more information, see Create and Edit Connection Profiles