Clarity: Cost Plan Detail page generates Error 500

Document ID : KB000049820
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Cost plans are now getting an error 500 at creation on the upgraded V13 environment:

Steps to Reproduce:

  1. Login to Clarity as an administrator
  2. Home > Projects > Open a new or existing project
  3. Financial Plans
  4. Under Actions click on "New from Investment Team"
  5. Create a new cost plan, group by role or charge code (doesn't matter) and submit

Expected Result: Cost plan created
Actual Result: Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

This also happens if you try to drill into the detail of a newly created manual cost plan.

APP.LOG ERROR:
ERROR 2013-02-21 15:44:38,372 [http-14001-14] web.WebActionController
(clarity:admin:10398647__3DC6F6F0-7218-4EBD-9ADA-85F931381103:revmgr.newFromResourcePlan)
com.niku.union.web.WebException: WebServiceAdapter::processRequest -> failed to process service request
at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:198)
at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1393)
at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:232)
at com.niku.union.web.PortletController.processRequest(PortletController.java:159)
at com.niku.union.web.WebActionController.processAction(WebActionController.java:1124)
at com.niku.union.web.WebActionController.processRequest(WebActionController.java:163)
at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:403)
at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:445)
at com.ca.clarity.uif.UIServlet.service(UIServlet.java:66)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:130)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)

Caused by: com.niku.union.service.ServiceException: Exception in
ResourcePlanProcessingService: com.niku.union.odf.exception.ODFException:com.niku.union.service.ServiceException: Service Exception
at com.niku.odf.service.ODFActionService.processRequest(ODFActionService.java:125)
at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)
at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:749)
at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:211)
at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:194)
... 28 more

Caused by: com.niku.union.service.ServiceException: Exception in
ResourcePlanProcessingService: com.niku.union.odf.exception.ODFException:com.niku.union.service.ServiceException: Service Exception
at com.ca.clarity.financial.planning.services.ResourcePlanProcessingService.process(ResourcePlanProcessingService.java:213)
at com.ca.clarity.financial.planning.services.ResourcePlanProcessingService.doProcess(ResourcePlanProcessingService.java:90)
at com.niku.odf.service.ODFActionService.processRequest(ODFActionService.java:86)
... 32 more

ERROR 2013-02-21 15:44:38,377 [http-14001-14] performance.PerformanceMonitor
(clarity:admin:10398647__3DC6F6F0-7218-4EBD-9ADA-85F931381103:revmgr.newFromResourcePlan)
Mismatch in timing element stack, where titles do not match ('webRequest'!= 'action') or ids do not match ('revmgr.costplanPost' !='revmgr.newFromResourcePlan')

ERROR 2013-02-21 15:51:45,209 [http-14001-12] model.ObjectActionGroupImpl
(clarity:admin:10398640__BE435E18-3489-429F-8B33-C94F6498BADF:revmgr.budgetList)
Could not find object action in cview: revmgr.costplanListRejectBudget

ERROR 2013-02-21 15:51:45,209 [http-14001-12] model.ObjectActionGroupImpl
(clarity:admin:10398640__BE435E18-3489-429F-8B33-C94F6498BADF:revmgr.budgetList)
Could not find object action in cview: revmgr.costplanListApproveBudget

Solution:

Prior to the upgrade action, the implementation had Audit Trail attributes enabled for the Cost Plan Detail Object. After upgrading to Clarity v13, the Audit Trail trigger became invalid.

To resolve this issue, the Clarity Administrator rebuilt the Audit Trail Trigger after the upgrade using the following steps:

  1. Login to Clarity as an administrator in the upgraded v13 system
  2. Administration > Studio: Objects > Cost Plan Detail > Audit Trail
  3. Move all 'Selected' attributes back to the 'Available' combo box
  4. Click 'Save' button
  5. Move the desired attributes from the 'Available' list to the 'Selected' list
  6. Click 'Save' button
  7. Home > Projects > Open a new or existing project
  8. Financial Plans
  9. Create a new cost plan > click 'Submit' button

Reference the Clarity v13 Upgrade, Change and Impact Guide for details on fields that have been removed with this release and other details that will be helpful to you in a successful upgrade.

Keywords: CLARITYKB, odf.auditTrail.