Service Interface calls limited by buffer size threshold

Service Interface calls that query the database buffer in excess of 500,000 times, are now placed in a lock status for 30 minutes. This prevents bad queries from negatively impacting the cloud server and database.

Logs are now updated to record when a service call is locked. The log entry includes the IFS user name and email address of the operator that initiated the call. Example: 2021/06/22@13:26:21.1541 [ERROR] P-30580 U-291 D-JSMITH H-USCSNJSMITH01 SetupLog4sx serviceinterface/proxy/retrieve.p - Invalid Request Error, Cono: 1000, Operator: jss, Email: john.smith@company.com, IFS: 4ed2aa9928cd2d39edfec9570171f5d6, Error: The call for this operator, table, and whereclause was locked out for 30 minutes. Lock expires in:2m25s, httpResponseCode: 400.

A business rule can be activated to adjust the number of queries that are permitted before the call is locked to a value from 100,000 or higher. The default is 500,000. Select the DBBuffLimit Rule Type in SA Business Rule Setup to set a Rule Value of 100,000 or higher.

Note: If you specify a Rule Value lower than 100,000, it is adjusted to 100,000.