Support Article
Operand type clash: datetime2 is incompatible with tinyint
SA-22335
Summary
Logs are showing errors referencing Operand type clash: datetime2 is incompatible with tinyint in MS SQL DB.
Error Messages
com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: datetime2 is incompatible with tinyint
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
...
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
- Run AES717 on a MS SQL Server database.
- Start the server and the error will appear in the log file when administrator starts to navigate in the AES portal.
Root Cause
A defect in Pegasystems’ code or rules
There is an incompatibility between datetime2 and tiny int in msSQL
Resolution
Apply HFix-26993
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.