Reporting in CQ

[adobefor]

The compreport is being used in our application. In my local, I can access it, view the report with all the generated details perfectly. Whereas when it is being accessed from higher environments such as dev and qa, it opens, sidekick is displayed, page layout is displayed, but nothing else happens. There is no sign of a process going on. I checked the permissions for the users and everything is enabled. There is no additional customization done to the component. Please let me know in case of any solutions to this. Thanks in advance!

[Sham_HC]

It is custom implementation issue verify your overlay or compare against working & non working instances.  https://helpx.adobe.com/experience-manager/kb/contentcompareimport.html

[smacdonald2008]

Have you read through all cq docs on the subject?  See:

http://docs.adobe.com/docs/en/aem/6-0/administer/operations/reporting.html

If you are following the docs and experiencing issues on cq publish instance, you may have encountered a bug. Double check the docs, and if issue is not resolved,  open a support ticket.

[smacdonald2008]

Another option you gave is to write a custom report Service using Excel APIs. You can export JCR Data to excel. See 

https://helpx.adobe.com/experience-manager/using/aem-reporting-service.html

[adobefor]

Hi, thanks for the help. The issue is I am able to succesfully run the same report and view the details in the publish instance. When I require to edit the rootpaths etc., I need to edit the same in author instance, publish it so as to make it available in the publ instance to run with the new changes. Hence, I am wondering what is causing it not to display the edit bar in the author instance.

[adobefor]

Hi, i verified and I don't see any difference. The only issue I just noticed in a JS error that is occurring only in the non-working instance, 

Failed to load resource: the server responded with a status of 404 (Not Found)

............:4502/home/users/a/admin.permissions.json?

I have provided all the permissions to the admin user through which I am logging in. Yet, it doesn't seem to work and keeps throwing this error. The error is not thrown in the working instance, Thanks.

[smacdonald2008]

You should be able to modify a report on author. Can you post a screen shot of author that shows your view. Thanks.

[Sham_HC · Accepted solution]

Indicates repository is inconsistent either node type is mismatch or ACL corruption.   Back up from good restore or file daycare to find corrupt node and fix it.

[adobefor]

Sure

[img]report-auth.PNG[/img]

[Henrik_Vinter_-]

Hi

We are experiencing the exact same problem as shown in the uploaded image in the previous reply. All is just blank.

What is the correct approach to fixing this?

[smacdonald2008]

This may be a bug - i have asked our support ppl to look at this. 

[adobefor]

Thanks for the help ! Please do let me know their findings.

[adobefor]

Thanks Sham! It was exactly the reason. Along with compreport , there were many other reports under /etc/reports. I went ahead and checked them to find one of them missing jcr:content node. After deleting that report, I am able to see the edit bar in compreport now !