Exception "Conversion failed when converting datetime from character string" found in BPM Directory (Doc ID 1063633.1)

Last updated on MARCH 11, 2015

Applies to:

Oracle Business Process Management Suite - Version 10.3 to 10.3
Information in this document applies to any platform.
***Checked for relevance on 30-May-2012***

Symptoms

In the Workspace log you see the following error:

[<S> 1202 18:53:53.385] Main (<2> Fuego PAPI News Listener [testengine] Service [TEST_DIR/2009-12-02 14:41:52+02:00:32495559:6680250]): Exception [javax.naming.OperationNotSupportedException: [LDAP: error code 53 - java.sql.SQLException: [plumtree][SQLServer JDBC Driver][SQLServer]Conversion failed when converting datetime from character string.]; remaining name ''].
Caused by: [LDAP: error code 53 - java.sql.SQLException: [plumtree][SQLServer JDBC Driver][SQLServer]Conversion failed when converting datetime from character string.]
fuego.directory.DirectoryRuntimeException: Exception [javax.naming.OperationNotSupportedException: [LDAP: error code 53 - java.sql.SQLException: [plumtree][SQLServer JDBC Driver][SQLServer]Conversion failed when converting datetime from character string.]; remaining name ''].

at fuego.directory.DirectoryRuntimeException.wrapException(DirectoryRuntimeException.java:85)
at fuego.directory.hybrid.ldap.JNDIQueryExecutor.select(JNDIQueryExecutor.java:229)
at fuego.directory.hybrid.ldap.JNDIQueryExecutor.selectAllFromView(JNDIQueryExecutor.java:85)
at fuego.directory.hybrid.ldap.JNDIQueryExecutor.selectAllFromView(JNDIQueryExecutor.java:65)
at fuego.directory.hybrid.ldap.Repository.selectAllFromView(Repository.java:54)
at fuego.directory.hybrid.ldap.LDAPPollingEventGenerator.buildCurrentProxies(LDAPPollingEventGenerator.java:98)
at fuego.directory.provider.notifiers.BasePollingEventGenerator.generateEvents(BasePollingEventGenerator.java:41)
at fuego.directory.hybrid.HybridMultipleEventGenerator.generateEvents(HybridMultipleEventGenerator.java:43)
at fuego.directory.provider.notifiers.DirectoryNotifier.notifyChanges(DirectoryNotifier.java:403)
at fuego.papi.impl.EngineNewsListener.processEngineNews(EngineNewsListener.java:318)
at fuego.papi.impl.EngineAccess.processEngineNews(EngineAccess.java:164)
at fuego.papi.impl.j2ee.J2EEEngineAccessImpl.access$300(J2EEEngineAccessImpl.java:68)
at fuego.papi.impl.j2ee.J2EEEngineAccessImpl$TopicSubscriberImpl.onMessage(J2EEEngineAccessImpl.java:545)
at fuego.papi.impl.j2ee.J2EEEngineAccessImpl$TopicSubscriberImpl.dispatchMessages(J2EEEngineAccessImpl.java:741)
at fuego.papi.impl.j2ee.J2EEEngineAccessImpl$TopicSubscriberImpl.run(J2EEEngineAccessImpl.java:592)
Caused by: javax.naming.OperationNotSupportedException: [LDAP: error code 53 - java.sql.SQLException: [plumtree][SQLServer JDBC Driver][SQLServer]Conversion failed when converting datetime from character string.]; remaining name ''
at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3078)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2951)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2758)
at com.sun.jndi.ldap.LdapCtx.searchAux(LdapCtx.java:1812)
at com.sun.jndi.ldap.LdapCtx.c_search(LdapCtx.java:1735)
at com.sun.jndi.toolkit.ctx.ComponentDirContext.p_search(ComponentDirContext.java:368)
at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.search(PartialCompositeDirContext.java:338)
at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.search(PartialCompositeDirContext.java:321)
at javax.naming.directory.InitialDirContext.search(InitialDirContext.java:248)
at fuego.jndi.FaultTolerantDirContext.search(FaultTolerantDirContext.java:867)
at fuego.directory.hybrid.ldap.JNDIQueryExecutor.select(JNDIQueryExecutor.java:207)
... 13 more


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms