In AEM 6.5, on click of modified column in list view of sites.html always keeps loading if cq:lastModified property is not available/removed or miss formatted with date.

[rahulk83350339]

We are not getting sorted list according to modified column on click of modified column in list view of sites.html due to below reasons,

1. cq:lastModified property is not available/removed for few pages.
2. cq:lastModified property miss formatted with date(2018-10-18) for few pages and for other pages date format is "2018-10-18T00:00:00.000+05:30" as expected.
3. jcr:content node is not available/removed for few pages.

What could be the reason for removing these nodes and property?

[ManviSharma]

Hi,

The reasons for missing or removed nodes and properties like cq:lastModified and jcr:content can include customization, content migration processes, and content updates by authors or administrators. To determine the specific reason in your case, review page history.

[rahulk83350339]

Thank you so much @ManviSharma. I will look into page history and check if found exact cause.

Can we write any service or listener to get exact cause?

[aanchal-sikka · Accepted solution]

@rahulk83350339 

This looks like a case of data corruption. 

Ideally, for any operation on a Page, the jcr:content should be updated. And for every page, jcr:content should exist, all components exist under it.

Please check, if there have been any custom process used for creating these pages or translation imports via a connector.

Please consider fixing the data. If jcr:content isn't available, are these pages even in use?