Versions Compared

Old Version 2

changes.mady.by.user Frank Gambino

Saved on

compared with

New Version Current

changes.mady.by.user Frank Gambino

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...