"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 JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 7.6.0 to 11.1.1.8.0 [Release FatWire]
Information in this document applies to any platform.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms