error in creating the Custom report generation in cq5

[chocochat]

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

[Sham_HC · Accepted solution]

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.

[chocochat]

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"