Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

error in creating the Custom report generation in cq5

chocochat
Level 2
Level 2

I am trying to generate a custom report in CQ5.5

I followed the steps in the day site link

http://dev.day.com/docs/en/cq/5-5/developing/developing-reports.html#Creating Your Own Report - An Example

I have created the node called "sling:OsgiConfig" but still I am getting the below exception. Can someone please help me resolving this error.

----------------------

19.11.2013 01:38:12.063 *INFO* [10.31.115.90 [1384785492063] GET /apps/cq/reporting/components/osgireport/osgireport/view.infinity.json HTTP/1.1] org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Resource /apps/cq/reporting/components/osgireport/osgireport/view.infinity.json not found
19.11.2013 01:38:12.251 *INFO* [10.31.115.90 [1384785492141] GET /libs/wcm/core/content/components.1384785213199.json HTTP/1.1] com.day.cq.wcm.core.impl.components.ComponentServlet provided components.
19.11.2013 01:38:13.548 *ERROR* [10.31.115.90 [1384785493548] POST /etc/reports/osgireports/jcr:content/report.data.json HTTP/1.1] com.day.cq.reporting.servlets.DataServlet Could not create report for report '/etc/reports/osgireports/jcr:content/report'
19.11.2013 01:38:13.548 *ERROR* [10.31.115.90 [1384785493548] POST /etc/reports/osgireports/jcr:content/report.data.json HTTP/1.1] com.day.cq.reporting.servlets.DataServlet Stacktrace: javax.jcr.PathNotFoundException: definitions
    at org.apache.jackrabbit.core.NodeImpl$8.perform(NodeImpl.java:2113)
    at org.apache.jackrabbit.core.NodeImpl$8.perform(NodeImpl.java:2107)
    at org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216)
    at org.apache.jackrabbit.core.ItemImpl.perform(ItemImpl.java:91)
    at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2107)
    at com.day.cq.reporting.impl.ColumnImpl.<init>(ColumnImpl.java:146)
    at com.day.cq.reporting.impl.ReportImpl.<init>(ReportImpl.java:141)
 
19.11.2013 01:38:13.548 *ERROR* [10.31.115.90 [1384785493548] POST /etc/reports/osgireports/jcr:content/report.data.json HTTP/1.1] com.day.cq.wcm.core.impl.WCMDebugFilter Error during include of SlingRequestPathInfo: path='/etc/reports/osgireports/jcr:content/report', selectorString='data', extension='json', suffix='null' javax.servlet.ServletException: Error creating report '/etc/reports/osgireports/jcr:content/report'
    at com.day.cq.reporting.servlets.DataServlet.retrieveAndSendData(DataServlet.java:269)
    at com.day.cq.reporting.servlets.DataServlet.doPost(DataServlet.java:392)
    at org.apache.sling.api.servlets.SlingAllMethodsServlet.mayService(SlingAllMethodsServlet.java:148)
    at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:344)
    at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:375)
    at org.apache.sling.engine.impl.request.RequestData.service(RequestData.java:500)
    at org.apache.sling.engine.impl.filter.SlingComponentFilterChain.render(SlingComponentFilterChain.java:45)
    at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:64)
   
Caused by: javax.jcr.PathNotFoundException: definitions
    at org.apache.jackrabbit.core.NodeImpl$8.perform(NodeImpl.java:2113)
    at org.apache.jackrabbit.core.NodeImpl$8.perform(NodeImpl.java:2107)
    at org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216)
    at org.apache.jackrabbit.core.ItemImpl.perform(ItemImpl.java:91)
    at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2107)
    at com.day.cq.reporting.impl.ColumnImpl.<init>(ColumnImpl.java:146)
    at com.day.cq.reporting.impl.ReportImpl.<init>(ReportImpl.java:141)
    at com.day.cq.reporting.servlets.DataServlet.retrieveReportData(DataServlet.java:163)
    at com.day.cq.reporting.servlets.DataServlet.retrieveAndSendData(DataServlet.java:245)
    ... 72 more

1 Accepted Solution
Sham_HC
Correct answer by
Level 10
Level 10

Why are you creating sling:OsgiConfig node? The example in document does not talk about creating it for report defnition.   Can you post your defnition file please.

View solution in original post

2 Replies
Sham_HC
Correct answer by
Level 10
Level 10

Why are you creating sling:OsgiConfig node? The example in document does not talk about creating it for report defnition.   Can you post your defnition file please.

View solution in original post

chocochat
Level 2
Level 2

Hi Sham,

i created the definition under

/apps/cq/reporting/components/osgireport

As shown in the below structure

N:definitions [nt:unstructured]

            P:groupable [Boolean] = false
            P:type [String] = "string"
            N:queryBuilder [nt:unstructured]
                P:property [String] = "jcr:path"