cancel
Showing results for 
Search instead for 
Did you mean: 

no more application threads

jochen_spieth
Participant
0 Kudos

Hello everybody,

from time to time I am having a problem with my application threads in my NW7 SPS10 portal.

I have already checked some other forum entries, and found some hints what I can check, but maybe someone of you has observed something similar and already has a solution.

My application threads all get kind of locked, and they all work with the same application and are waiting for monitor entry.

When now clicking through the threaddump viewer, I can identify this one as the one which is locking them (almost) all:

"SAPEngine_Application_Thread[impl:3]_297" prio=10 tid=800000010c3c22e0 nid=14058 lwp_id=1480608 runnable [800003ff07988000..800003ff0797f860]

at java.net.SocketInputStream.socketRead0(Native Method)

at java.net.SocketInputStream.read(SocketInputStream.java:134)

at oracle.net.ns.Packet.receive(Unknown Source)

at oracle.net.ns.DataPacket.receive(Unknown Source)

at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)

at oracle.net.ns.NetInputStream.read(Unknown Source)

at oracle.net.ns.NetInputStream.read(Unknown Source)

at oracle.net.ns.NetInputStream.read(Unknown Source)

at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1103)

at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1074)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:479)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:218)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:969)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10689)

- locked <800003ff818a4c88> (a oracle.jdbc.driver.T4CPreparedStatement)

- locked <800003ff816ae468> (a oracle.jdbc.driver.T4CConnection)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeBatch(BasicPreparedStatement.java:263)

at com.sap.sql.jdbc.oracle.Oracle10gPreparedStatement.executeBatch(Oracle10gPreparedStatement.java:100)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeBatch(DirectPreparedStatement.java:1129)

at com.sap.sql.jdbc.common.CommonPreparedStatement.executeBatch(CommonPreparedStatement.java:991)

at com.sap.engine.services.dbpool.wrappers.StatementWrapper.executeBatch(StatementWrapper.java:270)

at com.sap.security.core.persistence.datasource.imp.DataBasePersistence.updatePrincipalDatabag(DataBasePersistence.java:6187)

at com.sap.security.core.persistence.datasource.imp.DataBaseDataSourceTransaction.updatePrincipalDatabag(DataBaseDataSourceTransaction.java:154)

at com.sap.security.core.persistence.imp.DistributedTransaction.doCommit(DistributedTransaction.java:2205)

at com.sap.security.core.persistence.imp.DistributedTransaction.beforeCompletion(DistributedTransaction.java:813)

at com.sap.engine.services.ts.jta.impl.TransactionImpl.commit(TransactionImpl.java:226)

- locked <800003ff30ea1138> (a com.sap.engine.services.ts.jta.impl.TransactionImpl)

at com.sap.engine.services.ts.jta.impl.TransactionManagerImpl.commit(TransactionManagerImpl.java:319)

at com.sap.engine.services.ts.transaction.TxManager.commitLevel(TxManager.java:575)

at com.sap.engine.services.ts.transaction.TxManagerImpl.commitLevel(TxManagerImpl.java:63)

at com.sap.transaction.TxManager.commitLevel(TxManager.java:237)

at com.sap.security.core.persistence.imp.DistributedTransaction.commit(DistributedTransaction.java:2643)

at com.sap.security.core.imp.UserMaint.commit(UserMaint.java:324)

at com.festo.portal.sap40.y.ep.uarf.services.UarfUser.save(UarfUser.java:286)

at com.festo.portal.sap40.y.ep.services.UARFbase.loginSuccesFull(UARFbase.java:1968)

- locked <800003ff4a01f780> (a com.festo.portal.sap40.y.ep.services.UARFbase)

at com.festo.portal.sap40.y.ep.uarf.services.TUarfUtils.loginSuccesFull(TUarfUtils.java:86)

at com.festo.portal.sap40.y.ep.uarf.interfaces.UarfUtils.loginSuccesFull(UarfUtils.java:47)

at com.festo.authservice.authmanager.portal.AuthManagerPortalComponent.proceedLogin(AuthManagerPortalComponent.java:929)

at com.festo.authservice.authmanager.portal.AuthManagerPortalComponent.doContentLogin(AuthManagerPortalComponent.java:660)

