Batch risk analysis job not running in parllel in ...

Former Member · ‎11-29-2010

Hi,

When scheduled full batch risk analysis job for user, it has occupied and running only in server 0 node but server 1 node did not run the job in parallel. server node 1 has started the job and ended with error(below was error details)

The job was still running in server node 0 and processing the user data from backend system. Also this job we are running was for 2nd system, job for 1st system which we completed a month back have run in parallel without any problems.

Please share your ideas what went wrong and how to rectify so that this will not happen for our next system.

error from server node 1

FINEST: Analysis Daemon started background Job ID:41 (Daemon ID [8953851]/usr/sap/AC1/JC00/j2ee/cluster/server1/. Thread ID 0)

Nov 26, 2010 11:56:04 AM com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob scheduleJob

INFO: -

Scheduling Job =>41----

Nov 26, 2010 11:56:04 AM com.virsa.cc.xsys.bg.BgJob run

INFO: --- Starting Job ID:41 (RISK_ANALYSIS_BATCH) - #USER Batch Risk Analysis# QAS

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.util.Lock lock

FINEST: Lock:1007

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.bg.BgJob setStatus

INFO: Job ID: 41 Status: Running

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.bg.BgJob findJobHistory

FINEST: --- @@@@@@@@@@@ Find the Job History -

1

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.util.Lock unlock

FINEST: Unlock:1007

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis performBatchSyncAndAnalysis

INFO: --- Batch Sync/Analysis/Mgmt Report started ---

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis performBatchRiskAnalysis

INFO: -

System to Analyze =>QAS -

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis performBatchRiskAnalysis

INFO: --- BKG User Permission Analysis (System: QAS) started ---

Nov 26, 2010 11:56:10 AM com.virsa.cc.xsys.util.Lock lock

SEVERE: Exception in Lock.lock():Cannot lock at least one of the 1 locks for the owner 2010112611561002800000usalpd63.....................8953851; it is used by another owner. The lock collision occurred with user . com.sap.engine.frame.core.locking.LockException: Cannot lock at least one of the 1 locks for the owner 2010112611561002800000usalpd63.....................8953851; it is used by another owner. The lock collision occurred with user .

at com.sap.engine.core.locking.impl3.LockingManagerImpl.lockInternal(LockingManagerImpl.java:312)

at com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(AbstractLockingManagerImpl.java:469)

at com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(AbstractLockingManagerImpl.java:489)

at com.sap.engine.services.applocking.AbstractBaseLocking.lockInternal(AbstractBaseLocking.java:188)

at com.sap.engine.services.applocking.LogicalLockingImpl.lock(LogicalLockingImpl.java:68)

at com.sap.engine.services.applocking.NamespaceLogicalLockingImpl.lock(NamespaceLogicalLockingImpl.java:57)

at com.sap.engine.services.applocking.LogicalLocking_Stub.lock(LogicalLocking_Stub.java:246)

at com.virsa.cc.xsys.util.Lock.lock(Lock.java:165)

at com.virsa.cc.multi.node.dao.NodeDAO.getTableLock(NodeDAO.java:396)

at com.virsa.cc.multi.node.dao.NodeDAO.getTableLock(NodeDAO.java:359)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.performBatchRiskAnalysis(BatchRiskAnalysis.java:981)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.performBatchSyncAndAnalysis(BatchRiskAnalysis.java:1347)

at com.virsa.cc.xsys.bg.BgJob.runJob(BgJob.java:559)

at com.virsa.cc.xsys.bg.BgJob.run(BgJob.java:362)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.scheduleJob(AnalysisDaemonBgJob.java:375)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.start(AnalysisDaemonBgJob.java:92)

at com.virsa.cc.comp.BgJobInvokerView.wdDoModifyView(BgJobInvokerView.java:444)

at com.virsa.cc.comp.wdp.InternalBgJobInvokerView.wdDoModifyView(InternalBgJobInvokerView.java:1236)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.doModifyView(DelegatingView.java:78)

at com.sap.tc.webdynpro.progmodel.view.View.modifyView(View.java:337)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.doModifyView(ClientComponent.java:481)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doModifyView(WindowPhaseModel.java:551)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:148)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:333)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:741)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:694)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doGet(DispatcherServlet.java:46)

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

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:386)

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

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

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

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

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

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:104)

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

-

predecessor system -

com.sap.engine.frame.core.locking.LockException: Cannot lock at least one of the 1 locks for the owner 2010112611561002800000usalpd63.....................8953851; it is used by another owner. The lock collision occurred with user .