Question

3
Replies
130
Views
chars1 Member since 2015 46 posts
PEGA
Posted: 4 years ago
Last activity: 4 years 6 months ago
Closed

AES 717 log shows com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: datetime2 is incompatible with tinyint

Hi there

I have 2 issues

1. 2016-03-16 15:56:10,843 [   PegaRULES-Batch-5] [  STANDARD] [                    ] [           AES:07.13] (l.access.ConnectionManagerImpl) ERROR   - Not returning connection 85 for database "pegadata" to the pool as it previously encountered the following error

User ID: System

Last SQL: SELECT "PC0".pyEmail1 AS "pyEmail1" , "PC0".pzInsKey AS "pzInsKey" FROM rules.pegaam_email_recipient "PC0" WHERE  (  ( "PC0".ClusterName = ?  OR "PC0".ClusterName = ?  )  AND  ( "PC0".pyEmail1Type = ?  OR "PC0".pyEmail1Type = ?  )  AND  (  ( (CASE       WHEN ((DATEPART(dw,? +@@DATEFIRST-2)%7)+2 -? ) >= 0 THEN     (CASE   WHEN ((DATEPART(dw,? +@@DATEFIRST-2)%7)+2 -? ) = 7      THEN 1 ELSE              ((DATEPART(dw,? +@@DATEFIRST-2)%7)+2 -? )  +1 END)              ELSE ((DATEPART(dw,? +@@DATEFIRST-2)%7)+2 -? )  +8 END) = ?  AND  ( "PC0".pyEmail1Type = ?  OR "PC0".pyEmail1Type = ?  OR "PC0".pyEmail1Type = ?  )  )  OR  ( "PC0".pyEmail1Type <> ?  AND "PC0".pyEmail1Type <> ?  AND "PC0".pyEmail1Type <> ?  )  )  AND  ( CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Sunday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  AND CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Monday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  AND CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Tuesday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  AND CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Wednesday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  AND CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Thursday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  AND CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Friday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  AND CASE WHEN rules.pr_read_from_stream('.DaysOfWeekSubscribedFor.Saturday', "PC0".pzInsKey, "PC0".pzPVStream) IS NULL THEN 0  ELSE  1 END = ?  )  )  AND "PC0".pxObjClass = ?

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)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.

2. I cannot search for requestors to interrupt / stop.

2016-03-16 17:00:18,655 [ http-apr-80-exec-47] [TABTHREAD0] [                    ] [           AES:07.13] (     mapping.xml.XMLParserBase) ERROR drsdevaes01.tmc.rta.nsw.gov.au|xx.xx.xxx.xxx aesdeveloper - Caught exception parsing XML stream

org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Premature end of file.

at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:257)

at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:347)

at com.pega.pegarules.integration.engine.internal.mapping.xml.XMLParserBase.parseDocument(XMLParserBase.java:507)

at com.pega.pegarules.integration.engine.internal.mapping.xml.XMLParserBase.parse(XMLParserBase.java:401)

at com.pega.pegarules.integration.engine.internal.mapping.ParseRuleUtils.invokeXMLParseRule(ParseRuleUtils.java:280)

at com.pega.pegarules.integration.engine.internal.util.PRParseUtils.parseXML(PRParseUtils.java:119)

at com.pegarules.generated.activity.ra_action_requestorlistparseresult_b18e3f76ef6a828f8634b742d2e88269.step2_circum0(ra_action_requestorlistparseresult_b18e3f76ef6a828f8634b742d2e88269.java:212)

at com.pegarules.generated.activity.ra_action_requestorlistparseresult_b18e3f76ef6a828f8634b742d2e88269.perform(ra_action_requestorlistparseresult_b18e3f76ef6a828f8634b742d2e88269.java:72)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10450)

at com.pegarules.generated.activity.ra_action_requestorlistnode_5531620c6d99ca1411217d723fa5275e.step6_circum0(ra_action_requestorlistnode_5531620c6d99ca1411217d723fa5275e.java:605)

