1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Throwing Error while deploying and activating Oracle BPM on WebLogic AS 11g

Discussion in 'Oracle Webcenter Suite (formerly Oracle ECM)' started by pravin_lkr, Sep 23, 2009.

  1. pravin_lkr

    pravin_lkr Guest

    Hi,

    We are getting the following error while deploying and activating the BPMProcessEngine.ear on WebLogic Application Server 11g:

    java.sql.SQLException: [OWLS][SQLServer JDBC Driver][SQLServer]Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. ErrorCode=8525 SQLState=HY000
    java.sql.SQLException: [OWLS][SQLServer JDBC Driver][SQLServer]Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.

    We have to prepare an environment for Oracle BPM 10g Enterprise for WebLogic on Windows server. The environment details are given below:
    • Windows Server 2003 R2 (64bit)
    • WebLogic Server 11g
    • Oracle BPM 10g
    • SQL Server Database 2005 on Windows Server 2003

    We have created the datasource using Oracle MS SQL Server Driver (Type 4 XA). The support for distributed transactions is enabled at database. The datasource connection is also tested successfully from WLS console.
    But when we are deploying and activating the BPMProcessEngine.ear it throwing the above mentioned error. Any help or suggestions on this would be appreciated.

    Thanks.

    The Log Stack Trace:
    ===========================================================

    spy(2009/09/23 11:44:16.406)>> PreparedStatement[74].executeQuery()
    spy(2009/09/23 11:44:16.406)>> java.sql.SQLException: [OWLS][SQLServer JDBC Driver][SQLServer]Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. ErrorCode=8525 SQLState=HY000
    java.sql.SQLException: [OWLS][SQLServer JDBC Driver][SQLServer]Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
    at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
    at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
    at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
    at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
    at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
    at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
    at weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
    at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
    at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
    at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
    at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
    at weblogic.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
    at weblogic.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
    at weblogic.jdbcx.base.BasePreparedStatementWrapper.executeQuery(Unknown Source)
    at weblogic.jdbcspy.SpyPreparedStatement.executeQuery(Unknown Source)
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
    at fuego.jdbc.FaultTolerantPreparedStatement.executeQuery(FaultTolerantPreparedStatement.java:598)
    at fuego.directory.provider.jdbc.JDBCPersistenceManager.createResultSet(JDBCPersistenceManager.java:1126)
    at fuego.directory.provider.jdbc.JDBCPersistenceManager.createResultSet(JDBCPersistenceManager.java:1100)
    at fuego.directory.provider.jdbc.JDBCPersistenceManager.fetch(JDBCPersistenceManager.java:253)
    at fuego.directory.provider.jdbc.JDBCPersistenceManager.fetch(JDBCPersistenceManager.java:236)
    at fuego.directory.provider.jdbc.JDBCGroupAccessor.fetchGroup(JDBCGroupAccessor.java:452)
    at fuego.directory.provider.jdbc.JDBCGroupAccessor.fetchGroup(JDBCGroupAccessor.java:239)
    at fuego.directory.hybrid.jdbc.DelegatorFuegoGroupAccessor.reloadData(DelegatorFuegoGroupAccessor.java:89)
    at fuego.directory.hybrid.jdbc.DelegatorFuegoGroupAccessor.reloadData(DelegatorFuegoGroupAccessor.java:24)
    at fuego.directory.hybrid.HybridGroupAccessor.refreshGroup(HybridGroupAccessor.java:208)
    at sun.reflect.GeneratedMethodAccessor402.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at fuego.directory.provider.DirectorySessionImpl$AccessorProxy.invoke(DirectorySessionImpl.java:756)
    at $Proxy87.refreshGroup(Unknown Source)
    at fuego.directory.DirOrganizationalGroup.refresh(DirOrganizationalGroup.java:764)
    at fuego.metadata.Group.refreshGroup(Group.java:174)
    at fuego.metadata.Group.getAssignedGroups(Group.java:109)
    at fuego.metadata.ParticipantManager.addNestedGroups(ParticipantManager.java:552)
    at fuego.metadata.ParticipantManager.buildCompleteRoleAssignments(ParticipantManager.java:489)
    at fuego.metadata.Participant.buildCompleteRoleAssignments(Participant.java:429)
    at fuego.metadata.Participant.updateMembers(Participant.java:389)
    at fuego.metadata.Participant.<init>(Participant.java:84)
    at fuego.metadata.ParticipantManager.initialize(ParticipantManager.java:345)
    at fuego.server.service.ParticipantService.loadMetadata(ParticipantService.java:170)
    at fuego.server.service.ParticipantService.start(ParticipantService.java:182)
    at fuego.server.service.AbstractService.changeRunLevel(AbstractService.java:99)
    at fuego.server.service.AbstractService.setRunLevel(AbstractService.java:52)
    at fuego.ejbengine.service.EJBParticipantService$InitializeItem.execute(EJBParticipantService.java:60)
    at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:304)
    at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:470)
    at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:551)
    at fuego.transaction.TransactionAction.start(TransactionAction.java:212)
    at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:123)
    at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:79)
    at fuego.server.execution.DefaultEngineExecution.executeWithoutComponentImmediate(DefaultEngineExecution.java:185)
    at fuego.server.execution.EngineExecution.executeWithoutComponentImmediate(EngineExecution.java:86)
    at fuego.ejbengine.service.EJBParticipantService.initializeImpl(EJBParticipantService.java:44)
    at fuego.ejbengine.service.EJBParticipantService.initialize(EJBParticipantService.java:31)
    at fuego.ejbengine.DistributableObjectFactory.initializeParticipantService(DistributableObjectFactory.java:88)
    at fuego.ejbengine.Engine.startServices(Engine.java:412)
    at fuego.ejbengine.Engine.start(Engine.java:126)
    at fuego.ejbengine.servlet.SchedulerServlet.init(SchedulerServlet.java:95)
    at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
    at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
    at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)
    at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:521)
    at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1913)
    at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1887)
    at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1805)
    at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3041)
    at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1374)
    at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:452)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
    at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
    at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
    at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
    at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
    at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
    at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:629)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
    at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:206)
    at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:53)
    at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
    at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
    at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:140)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:106)
    at weblogic.deploy.internal.targetserver.operations.StartOperation.doCommit(StartOperation.java:143)
    at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
    at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
    at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)