Date not supported on external Marketing database
User is using Pega 7.2.2 with Pega Marketing 7.22. They have a table in external marketing database that has a date type column.
When mapping this table using external database class mapping wizard, they see the error "Unsupported Type:date" for the date type column present in the table.
If they open the class created by the external database class mapping wizard and in the External Mapping tab of the class record, they specify the date type column name present in the table and map it to a Pega property and do a Test Connectivity from the class record, user sees an error message for column of unsupported type date similar to the following error message.
Class PegaMKT-Data-weather is mapped to table marketing.weather in database ExternalMKTData, which has column curdate of unsupported type date
Steps to Reproduce
- Connect to a Postgres External Marketing Schema.
- Create a Table having “Date” column. An example is shown below:
temp_lo int, -- low temperature
temp_hi int, -- high temperature
4. Open External Database Table Class Mapping wizard, Select Database Name, Schema Name and the Table which was created in #2 above.
The Column with date data type is shown as Unsupported Type.
This issue was determined to be a product enhancement request. Pega Platform doesn't support Date type for any databases except DB2.
An enhancement request, FDBK-25593, has been created for consideration by Pega Product Management.
0% found this useful