Project and Portfolio Management Practitioners Forum
cancel

Error while tranfering the msp workplan to the ppm

Highlighted
sevcan
Super Contributor.

Error while tranfering the msp workplan to the ppm

Hey all,

 

We are getting an error while tranfering the work plan from msp.

 

Here is the log details.

 

 Filtered Out 51 Stack Trace Lines.
ERROR JSESSIONID=DA0D3AD8C68177FEDFB2B3DC9C90226F.HPPPM,USERNAME=vb52561:http-0.0.0.0-80-Processor50:org.apache.jsp.arch.Error_jsp:2013/07/23-08:58:26.515 EEST:
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.mercury.dashboard.model.module.UserModulePage#45056185]
 at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1765)
 at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2407)
 at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
 at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
 at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
 at com.mercury.dashboard.arch.hibernate.SessionWrapper.commitTrasaction(SessionWrapper.java:53)
 at com.mercury.dashboard.arch.hibernate.HibernateTransaction.commit(HibernateTransaction.java:45)
 at com.mercury.dashboard.app.portal.PageViewController.updateUserDBInfo(PageViewController.java:376)
 at com.mercury.dashboard.app.portal.PageViewController.destroyPageData(PageViewController.java:366)
 at org.apache.jsp.app.portal.PageView_jsp._jspService(PageView_jsp.java:2225)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
 at com.mercury.dashboard.arch.host.util.DashboardFilterServlet.service(DashboardFilterServlet.java:151)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
 at com.mercury.dashboard.arch.host.DashboardServlet.service(DashboardServlet.java:315)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:87)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:97)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:115)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:178)
 at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:104)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:65)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:904)
 at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1462)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.mercury.dashboard.arch.host.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:63)
 at com.mercury.dashboard.arch.host.BaseFilter.doFilter(BaseFilter.java:48)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:46)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.SchemeBasedRedirectFilter.doFilter(SchemeBasedRedirectFilter.java:64)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:56)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.PerformanceFilter.applyFilter(PerformanceFilter.java:60)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
 at java.lang.Thread.run(Thread.java:619)
STATUS server:ppmLightServiceListenerContainer-2:com.kintana.core.scheduler:2013/07/23-09:00:50.764 EEST: These tasks are executed on: Tue Jul 23 09:00:50 EEST 2013
nextTime = null
 SCHEDULED_TASK_ID WORKER_CLASS     SCHEDULED_TIME  TASK_DATA_ID GROUP_ID SCHEDULED_TASK_RECUR_ID
 30469   com.kintana.core.server.scheduler.ReportSubmissionWorkerThread 2013-07-23 09:00:00.0 41514  null  null

 

 

 

5 REPLIES
mike_se
HPE Expert

Re: Error while tranfering the msp workplan to the ppm

Hi,

The error “Row was updated or deleted by another transaction” normally happens when Users do work against some Task while the Cost Rollup Service is processing the Actuals for the same Tasks. If the Cost Roll Up Service gets to the Task's records first and locks them, the front-end User will get warning message.

Check to see if the Cost Rollup Service is running when that error occurs, and check the Services Node (if a cluster) for any Services errors related to the Project/Work Plan having the issue (see below for an example).

Also, create a test Project and a new MSP Work Plan, and try to migrate from MSP to PPM. This will narrow down the issue to a particular MSP/Project or an overall issue on the system.

-Mike

_____________________________________
Example of Services related error in serverLog.txt:

R&D found the following error in the cloned instance –
server:Exception Rule Service:com.mercury.itg.pm.exceptionRules.ExceptionRuleServi
ce:2009/01/30-02:00:00.852 EST: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.mercury.itg.pm.model.WorkPlanImpl#30113]
server:Exception Rule Service:com.mercury.itg.pm.exceptionRules.ExceptionRuleServi
ce:2009/01/30-02:00:00.836 EST: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.mercury.itg.pm.model.WorkPlanImpl#30112]

These errors are caused by the work_plan_id referred in the wp_pending_exceptions doesn’t have corresponding work plan in the pm_work_plans table.

R&D has provided the following scripts to find and clean up the dirty data –

To find:
You may run the following SQL to select the ones which don’t have a corresponding workplan in the pm_work_plans.
select * from wp_pending_exceptions
where work_plan_id not in (select work_plan_id from pm_work_plans);

To delete:
delete from wp_pending_exceptions where work_plan_id not in (select work_plan_id from pm_work_plans);
commit;

NOTE: Prior to doing backend updates in databases, always test in STAGE environment first and back up the data.

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Etienne_Canaud
HPE Expert

Re: Error while tranfering the msp workplan to the ppm

Please always provide the PPM version you are using when submitting an issue.

 

A similar problem was fixed at some point in 9.1X version  (sorry, I can't pinpoint the exact version), but if you are still on 9.13 or earlier, an upgrade to 9.14.0007 might fix the problem.

 

Thanks,

Etienne.

sevcan
Super Contributor.

Re: Error while tranfering the msp workplan to the ppm

Our verison is 9.14.0005
sevcan
Super Contributor.

Re: Error while tranfering the msp workplan to the ppm

Hey Mike,

I can not create a test project cause this is a live system. So, they do not accept that.

This is a single instance.
Still, I run that select and nothing returns.

mike_se
HPE Expert

Re: Error while transferring the msp Work Plan to the ppm

Hi,

 

If they cannot test in PROD, they will want to migrate the system to a STAGE environment for testing if this is an urgent issue for them.

 

The select statement was just an example of an older Incident related to Services, so make sure to check the serverLog.txt files for any Service related errors.

 

In the meantime, try:

1) Doing the MSP synch one more time

I do not see this stack dump being reported previously for an MSP synch, so want to make sure the exact error on the synch. This is also to test if a Service or another User was updating the Project at the same time the MSP synch was happening. It could work as expected this time.

2) Finding out if other Projects can synch with out issue

If cannot create a test one, find another Project that is using the same synch. Want to confirm it is only an issue with this particular Project/.mpp file.

3) Find out what changed when the issue started happening

If it was working and then stopped working, can try backing out the changes the User made, and then try the synch again.

 

-Mike

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”