Support Article
Operand type clash datetime2 is incompatible with tinyint on AES
SA-17649
Summary
AES EE 7.1.7 on Pega 7.1.7 with Microsoft SQLServer database appears to work. However, the error message occurs many times in the log file.
Error Messages
Operand type clash datetime2 is incompatible with tinyint
com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: datetime2 is incompatible with tinyint
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:354)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:576)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6003)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5785)
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:68)
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:43)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeQuery(SqlReportExecutor.java:284)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:128)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:90)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:57)
at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1203)
at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:10716)
at com.pegarules.generated.definition.ra_action_getemailrecipientbyclusterscorecard_a96ea31ce7848823190af6f2548ff637.perform(ra_action_getemailrecipientbyclusterscorecard_a96ea31ce7848823190af6f2548ff637.java:50)
at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3180)
at com.pegarules.generated.activity.ra_action_pxretrievereportdata_a3add20b4fb0a3473fdbdde8b5ce3d52.step27_circum0(ra_action_pxretrievereportdata_a3add20b4fb0a3473fdbdde8b5ce3d52.java:2887)
at com.pegarules.generated.activity.ra_action_pxretrievereportdata_a3add20b4fb0a3473fdbdde8b5ce3d52.perform(ra_action_pxretrievereportdata_a3add20b4fb0a3473fdbdde8b5ce3d52.java:580)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)
Steps to Reproduce
The issue can only be replicated when running AES EE 7.1.7 on a Microsoft SQL Server database.
Start the server and the error appears in the log file when the administrator starts to navigate in the AES portal..
Root Cause
A defect in Pegasystems’ code or rules that affects the Microsoft SQL Server Date column type
Resolution
Apply HFix-26993.
Alternatively, update or upgrade to Pega 7.1.8 or later release.
Related Content
SA-22335, https://pdn.pega.com/support-articles/operand-type-clash-datetime2-incompatible-tinyint
Resolved Issue 184842
DB2 DateTime conversion fixed
Published August 23, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.