Support Article
Date not supported on external Marketing database
SA-54501
Summary
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.
Error Messages
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:
CREATE TABLE <ExternalMktDB>.weather (
city varchar(80),
temp_lo int, -- low temperature
temp_hi int, -- high temperature
curdate date
);
3. Go to Designer Studio > Data Model > Classes & Properties > Database Class Mappings.city varchar(80),
temp_lo int, -- low temperature
temp_hi int, -- high temperature
curdate date
);
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.
Root Cause
This issue was determined to be a product enhancement request. Pega Platform doesn't support Date type for any databases except DB2.
Resolution
An enhancement request, FDBK-25593, has been created for consideration by Pega Product Management.
Published July 23, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.