Hotfix 87657

A Content Manager hotfix.

Problem description

Read publish transaction: state can be demoted from Waiting to Scheduled when server times out of sync (Microsoft SQL Server).

Hotfix description
Flow that triggers wrong behavior:
  1. When creating publish transaction, deploy time is set to current server time.
  2. After that transaction state was updated to WaitingForDeployment == 4 (deploy time wasn't changed).
  3. When reading publish transaction server current time is sent.
  4. In order to determine state, EDA_PUB_TRAN_GET_STATE function is used time-dependent logic that has a flaw and can demote state to Schedule for deployment when read time is earlier that deploy time.
Distributed files

EDA_PUBLISH_TRANSACTIONS.sql

Fixes included

None

Dependencies

None