Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Arjan Maus (ArjanM04)
Achmea

Achmea
NL
ArjanM04 Member since 2014 48 posts
Achmea
Posted: Aug 10, 2016
Last activity: Aug 22, 2016
Posted: 10 Aug 2016 7:56 EDT
Last activity: 22 Aug 2016 9:24 EDT
Closed

AES Error - Error in RDB-Delete PegaAES_Data_Guardrail.Action

Hi,

 

Can anyone help me with this error in our AES logging?

I suppose somewhere a dateformat is set wrong, but where to correct it?

2016-08-10 07:00:02,091 [   WebContainer : 12] [  STANDARD] [                    ] [           AES:07.13] (.PegaAES_Data_Guardrail.Action) ERROR xxxxxxx.unix.corp|xxx.xx.xx.xx|SOAP|PegaAES|Events|logAlert|AACECB7FAE71FFD1021D4F2508D1DCF00  - Error in RDB-Delete
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -180 SQLState: 22007 Message: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
From: (AACECB7FAE71FFD1021D4F2508D1DCF00:PegaAES) 
    SQL: delete from PEGA_DATA.pegaam_guardrail where pxCreateDateTime = ?
    SQL Inserts: <10-Aug-2016>    

***Updated by Moderator: Marissa to remove the Ask the Expert group tag. Apologies this should not have been an end-user option***

To see attachments, please log in.
Dev/Designer Studio

Posted: 8 years ago
Posted: 10 Aug 2016 8:35 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

This error happens when the format of the date time value being set (in this query case for pxCreateDateTime) is invalid. Is it possible to share the complete stack trace? Also, is this a custom query?

To see attachments, please log in.
Posted: 8 years ago
Updated: 8 years ago
Posted: 11 Aug 2016 3:10 EDT
Updated: 11 Aug 2016 12:27 EDT
Arjan Maus (ArjanM04)
Achmea

Achmea
NL

Rajiv,

This is a query out of the Pega Box, complete stack trace underneath.

 

Kind regards,

Arjan

Show More

Rajiv,

This is a query out of the Pega Box, complete stack trace underneath.

 

Kind regards,

Arjan

2016-08-11 07:00:02,774 [   WebContainer : 33] [  STANDARD] [                    ] [           AES:07.13] (l.access.ConnectionManagerImpl) ERROR usa10217.unix.corp|XXX.XXX.XX.XX|SOAP|PegaAES|Events|logAlert|A3648DC7FF9A725F5F46D91DDD9AEAC84  - Not returning connection 11 for database "pegadata" to the pool as it previously encountered the following error
User ID: (unknown)
Last SQL: delete from PEGA_DATA.pegaam_guardrail where pxCreateDateTime = ?
com.ibm.db2.jcc.am.SqlDataException: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
    at com.ibm.db2.jcc.am.ed.a(ed.java:669)
    at com.ibm.db2.jcc.am.ed.a(ed.java:60)
    at com.ibm.db2.jcc.am.ed.a(ed.java:127)
    at com.ibm.db2.jcc.am.oo.b(oo.java:2366)
    at com.ibm.db2.jcc.am.oo.c(oo.java:2349)
    at com.ibm.db2.jcc.t4.ab.l(ab.java:370)
    at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
    at com.ibm.db2.jcc.t4.p.a(p.java:50)
    at com.ibm.db2.jcc.t4.rb.b(rb.java:220)
    at com.ibm.db2.jcc.am.po.qc(po.java:3497)
    at com.ibm.db2.jcc.am.po.b(po.java:4458)
    at com.ibm.db2.jcc.am.po.kc(po.java:2820)
    at com.ibm.db2.jcc.am.po.execute(po.java:2799)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)
    at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6139)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6569)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.deleteRDB(DatabaseImpl.java:5849)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.step4_circum0(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:576)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.perform(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:129)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.step6_circum0(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:1382)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.perform(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:154)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.step4_circum0(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:313)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.perform(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:103)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:461)
    at com.pega.pegarules.integration.engine.internal.services.ServiceAPI.runActivities(ServiceAPI.java:1881)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:385)
    at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1270)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:841)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:331)
    at com.pega.pegarules.integration.engine.internal.services.soap.SOAPService.invoke(SOAPService.java:579)
    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.ejb.EngineBean.invokeEngine(EngineBean.java:225)
    at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245)
    at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
    at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
    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:574)
    at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:374)
    at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:121)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:307)
    at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:562)
    at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:255)
    at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:259)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:919)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