at com.pegarules.generated.activity.ra_action_requestorlistnode_5531620c6d99ca1411217d723fa5275e.perform(ra_action_requestorlistnode_5531620c6d99ca1411217d723fa5275e.java:163)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10450)

at com.pegarules.generated.activity.ra_action_getcontentrequestorlistnode_d07823334c828027e58b702af0769804.step3_circum0(ra_action_getcontentrequestorlistnode_d07823334c828027e58b702af0769804.java:306)

at com.pegarules.generated.activity.ra_action_getcontentrequestorlistnode_d07823334c828027e58b702af0769804.perform(ra_action_getcontentrequestorlistnode_d07823334c828027e58b702af0769804.java:103)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pegarules.generated.callContentActivity_071015_d32tLahf1czM7LjWeZnNtA.callContentActivity07_10_15(callContentActivity_071015_d32tLahf1czM7LjWeZnNtA.java:113)

at com.pegarules.generated.callContentActivity_071015_d32tLahf1czM7LjWeZnNtA.invoke(callContentActivity_071015_d32tLahf1czM7LjWeZnNtA.java:71)

at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:133)

at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:8786)

at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)

at com.pegarules.generated.pega_wb_listview.callContentActivity(pega_wb_listview.java:219)

at com.pegarules.generated.activity.ra_action_process_58399066639ad7b778b97fc32691a1a8.step30_circum0(ra_action_process_58399066639ad7b778b97fc32691a1a8.java:3059)

at com.pegarules.generated.activity.ra_action_process_58399066639ad7b778b97fc32691a1a8.perform(ra_action_process_58399066639ad7b778b97fc32691a1a8.java:615)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pegarules.generated.activity.ra_action_showview_35b594c54a8709e1cb73202c8ccb0050.step8_circum0(ra_action_showview_35b594c54a8709e1cb73202c8ccb0050.java:965)

at com.pegarules.generated.activity.ra_action_showview_35b594c54a8709e1cb73202c8ccb0050.perform(ra_action_showview_35b594c54a8709e1cb73202c8ccb0050.java:188)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10450)

at com.pegarules.generated.activity.ra_action_populatenoderequestorscriteria_dbef0d58a86fcf8f51c0a38c318759ae.step2_circum0(ra_action_populatenoderequestorscriteria_dbef0d58a86fcf8f51c0a38c318759ae.java:242)

at com.pegarules.generated.activity.ra_action_populatenoderequestorscriteria_dbef0d58a86fcf8f51c0a38c318759ae.perform(ra_action_populatenoderequestorscriteria_dbef0d58a86fcf8f51c0a38c318759ae.java:86)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pegarules.generated.activity.ra_action_reloadsection_8d636d6ea3d6b9b680f77d0cd1f195dd.step5_circum0(ra_action_reloadsection_8d636d6ea3d6b9b680f77d0cd1f195dd.java:730)

at com.pegarules.generated.activity.ra_action_reloadsection_8d636d6ea3d6b9b680f77d0cd1f195dd.perform(ra_action_reloadsection_8d636d6ea3d6b9b680f77d0cd1f195dd.java:137)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3375)

at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:641)

at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:435)

at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3252)

at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:384)

at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1188)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:926)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:811)

at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:330)

at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:839)

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315)

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263)

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:240)

at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:278)

at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:223)

at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:485)

at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:290)

at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:118)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:744)

2016-03-16 17:00:18,656 [ http-apr-80-exec-47] [TABTHREAD0] [                    ] [           AES:07.13] (    internal.util.PRParseUtils) ERROR drsdevaes01.tmc.rta.nsw.gov.au|XX.XX.XXX.XXX aesdeveloper - XML parsing failed

com.pega.pegarules.pub.PRException: Caught exception parsing XML stream

From: (H97439E655EE645F00DB742F37913EC7F:XX.XX.XXX.XXX)

Any idea of how to get this fixed?

Data Integration
Moderation Team has archived post
Share this page LinkedIn