AEM6 - Classic UI Sidebar DAM broken | Community
Skip to main content
L
leeasling
Level 8
October 16, 2015
Solved

AEM6 - Classic UI Sidebar DAM broken

  • October 16, 2015
  • 8 replies
  • 1863 views

I'm having an issue with AEM 6 after a repository upgrade to Oak.  After the initial upgrade with AEM6 running on CRX2, everything was seemingly fine.  I then upgraded the repository to Oak, and have noticed that whenever i try to load a page within my site, i get the following in the error log, and the DAM assets never load in the side bar.

 

08.07.2014 10:14:52.798 *WARN* [172.18.10.29 [1404824999251] GET /bin/wcm/contentfinder/asset/view.json/content/dam HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 540000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:primaryType] = 'dam:AssetContent' and contains([metadata/dc:format], 'image') and isdescendantnode(a, '/content/dam') order by [jcr:lastModified] desc /* xpath: /jcr:root/content/dam//*[(@jcr:primaryType='dam:AssetContent' and jcr:contains(metadata/@dc:format, 'image'))] order by @jcr:lastModified descending */fullText=metadata/dc:format:"image", path=/content/dam//*, property=[dc:format=, jcr:primaryType=dam:AssetContent]); consider creating an index or changing the query

08.07.2014 10:14:59.931 *WARN* [172.18.10.29 [1404824999251] GET /bin/wcm/contentfinder/asset/view.json/content/dam HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 541000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:primaryType] = 'dam:AssetContent' and contains([metadata/dc:format], 'image') and isdescendantnode(a, '/content/dam') order by [jcr:lastModified] desc /* xpath: /jcr:root/content/dam//*[(@jcr:primaryType='dam:AssetContent' and jcr:contains(metadata/@dc:format, 'image'))] order by @jcr:lastModified descending */fullText=metadata/dc:format:"image", path=/content/dam//*, property=[dc:format=, jcr:primaryType=dam:AssetContent]); consider creating an index or changing the query

 

There are thousands upon thousands of these entries, and it occurs for every page hit.

Any help with this would be greatly appreciated.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sham_HC

You are hitting an know issue. Please file daycare referencing CQ-12087.

If you are familiar with configuring index as an workaround from CRXDE Lite, under the node oak:index, create a new index (/oak:index/contentPath) node similar to  /oak:index/slingResourceType and set the property "reindex" to "true" & propertyNames accordingly.

8 replies

S
Sam205505050
Level 6
October 16, 2015

Hi,

can you tell me what were the steps you followed to upgrade to oak?

Sham_HC
Sham_HCAccepted solution
Level 10
October 16, 2015

You are hitting an know issue. Please file daycare referencing CQ-12087.

If you are familiar with configuring index as an workaround from CRXDE Lite, under the node oak:index, create a new index (/oak:index/contentPath) node similar to  /oak:index/slingResourceType and set the property "reindex" to "true" & propertyNames accordingly.

A
Anonymous
October 16, 2015

Thanks for your knowledge

dermokozmetik

bioderma

lierac

vichy

avene

L
leeaslingAuthor
Level 8
October 16, 2015

Sam205505050 wrote...

Hi,

can you tell me what were the steps you followed to upgrade to oak?

 

http://docs.adobe.com/docs/en/aem/6-0/deploy/upgrade.html#Migrating the repository to OAK

L
leeaslingAuthor
Level 8
October 16, 2015

Sham HC wrote...

You are hitting an know issue. Please file daycare referencing CQ-12087.

If you are familiar with configuring index as an workaround from CRXDE Lite, under the node oak:index, create a new index (/oak:index/contentPath) node similar to  /oak:index/slingResourceType and set the property "reindex" to "true" & propertyNames accordingly.

 

Thanks for the response Sham.  I think I understand what you're saying, but could you confirm what you mean by "propertyNames accordingly"?  It seems they're pretty specific for the other nodes under oak:index, so i want to make sure I do this correctly.

I will also create a day care ticket.

Thanks again.

L
leeaslingAuthor
Level 8
October 16, 2015

I also see this a lot when shutting down the server.  Is this also a known issue?

09.07.2014 09:48:24.231 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 46000 nodes using index jcr:primaryType with filter Filter(query=SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder DESC, path=*, property=[sling:vanityPath=])

09.07.2014 09:48:26.544 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 47000 nodes using index jcr:primaryType with filter Filter(query=SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder DESC, path=*, property=[sling:vanityPath=])

Sham_HC
Sham_HC
Level 10
October 16, 2015

leeasling wrote...

I also see this a lot when shutting down the server.  Is this also a known issue?

09.07.2014 09:48:24.231 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 46000 nodes using index jcr:primaryType with filter Filter(query=SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder DESC, path=*, property=[sling:vanityPath=])

09.07.2014 09:48:26.544 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 47000 nodes using index jcr:primaryType with filter Filter(query=SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder DESC, path=*, property=[sling:vanityPath=])

 

IMO Warning looks ok.  do u have lot of vanity path?

L
leeaslingAuthor
Level 8
October 16, 2015

Not a single one.

Sham HC wrote...

leeasling wrote...

I also see this a lot when shutting down the server.  Is this also a known issue?

09.07.2014 09:48:24.231 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 46000 nodes using index jcr:primaryType with filter Filter(query=SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder DESC, path=*, property=[sling:vanityPath=])

09.07.2014 09:48:26.544 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 47000 nodes using index jcr:primaryType with filter Filter(query=SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder DESC, path=*, property=[sling:vanityPath=])

 

IMO Warning looks ok.  do u have lot of vanity path?

 

Not a single one, which makes this very confusing.

Another query that keeps being run is this one:

14.07.2014 12:52:53.586 *WARN* [pool-9-thread-2] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 8000 nodes using index jcr:primaryType with filter Filter(query=select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/activationDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/xfaForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/activationDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/pdfForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/activationDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/printForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/activationDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/printForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/activationDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/guide] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/expiryDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/xfaForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/expiryDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/pdfForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/expiryDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/printForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/expiryDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/printForm] = '1' union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/expiryDate] <= cast('2014-07-14T11:00:17.802Z' as date) and isdescendantnode(a, '/content/dam/formsanddocuments') and [jcr:content/guide] = '1' /* xpath: /jcr:root/content/dam/formsanddocuments//element(*, dam:Asset)[(jcr:content/@xfaForm = '1' or jcr:content/@pdfForm = '1' or jcr:content/@printForm = '1' or jcr:content/@printForm = '1' or jcr:content/@guide = '1') and ((jcr:content/metadata/@activationDate <= xs:dateTime('2014-07-14T11:00:17.802Z')) or (jcr:content/metadata/@expiryDate <= xs:dateTime('2014-07-14T11:00:17.802Z')))] */, path=/content/dam/formsanddocuments//*, property=[jcr:content/pdfForm=1, jcr:content/metadata/activationDate=..2014-07-14T11:00:17.802Z]])

Which also takes a significant amount of time to run.

Terms & ConditionsAccessibility statement

Loading footer...