_WATSON-24826 FI 9x

24826

Summary

The SQL processes that handle projected hours have been improved to more efficiently manage requests from properties with large numbers of jobs.

Description

In some instances of previous releases, when attempting to generate projected hours, users received the following error message:

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

For properties containing many jobs, this error was caused by the large number of parameters passed to SQL.

Solution

The SQL has been modified to more efficiently receive the large number of parameters passed from properties containing many jobs.

Updated versionsVersion 9.20 and later.