Hotfix 88043

A Content Manager hotfix.

Problem description

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

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
  • CM_2013.1.0.88043_ORACLE.sql
  • EDA_PUBLISH_TRANSACTIOON.sql
  • TCM_RECOMPILE_PACKAGES.sql
Fixes included

None

Dependencies

None