2016-08-11 07:00:02,780 [   WebContainer : 39] [  STANDARD] [                    ] [           AES:07.13] (l.access.ConnectionManagerImpl) ERROR usa10217.unix.corp|XXX.XXX.XX.XX|SOAP|PegaAES|Events|logAlert|A66D9E770C07DE2472DFF6558D61AFDB6  - Not returning connection 7 for database "pegadata" to the pool as it previously encountered the following error
User ID: (unknown)
Last SQL: delete from PEGA_DATA.pegaam_guardrail where pxCreateDateTime = ?
com.ibm.db2.jcc.am.SqlDataException: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
    at com.ibm.db2.jcc.am.ed.a(ed.java:669)
    at com.ibm.db2.jcc.am.ed.a(ed.java:60)
    at com.ibm.db2.jcc.am.ed.a(ed.java:127)
    at com.ibm.db2.jcc.am.oo.b(oo.java:2366)
    at com.ibm.db2.jcc.am.oo.c(oo.java:2349)
    at com.ibm.db2.jcc.t4.ab.l(ab.java:370)
    at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
    at com.ibm.db2.jcc.t4.p.a(p.java:50)
    at com.ibm.db2.jcc.t4.rb.b(rb.java:220)
    at com.ibm.db2.jcc.am.po.qc(po.java:3497)
    at com.ibm.db2.jcc.am.po.b(po.java:4458)
    at com.ibm.db2.jcc.am.po.kc(po.java:2820)
    at com.ibm.db2.jcc.am.po.execute(po.java:2799)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)
    at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6139)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6569)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.deleteRDB(DatabaseImpl.java:5849)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.step4_circum0(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:576)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.perform(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:129)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.step6_circum0(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:1382)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.perform(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:154)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.step4_circum0(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:313)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.perform(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:103)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:461)
    at com.pega.pegarules.integration.engine.internal.services.ServiceAPI.runActivities(ServiceAPI.java:1881)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:385)
    at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1270)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:841)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:331)
    at com.pega.pegarules.integration.engine.internal.services.soap.SOAPService.invoke(SOAPService.java:579)
    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.ejb.EngineBean.invokeEngine(EngineBean.java:225)
    at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245)
    at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
    at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
    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:574)
    at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:374)
    at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:121)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:307)
    at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:562)
    at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:255)
    at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:259)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:919)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:816)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
2016-08-11 07:00:02,781 [   WebContainer : 39] [  STANDARD] [                    ] [           AES:07.13] (.PegaAES_Data_Guardrail.Action) ERROR usa10217.unix.corp|XXX.XX.XX.XX|SOAP|PegaAES|Events|logAlert|A66D9E770C07DE2472DFF6558D61AFDB6  - Error in RDB-Delete
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -180 SQLState: 22007 Message: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
From: (A66D9E770C07DE2472DFF6558D61AFDB6:PegaAES) 
    SQL: delete from PEGA_DATA.pegaam_guardrail where pxCreateDateTime = ?
    SQL Inserts: <11-Aug-2016>    

Caused by SQL Problems.
Problem #1, SQLState 22007, Error code -180: com.ibm.db2.jcc.am.SqlDataException: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
    at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6220)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6569)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.deleteRDB(DatabaseImpl.java:5849)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.step4_circum0(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:576)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.perform(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:129)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.step6_circum0(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:1382)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.perform(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:154)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.step4_circum0(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:313)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.perform(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:103)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:461)
    at com.pega.pegarules.integration.engine.internal.services.ServiceAPI.runActivities(ServiceAPI.java:1881)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:385)
    at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1270)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:841)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:331)
    at com.pega.pegarules.integration.engine.internal.services.soap.SOAPService.invoke(SOAPService.java:579)
    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.ejb.EngineBean.invokeEngine(EngineBean.java:225)
    at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245)
    at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
    at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
    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:574)
    at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:374)
    at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:121)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:307)
    at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:562)
    at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:255)
    at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:259)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:919)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:816)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by: 
