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




Use the Connector and Metadata Wizard to create a connection to an external SQL Server database. If the referenced table has columns of type Date, they do not appear for selection. If it has columns of type smalldatetime, they can be selected. However, resulting reports referencing these columns generate the error upon saving.


Error Messages

 Error: No enum constant

Steps to Reproduce

1. Install the Microsoft JDBC driver for SQL Server (version 4.1).
2. Create a database name rule to connect to the database.
3. Run the Connector wizard (SQL) and try to generate the data model (class and properties) for a table in SQL Server.
4. Try creating a report definition with any smalldatetime columns.

Root Cause

Database type smalldatetime is not supported.


The correct type to use is datetime.


Published June 5, 2016 - 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