Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Connect to a Postgres External Marketing Schema.
  2. 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.
       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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us