com.ibm.db2.jcc.am.SqlDataException: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
    at com.ibm.db2.jcc.am.ed.a(ed.java:669)
    at com.ibm.db2.jcc.am.ed.a(ed.java:60)
    at com.ibm.db2.jcc.am.ed.a(ed.java:127)
    at com.ibm.db2.jcc.am.oo.b(oo.java:2366)
    at com.ibm.db2.jcc.am.oo.c(oo.java:2349)
    at com.ibm.db2.jcc.t4.ab.l(ab.java:370)
    at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
    at com.ibm.db2.jcc.t4.p.a(p.java:50)
    at com.ibm.db2.jcc.t4.rb.b(rb.java:220)
    at com.ibm.db2.jcc.am.po.qc(po.java:3497)
    at com.ibm.db2.jcc.am.po.b(po.java:4458)
    at com.ibm.db2.jcc.am.po.kc(po.java:2820)
    at com.ibm.db2.jcc.am.po.execute(po.java:2799)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)
    at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6139)
    ... 78 more
2016-08-11 07:00:02,784 [   WebContainer : 33] [  STANDARD] [                    ] [           AES:07.13] (.PegaAES_Data_Guardrail.Action) ERROR usa10217.unix.corp|XXX.XX.XX.XX|SOAP|PegaAES|Events|logAlert|A3648DC7FF9A725F5F46D91DDD9AEAC84  - Error in RDB-Delete
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -180 SQLState: 22007 Message: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
From: (A3648DC7FF9A725F5F46D91DDD9AEAC84:PegaAES) 
    SQL: delete from PEGA_DATA.pegaam_guardrail where pxCreateDateTime = ?
    SQL Inserts: <11-Aug-2016>    

Caused by SQL Problems.
Problem #1, SQLState 22007, Error code -180: com.ibm.db2.jcc.am.SqlDataException: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
    at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6220)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6569)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.deleteRDB(DatabaseImpl.java:5849)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.step4_circum0(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:576)
    at com.pegarules.generated.activity.ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.perform(ra_action_parseguardraildata_d3214a783cf31dd8dbeda2e06217b7da.java:129)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.step6_circum0(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:1382)
    at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.perform(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:154)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.step4_circum0(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:313)
    at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.perform(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:103)
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:461)
    at com.pega.pegarules.integration.engine.internal.services.ServiceAPI.runActivities(ServiceAPI.java:1881)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:385)
    at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1270)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:841)
    at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:331)
    at com.pega.pegarules.integration.engine.internal.services.soap.SOAPService.invoke(SOAPService.java:579)
    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.ejb.EngineBean.invokeEngine(EngineBean.java:225)
    at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245)
    at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
    at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
    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:574)
    at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:374)
    at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
    at java.lang.reflect.Method.invoke(Method.java:620)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:121)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:307)
    at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:562)
    at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:255)
    at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:259)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:919)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by: 
com.ibm.db2.jcc.am.SqlDataException: The syntax of the string representation of a datetime value is incorrect.. SQLCODE=-180, SQLSTATE=22007, DRIVER=4.14.113
    at com.ibm.db2.jcc.am.ed.a(ed.java:669)
    at com.ibm.db2.jcc.am.ed.a(ed.java:60)
    at com.ibm.db2.jcc.am.ed.a(ed.java:127)
    at com.ibm.db2.jcc.am.oo.b(oo.java:2366)
    at com.ibm.db2.jcc.am.oo.c(oo.java:2349)
    at com.ibm.db2.jcc.t4.ab.l(ab.java:370)
    at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
    at com.ibm.db2.jcc.t4.p.a(p.java:50)
    at com.ibm.db2.jcc.t4.rb.b(rb.java:220)
    at com.ibm.db2.jcc.am.po.qc(po.java:3497)
    at com.ibm.db2.jcc.am.po.b(po.java:4458)
    at com.ibm.db2.jcc.am.po.kc(po.java:2820)
    at com.ibm.db2.jcc.am.po.execute(po.java:2799)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)
    at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6139)
    ... 78 more


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 11 Aug 2016 3:34 EDT
Arjan Maus (ArjanM04)
Achmea

Achmea
NL

PEGA 7.1.8

AES 07.13

Might it be possible we have our AESRemoteuser running with the wrong locale?

I discovered that te locale within this user was empty

To see attachments, please log in.
Posted: 8 years ago
Posted: 11 Aug 2016 4:51 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

Possibly. Do you know in which locale your node is running in?

Also, pxCreateDateTime contains both date and time (TIMESTAMP column) but the SQL insert value only shows a Date and not date and time. That might also be the reason for this error.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice