Absent Member.. gascovi Absent Member..
Absent Member..

<(PPM) Support Tip>: Limitation approving more than 1000 worksheets

When trying to approve more than 1000 worksheets, the system in will validate the amount and will prompt the following error:


ORA-01795: maximum number of expressions in a list is 1000


The issue could also come from the Tomcat, the very first thing to verify will be the configuration on this side.


The parameter maxParameterCount is used to limit the max number of the parameters which are posted from the browser to PPM (Tomcat) server.


The following comment is from this article: https://tomcat.apache.org/tomcat-7.0-doc/config/http.html


maxParameterCount - The maximum number of parameter and value pairs (GET plus POST) which will be automatically parsed by the container. Parameter and value pairs beyond this limit will be ignored. A value of less than 0 means no limit. If not specified, a default of 10000 is used. Note that FailedRequestFilter filter can be used to reject requests that hit the limit.



When the user try to “handle” a time sheet which contains large numbers of time sheet lines, a great number of parameters will be posted from the browser to PPM server, if the number of parameter exceeds 10000 (the default value of maxParameterCount if not specified), the customer might run into errors because some parameters are lost.


If you ask the ceiling limit, I cannot tell the exact number as it depends on how the users fills time sheet, for example, the ceiling limit for weekly time sheet should be different with the one for biweekly time sheet.


Anyway, this issue can be addressed as well by changing the parameter of maxParameterCount; even the users want to fill 1000 time sheet lines in one time sheet, that is OK.


Once previous step has been analyzed, you can also find the defect related with this:




Note:  Please be aware that as much information it’s being handled in massive, this could be reflected on performance due the
multiple calculations related with the information.  Users could consider skipping this approval step and add it as self-approval and make a cross-reference on
different steps for control.

Labels (1)
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.