AEM6 - Classic UI Sidebar DAM broken

[leeasling]

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.

[Sam205505050]

Hi,

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

[Sham_HC · Accepted solution]

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.

[Former Community Member]

Thanks for your knowledge

dermokozmetik

bioderma

lierac

vichy

avene

[leeasling]

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

[leeasling]

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.

[leeasling]

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]

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?

[leeasling]

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.