search cancel

Find & Reserve fails for PostgreSQL tables - data type 'bpchar' is not supported

book

Article ID: 252839

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Portal  4.10.101.0

We are migrating our databases from Oracle to PostgreSQL. While trying to set up a Standard Find & Reserve model in TDM Portal, we are seeing the following error:

"Table Column cannot be assigned to the Find & Reserve Model because the column's data type is not supported"

The offending column is 'field_name' (Database field name) using the 'bpchar' data type, which is resulting in the error.

However, for fields using data types, varchar, and timestamp, are working. 

 

Environment

Release : 4.10

Resolution

Support for the PostgreSQL bpchar (Blank Padded Character) data type has been added in TDMWeb-4.10.116.0 or greater.