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

SQL Server JDBC error on SMALLDATETIME

SA-14620

Summary



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 com.pega.pegarules.data.external.rd.constants.ColumnType.SMALLDATETIME.


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.

Resolution



The correct type to use is datetime.

 

Suggest Edit

Published June 5, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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