at com.festo.authservice.authmanager.portal.AuthManagerPortalComponent.doContentComponent(AuthManagerPortalComponent.java:408)

at com.festo.authservice.authmanager.portal.AuthManagerPortalComponent.doContent(AuthManagerPortalComponent.java:103)

at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209)

at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114)

at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)

at com.sapportals.portal.prt.component.PortalComponentRequest.dispatchRequest(PortalComponentRequest.java:1023)

at com.sapportals.portal.prt.servlets_jsp.server.jsp.response.JSPResponse.include(JSPResponse.java:136)

at com.festo.portal.sap40.y.ep.fr.framework2008.navigation.Framework.includeContent(Framework.java:130)

at jsp._sapportalsjsp_framework.subDoContent(_sapportalsjsp_framework.java:606)

at jsp._sapportalsjsp_framework.doContent(_sapportalsjsp_framework.java:66)

at jsp._sapportalsjsp_framework.service(_sapportalsjsp_framework.java:46)

at com.sapportals.portal.prt.core.broker.PortalComponentItemFacade.service(PortalComponentItemFacade.java:360)

at com.sapportals.portal.prt.core.broker.PortalComponentItem.service(PortalComponentItem.java:934)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:435)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:527)

at com.sapportals.portal.prt.component.AbstractComponentResponse.include(AbstractComponentResponse.java:89)

at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:232)

at com.festo.portal.sap40.y.ep.fr.framework2008.navigation.Framework.doContent(Framework.java:103)

at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209)

at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114)

at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)

at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:215)

at com.sapportals.portal.prt.pom.PortalNode.service(PortalNode.java:645)

at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)

at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)

at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:753)

at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:240)

at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:522)

at java.security.AccessController.doPrivileged(Native Method)

at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:405)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:321)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:427)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:358)

at com.festo.portal.sap40.y.ep.fr.framework2008.navigation.FrameworkLauncher.doOnNodeReady(FrameworkLauncher.java:172)

at com.sapportals.portal.prt.component.AbstractPortalComponent.handleEvent(AbstractPortalComponent.java:388)

at com.sapportals.portal.prt.pom.ComponentNode.handleEvent(ComponentNode.java:252)

at com.sapportals.portal.prt.pom.PortalNode.fireEventOnNode(PortalNode.java:368)

at com.sapportals.portal.prt.pom.AbstractNode.addChildNode(AbstractNode.java:340)

at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:642)

at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:240)

at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:522)

at java.security.AccessController.doPrivileged(Native Method)

at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:405)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:321)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:427)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:358)

at com.festo.portal.sap40.y.ep.fr.framework2008.navigation.FrameworkLauncher.doOnNodeReady(FrameworkLauncher.java:116)

at com.sapportals.portal.prt.component.AbstractPortalComponent.handleEvent(AbstractPortalComponent.java:388)

at com.sapportals.portal.prt.pom.ComponentNode.handleEvent(ComponentNode.java:252)

at com.sapportals.portal.prt.pom.PortalNode.fireEventOnNode(PortalNode.java:368)

at com.sapportals.portal.prt.pom.AbstractNode.addChildNode(AbstractNode.java:340)

at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:642)

at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:240)

at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:522)

at java.security.AccessController.doPrivileged(Native Method)

at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:405)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:174)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

This application blabla uarf.services is more or less a little extention to UME which is writing some statistical data into tables, which are accessed with a jdbc connection pool.

Anyone seen anything similar yet, or any ideas?

Thanks a lot and cheers

Jochen

Edited by: Jochen Spieth on Sep 3, 2008 10:19 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

jochen_spieth
Participant
0 Kudos

as already mentioned: the database had exclusive lock in some custom code

Former Member
0 Kudos

Hi ,

Try to see if Note #1003198 Can help you . There are some issues with Oracle jdbc driver you should

check.

Regards,

Gilad.

jochen_spieth
Participant
0 Kudos

Hi Gilad,

thnaks a lot for the hint. Unfortunately; i already use the 10.2.0.4 driver

Regards,

Jochen

jochen_spieth
Participant
0 Kudos

Hi,

just in case someone has something similar:

Check for locks in your Database