Skip to main content
Planview Customer Success Center

Why does error appear when Time Submission Conformance Report

Question:


When running the Time Submission Conformance Report for Global workgroup, without selecting a workgroup, the following error appears. We do not want to filter down the data by selecting the workgroup. For several years we used the report without selecting the workgroup. Increasing the 'Maximum Requesting Entity Body Limit' and 'Response Buffering Limit' settings did not help. Why do we get this error?
HTTP 500 Internal Server error
The website cannot display the page
 


Answer:


The error is related to the volume of data being generated. If filtering down data by selecting workgroup is not option, you can execute the following statement

-Exec sp_recompile 'FT_GetResourceCapacityPerDay'
This will mark the user defined function to recompile upon next access.
-Exec GetTimeConformancebyWorkgroup 'workgroupID',1
This will function internally to ensure the recompile with proper execution plan.