"This asset cannot be published until dependent assets have been approved." but the dependent asset list is empty (Doc ID 2015512.1)

Last updated on JUNE 20, 2023

Applies to:

Symptoms

1. When using Static Publishing, some assets are stuck in the Held state.When following the link "Held" to get a list of dependent assets, the following message shows:

"This asset cannot be published until dependent assets have been approved." However, the list of dependent assets is empty.

2. With com.fatwire.logging.cs.xcelerate.approval TRACE logging enabled, see the following messages when approving the assets in Held state:

"

[2015-05-11 11:43:03,239 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval] Assessing child dependency for: <blocking_assettype>:1382104382822 Date = 2014-12-28 12:37:40.412 DepType = V DepMode = T
[2015-05-11 11:43:03,239 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval] Comparing against CURRENT asset data: Date = 2013-12-03 14:29:17.637 Present = true
[2015-05-11 11:43:03,239 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval] Reason: Exact dependency; Child; target 1382114262827; child= <blocking_assettype>:1382104382822 dates don't agree: Dep date: 2014-12-28 12:37:40.412, child asset date: 2013-12-03 14:29:17.637
[2015-05-11 11:43:03,239 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval]    Asset <held_assettype>:1409620387485 held because of child - adding child to blocking assets
...
[2015-05-11 11:43:03,250 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval] Assessing child dependency for: <blocking_assettype>:1382104382812 Date = 2014-12-28 12:37:37.742 DepType = V DepMode = T
[2015-05-11 11:43:03,250 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval] Comparing against CURRENT asset data: Date = 2013-12-03 14:29:17.039 Present = true
[2015-05-11 11:43:03,250 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval] Reason: Exact dependency; Child; target 1382114262827; child= <blocking_assettype>:1382104382812 dates don't agree: Dep date: 2014-12-28 12:37:37.742, child asset date: 2013-12-03 14:29:17.039
[2015-05-11 11:43:03,250 UTC] [TRACE] [TP-Processor11] [logging.cs.xcelerate.approval]    Asset <held_assettype>:1409620387485 held because of child - adding child to blocking assets

"

The Dep date in the TRACE message is from the updateddate column of the <blocking_assettype> table.

The child asset date in the TRACE message is from the assetdate column of ApprovedAssets table.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.