Database error while starting BusinessEvents stack in Silver Fabric in TA mode

Database error while starting BusinessEvents stack in Silver Fabric in TA mode

book

Article ID: KB0071107

calendar_today

Updated On:

Products Versions
TIBCO Silver Fabric -

Description

The engine log file has the below stack trace:
=====================
09/11/23 04:51:25.417 INFO: [Statistics] Stopping statistics collection for "TIBCO BusinessEvents container"
09/11/23 04:51:25.417 INFO: [BEContainer] Shutting down "TIBCO BusinessEvents container"...
09/11/23 04:51:25.417 INFO: [BEContainer] TIBCO BusinessEvents container: uninstalling "AllState BusinessEvents"
09/11/23 04:51:25.418 INFO: [CommonSFContainer] Begin calling com.tibco.sf.container.tra.action.ShutdownAction.do
09/11/23 04:51:25.418 INFO: [BEContainer] Enter TraContainer DoShutdown
09/11/23 04:51:25.418 INFO: [BEContainer] Enter TraContainer doShutdownAdditionalActions
09/11/23 04:51:25.418 INFO: [BEContainer] Acquire Global Lock for Domain -- YourDomainName...
09/11/23 04:51:25.423 INFO: [BEContainer] Acquired Global Lock for Domain -- YourDomainName
09/11/23 04:51:25.459 INFO: [TraCustomizedClassLoader] Directory ./cache/expansions/b0f0c867de165a511210ad0d1af6e6792316b858/ehcache do not exist. Won't use it in the customclassloader SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/qa/SF_engine_603/DSEngine/./cache/expansions/46f7363c7e45f017419062cddab23bddb2902c2a/tpcl/5.12/lib/slf4j-simple-1.7.31.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/qa/SF_engine_603/DSEngine/./cache/expansions/46f7363c7e45f017419062cddab23bddb2902c2a/tpcl/5.12/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/qa/SF_engine_603/DSEngine/work/na1devdsyyas14-2/tibco/tpcl/5.12/lib/slf4j-simple-1.7.31.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/qa/SF_engine_603/DSEngine/work/na1devdsyyas14-2/tibco/tpcl/5.12/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.SimpleLoggerFactory] [DefaultPool-0: ] INFO com.tibco.security.impl.np.SecurityVendor - Initializing JSSE's crypto provider class com.sun.net.ssl.internal.ssl.Provider in default mode
09/11/23 04:51:27.586 WARNING: [ExtensionWrapper] java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.tibco.sf.container.tra.extension.base.BaseReflection.newInstance(BaseReflection.java:12) at com.tibco.sf.container.tra.extension.base.WrapperBase.invoke(WrapperBase.java:67) at com.tibco.sf.container.tra.extension.ExtensionWrapper.uninstallApplications(ExtensionWrapper.java:272) at com.tibco.sf.container.tra.action.ShutdownAction.doShutdownAdditionalActions(ShutdownAction.java:64) at com.tibco.sf.container.tra.action.ShutdownAction.doShutdown(ShutdownAction.java:30) at com.tibco.sf.container.tra.action.ShutdownAction.d0(ShutdownAction.java:19) at com.tibco.silver.silverfabric.container.action.LoggingAction.d0(LoggingAction.java:24) at com.tibco.silver.silverfabric.container.lifecycle.LifeCyclePhase.callActions(LifeCyclePhase.java:28) at com.tibco.silver.silverfabric.container.CommonSFContainer.doShutdown(CommonSFContainer.java:1332) at com.tibco.sf.container.tra.TraContainer.doShutdown(TraContainer.java:279) at com.datasynapse.fabric.container.ContainerScriptSupport.doShutdown(ContainerScriptSupport.java:352) at com.datasynapse.fabric.container.AbstractContainer.shutdown(AbstractContainer.java:1266) at com.datasynapse.fabric.engine.domain.GridLibDomainManager.shutdownActive(GridLibDomainManager.java:325) at com.datasynapse.fabric.engine.plugins.DomainManagerPlugin.deactivate(DomainManagerPlugin.java:921) at com.datasynapse.fabric.engine.plugins.DomainManagerPlugin.activate(DomainManagerPlugin.java:833) at com.datasynapse.fabric.engine.plugins.DomainManagerPlugin.activate(DomainManagerPlugin.java:564) at com.datasynapse.fabric.engine.plugins.DomainManagerPlugin$ICActivate.run(DomainManagerPlugin.java:1984) at com.datasynapse.fabric.engine.plugins.DomainManagerPlugin$ICActivationQueueHandler.doRun(DomainManagerPlugin.java:2037) at com.datasynapse.fabric.util.StoppableRunnable.run(StoppableRunnable.java:21) at com.datasynapse.commons.sync.threading.ReusableThreadPool$InternalThread.run(ReusableThreadPool.java:395)
Caused by: java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.tibco.sf.container.tra.extension.base.BaseReflection.invokeStaticMethod(BaseReflection.java:31) at com.tibco.sf.container.tra.extension.pofproxy.MutableAdminDomain.getMutableDomainByName(MutableAdminDomain.java:30) at com.tibco.sf.container.tra.extension.pofproxy.MutableAdminDomain.getMutableAdminDomainInstance(MutableAdminDomain.java:25) at com.tibco.sf.container.tra.extension.base.ExtensionBase.<init>(ExtensionBase.java:45) at com.tibco.sf.container.tra.extension.base.ExtensionBase.<init>(ExtensionBase.java:33) at com.tibco.sf.container.tra.extension.AppManageExtension.<init>(AppManageExtension.java:56) ... 24 more
Caused by: com.tibco.pof.entity.EntityStoreException: java.sql.SQLException: Could not commit with auto-commit set on
at com.tibco.pof.entitystore.db.DBEntityStore.init(DBEntityStore.java:605) at com.tibco.pof.entitystore.EntityStoreManager.getEntityStore2(EntityStoreManager.java:221) at com.tibco.pof.entitystore.EntityStoreManager.getEntityStore(EntityStoreManager.java:202) at com.tibco.pof.entitystore.EntityStoreManager.getReadOnlyEntityDomain(EntityStoreManager.java:333) at com.tibco.pof.entitystore.EntityStoreManager.getReadOnlyEntityDomain(EntityStoreManager.java:327) at com.tibco.pof.entitystore.EntityStoreManager.getReadOnlyEntityDomain(EntityStoreManager.java:320) at com.tibco.pof.admindomain.AdministrationDomain.instance(AdministrationDomain.java:187) at com.tibco.pof.admindomain.AdministrationDomain.getMutableDomainByName(AdministrationDomain.java:217) ... 34 more
Caused by: java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2025) at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2061) at com.tibco.runtime.pool.jdbc.JdbcConnection.commit(JdbcConnection.java:218) at com.tibco.pof.entitystore.db.PofInitializationDB.createInitTables(PofInitializationDB.java:46) at com.tibco.pof.entitystore.db.DBEntityStore.init(DBEntityStore.java:600) ... 41 more
=====================
Attaching complete engine log file for reference

Issue/Introduction

When we start the BusinessEvents stack in TA mode with oracle database configured in Administrator component then we are getting errors related to database

Resolution

Update the below property under JVM options in engine configuration and restart the stack
==> -Doracle.jdbc.autoCommitSpecCompliant=false

Additional Information

https://stackoverflow.com/questions/23953534/java-sql-sqlexception-could-not-commit-with-auto-commit-set-on-at-oracle-jdbc-d

Attachments

Database error while starting BusinessEvents stack in Silver Fabric in TA mode get_app