Clarity: OBS Investment Aggregation, Investments portlet "Error 500 - Internal System Error" when doing Export to Excel

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

Description:

When clicking on Investments link from Resource Planning portlet which contains OBS Aggregation and filtered by an Investment OBS results in Error 500 - System error when trying to Export to Excel (Data Only).
Reproducible with OD customer environment and in-house Vanilla install r13.0.1 from Resource Planning, Investments tab.
With r13.1 there is no "Resource Planning", "Investments" tab but "Resource Planning" --> "Organizational Demand" tab instead.

app-ca.log reads:

ERROR 2013-10-09 13:19:27,156 [http-1301-8] grid.GridMetadataCache (clarity:admin:5306047__02060C8D-8E73-4D48-8ECC-FCC7BD5E932F:npt.gridExcelExport) Unable to get list cview file for code=projmgr.obsFlatInvAggregations exception com.niku.odf.griphendor.GriphendorException: Unable to find view with CustomViewManager: code=obsFlatInvAggregations, component=projmgr
ERROR 2013-10-09 13:19:27,156 [http-1301-8] web.WebActionController (clarity:admin:5306047__02060C8D-8E73-4D48-8ECC-FCC7BD5E932F:npt.gridExcelExport)
com.niku.union.web.WebException: Service call failed for portlet: npt.gridExcelExport
Caused by: com.niku.odf.griphendor.GriphendorException: Unable to find grid metadata with view code/portlet key = NIKU.ROOT#:projmgr#:obsFlatInvAggregations#:null
at com.niku.odf.griphendor.grid.GridMetadata.getMetadata(GridMetadata.java:3034)
at com.niku.odf.griphendor.grid.GridKernel.preProcessRequest(GridKernel.java:134)
at com.niku.odf.griphendor.GriphendorEngine.processGridRequest(GriphendorEngine.java:132)
at com.niku.odf.griphendor.GriphendorEngine.processRequest(GriphendorEngine.java:82)
at com.niku.npt.griphendor.GridServiceAdapter.processRequest(GridServiceAdapter.java:95)
... 31 more
ERROR 2013-10-09 13:19:27,156 [http-1301-8] performance.PerformanceMonitor (clarity:admin:5306047__02060C8D-8E73-4D48-8ECC-FCC7BD5E932F:npt.gridExcelExport) Mismatch in timing element stack, where titles do not match ('webRequest' != 'action') or ids do not match ('npt.gridExcelExport' != 'npt.gridExcelExport')

Steps To Reproduce:

  1. In Clarity 13.0.1, navigate to Home, Resource Management, Resource Planning and click on Investments tab

  2. OR in Clarity r13.1.0 navigate to Home, Resource Management, Resource Planning and then go to "Organizational Demand" tab

  3. Expand the filter "OBS Investment Aggregation", select any "Investment OBS Type" and filter for results

  4. In the results list click on the "Investments" link between name and the Time-Scaled Value

  5. On the resulting OBS Investment portlet click the 'Options' icon, select Export to Excel (Data Only)
    Note: same happens if instead of "Investment OBS Type" is filtered or "Investment OBS"

Expected Result: Result set as shown on screen to be exported to Excel
Actual Result:Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

Resolved in Clarity 13.3

Keywords: CLARITYKB, CLRT-69907, clarity13resolved, clarity133resolved.