/
_WATSON-24826 FI 9x

_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.

Related content

_WATSON-20353 FI 9x
_WATSON-20353 FI 9x
More like this
Labor-Scheduler
Labor-Scheduler
More like this
_WATSON-18376 RN
_WATSON-18376 RN
More like this
_WATSON-21756 RN 9x
_WATSON-21756 RN 9x
More like this
Generate Projected Hours
Generate Projected Hours
More like this
_WATSON-21765 RN 9x
_WATSON-21765 RN 9x
More like this