Any suggestions on how to identify the root cause (offending query / objects) please? - Thanks.
[pool-33-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
After enabling the Log4j DEBUG settings, it seems this is caused Appian generated query still unable to identify at what event / action causing this error.
DEBUG org.hibernate.SQL - select this_.id as id78_0_, this_.obj_type as obj2_78_0_, this_.obj_uuid as obj3_78_0_, this_.obj_version_id as obj4_78_0_, this_.outdated_status as outdated5_78_0_, this_.test_result_id as test6_78_0_ from last_test_result this_ where this_.obj_uuid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, this "?" goes beyond 2100 limit.
Discussion posts and replies are publicly visible
Seems like you use a query with an "in" operator and a long list of values. You will need to find a way to change that.
Thanks Stefan, that was an initial assumption. However, DEBUG trace log queries reveals it as Appian generated query - select this_.id as id78_0_, this_.obj_type as obj2_78_0_, this_.obj_uuid as obj3_78_0_, this_.obj_version_id as obj4_78_0_, this_.outdated_status as outdated5_78_0_, this_.test_result_id as test6_78_0_ from last_test_result this_ where this_.obj_uuid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, We don't have any db object as last_test_result and none of the query appearing to have more than 2100 parameters.
Then open a support case with Appian to investigate this issue.
@Karikalan Ramakrishnan ,
As Stefan mentioned, you will generally get this error when the passed filter parameter values are approx more than 2100. In order to confirm the same, try the same query with less than 2100.
I believe this is a setting at the database level, where there is a limitation to not have more than 2,100 parameter values in a stored procedure and user-defined functions.
Here is a related post:
community.appian.com/.../the-incoming-request-has-too-many-parameters-the-server-supports-a-maximum-of-2100-parameters-reduce-the-number-of-parameters-and-resend-the-request
Thanks Steve / Vimal. it's seems to be a known Appian product issue fixed thru hot fix 20.3.925.0 - AN-187275 - Fixed an issue that resulted in an error when handling incoming requests with more than a 1000 parameters https://docs.appian.com/suite/help/20.3/Hotfixes.html. Anyone receives this system generated last_test_result select query error, one of the checkpoint should be current version & hot fixes.