Project and Portfolio Management Practitioners Forum
cancel

Project Plan Error

Highlighted
Akhil Goel
Contributor.

Project Plan Error

Hi
One of our user has updated its project plan and when tried changing the state of plan from on Hold to Active.It started giving the below error.Even on search after clicking the project name it gives this error.Is there any way we can see the project plan in front end.

Error.

An unknown exception has occurred. Please reload the page you were editing and try again.
The following is a stack trace of the exception:
org.hibernate.exception.SQLGrammarException:could not update: [com.mercury.itg.pm.model.ProjectImpl#112272]
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2222)
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:954)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1099)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
com.mercury.itg.pm.security.WorkPlanSecurityLoader.createAndRunQuery(WorkPlanSecurityLoader.java:236)
com.mercury.itg.pm.security.WorkPlanSecurityLoader.loadManagerParticipant(WorkPlanSecurityLoader.java:251)
com.mercury.itg.pm.security.WorkPlanSecurityLoader.loadParticipants(WorkPlanSecurityLoader.java:151)
com.mercury.itg.pm.security.WorkPlanSecurityLoader.loadSecurity(WorkPlanSecurityLoader.java:192)
com.mercury.itg.pm.security.WorkPlanSecurityLoader.init(WorkPlanSecurityLoader.java:185)
com.mercury.itg.pm.security.WorkPlanSecurityLoader.(WorkPlanSecurityLoader.java:172)
com.mercury.itg.pm.project.web.OpenProjectAction.doExecute(OpenProjectAction.java:165)
com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:163)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.portals.bridges.struts.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:50)
com.mercury.itg.common.web.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:47)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:34)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:65)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:725)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:79)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
com.kintana.core.web.filter.I18nFilter.applyFilter(I18nFilter.java:44)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:43)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
java.lang.Thread.run(Thread.java:534)

Akhil