Clarity: Export to Excel fails with Error 500 when a progress bar is added to a portlet

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

DETAILS:

Export to Excel fails with the following error when you include a progress bar as one of the columns in a portlet:

Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Oracle Only.

STEPS TO REPRODUCE:

1. Create a lookup called "Project Phase Lookup with ID = LKP_PROJ_PHASE
   
   
2. Add the values/ids: SDLC 1, sdlc_1; SDLC 2, sdlc_2; SDLC 3, sdlc_3; SDLC 4, sdlc_4; SDLC 5, sdlc_5; SDLC 6, sdlc_6; SDLC 7, sdlc_7
   
   
3. Add a lookup attribute on the Project object that points at the lookup you created in Step 1. Call it Project Phase with id = PR_PROJ_PHASE
   
   
4. Add the attribute from step #3 to the Layout Edit and/or Create views.
   
   
5. xog in the portlet called "Phase Test" using the attached xml file.
   
   
6. Create a project.
   
   
7. Choose one of the phases from the Project Phase Field and Save your change.
   
   
8. Go to the dashboard page for your Project.
   
   
9. Add the Phase Test portlet to your Dashboard.
   
   
10. Choose the Export to Excel option for the portlet.

EXPECTED RESULTS: Portlet is exported to excel successfully.

ACTUAL RESULTS: You will see an Error 500 - Internal Server error.

TECHNICAL DETAILS:

Error from app-niku.log file on Oracle server:

ERROR 2010-02-11 15:02:50,076 [http-80-Processor38] web.WebControlServlet (admin:5027353__5481d345:prodpack.dashboardExport) Action request error for request: /niku/app?action=prodpack.dashboardExport&format=xlsx&id=5013697&portlet_id=phase_test&portlet_instance_id=5024258&portlet_instance_type=SYSTEM&page_id=projmgr.projectDashboard&url=/niku/app?action=projmgr.projectDashboard&id=5013697
com.niku.union.web.WebException: java.lang.StringIndexOutOfBoundsException: String index out of range: 1
at com.ca.clarity.prodpack.activestatusreport.DashboardExport.buildPage(DashboardExport.java:104)
at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:410)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 1
at java.lang.String.substring(String.java:1765)
at com.ca.clarity.prodpack.activestatusreport.report.StudioReportDriver.getImageName(StudioReportDriver.java:677)
at com.ca.clarity.prodpack.activestatusreport.report.XlStudioReportDriver.processColumns(XlStudioReportDriver.java:173)
at com.ca.clarity.prodpack.activestatusreport.report.XlStudioReportDriver.updateReport(XlStudioReportDriver.java:148)
at com.ca.clarity.prodpack.activestatusreport.report.XlStudioReportDriver.updateSheet(XlStudioReportDriver.java:108)
at com.ca.clarity.prodpack.activestatusreport.report.XlStudioReportDriver.add(XlStudioReportDriver.java:101)
at com.ca.clarity.prodpack.activestatusreport.DashboardExport.processPortlet(DashboardExport.java:261)
at com.ca.clarity.prodpack.activestatusreport.DashboardExport.processPage(DashboardExport.java:170)
at com.ca.clarity.prodpack.activestatusreport.DashboardExport.processPortlets(DashboardExport.java:140)
at com.ca.clarity.prodpack.activestatusreport.DashboardExport.buildPage(DashboardExport.java:99)
... 23 more

Solution:

WORKAROUND:

None

STATUS/RESOLUTION:

This issue has been documented as CLRT-51151 and is assigned to development for review. If you are experiencing this problem and the workaround above does not significantly help, please contact CA Clarity Technical Support.

KEYWORDS: Export to Excel, portlet, CLRT-51151, progress bar, Error 500, Internal server error, clarity12open.

Environment

Release:
Component: STUDIO