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