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 December 10, 2015 - Updated August 23, 2017

Have a question? Get answers now.

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