Process not started and workitems not generated

Topics related to the standard LSPS process application.
Forum rules
Make sure every topic contains information about your LSPS version and if relevant also your server OS, client OS, database name and version, and application server name and version.
habeeb
 
Posts: 16
Joined: Mon Aug 22, 2016 3:30 pm

Process not started and workitems not generated

Wed Oct 12, 2016 3:41 pm

we created launches(projects) in launchIT application we noticed process is not initiated( workitem not generated) for some launches.And all these launches are in 'Pending Submission' status. we have executed the query DB and found that, in the "Entity" table the model instance id is showcased as -1 and we found lot of JBA exceptions as well as timeout exception. Please refer below exception details. Let us know any input on why this issue is occurring.

ERROR [org.jboss.as.ejb3] (EJB default - 2) JBAS014122: Error during retrying timeout for timer: [id=169038e6-8eb0-4752-8891-21298f26edf9 timedObjectId=launchit-ear-5.0.3.lsps-engine- exec.Living Systems Process Suite.ProcessAgentImpl auto-timer?:false persistent?:true timerService=org.jboss.as.ejb3.timerservice.TimerServiceImpl@2fba55f8 initialExpiration=Tue Oct 11 00:00:30 EDT 2016 intervalDuration(in milli sec)=0 nextExpiration=null timerState=RETRY_TIMEOUT info=118671402]: javax.ejb.EJBTransactionRolledbackException: Transaction rolled back atorg.jboss.as.ejb3.tx.CMTTxInterceptor.handleEndTransactionException(CMTTxInterceptor.java:137) [jboss-as-ejb3-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] at
JBAS014134: EJB Invocation failed on component JpaTimerNotificationDao for method public abstract com.whitestein.lsps.common.EntityWithIdcom.whitestein.lsps.common.BasicReadDao.findById(java.lang.Object): javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.GenericJDBCException: could not inspect JDBC autocommit mode at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:160) [jboss-as-ejb3-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] atorg.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:259) [jboss-as-ejb3-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] atorg.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:332)

WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) SQL Error: 1206, SQLState: S00055 07:47:38,856 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction. 07:47:38,856 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) SQL Error: 0, SQLState: null 07:47:38,856 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) Transaction cannot proceed STATUS_ROLLING_BACK 07:47:38,856 WARN[org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorTrackingImpl] (Transaction Reaper Worker 850) HHH000451: Transaction afterCompletion called by a background thread; delaying afterCompletion processing until the original thread can handle it. [status=4] 07:47:38,856 ERROR [org.jboss.as.ejb3] (EJB default - 2) JBAS014268: Failure in caller transaction.: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not inspect JDBC autocommit mode atorg.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager-4.2.19.Final.jar:4.2.19.Final] atorg.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:838) [hibernate-entitymanager-4.2.19.Final.ja

habeeb
 
Posts: 16
Joined: Mon Aug 22, 2016 3:30 pm

Re: Process not started and workitems not generated

Tue Oct 18, 2016 11:18 pm

Environment: Noticed in UAT and Production.
Steps: Multi user testing with 5 users in UAT general steps involves creating launches with 20+ products. In production observer during start of the week where traffic little high compare to rest of the week.
Logs : more logs will be attached soon.

Roman Kubascik
 
Posts: 57
Joined: Thu Apr 16, 2015 9:05 am

Re: Process not started and workitems not generated

Mon Oct 24, 2016 4:29 pm

Problem with the MSDTC (Microsoft Distributed Transaction Coordinator) could be analyzed with the tools from microsoft https://blogs.msdn.microsoft.com/florin ... ty-issues/

Return to Process application

Who is online

Users browsing this forum: No registered users and 1 guest