3 Replies Latest reply: Mar 18, 2013 7:39 PM by adaikkap RSS

OnCommand Report error when Share as excel, csv or text - Java.NullPointerException

JTVNETAPP Novice
Currently Being Moderated

I am just starting to use OnCommand, Standard edition of DataFabric Manager server, version 5.1.0.15008 (5.1) Cluster-Mode, on a Win2008R2 SP1 x64 system.

I am testing out reports, specifically Storage capacity -> Capacity -> Volumes report.

I can Share the report and receive via email just fine as a PDF or HTML format, but whenever I try to use CSV, Excel, or Text an error is generated.  The error is:

"Unable to share the report: could not run the report volumes-capacity-report(43).  Please refer dfm and dfmserer logs for more detailed information."

 

The pertinent lines from the logs:

dfmserver.log

Mar 07 13:43:34 [dfmserver:ERROR]: [6168:0x1394]: http_get_request failed with return value 500. Please vaildate dfm http and webui services are running correctly. Please refer dfm and jetty log for more detailed information.

 

dfm.log

Mar 07 13:43:34 [dfmserver:ERROR]: [6168:0x1394]: http_get_request failed for url http://localhost:8080/ActuateJavaComponent/extractdata_xls?reportname=/public/volumes-capacity-report.rptdesign&quiet=false&RP_where_filter=+AND+(1+%3D+1) with return value 500. Please vaildate dfm http and webui services are running correctly. Please refer dfm and jetty log for more detailed information.

 

jetty<date_stamp>.log

(I've removed DNS entry, IP Address, and email address from the log snippet)

 

2013-03-07 13:43:34,329 [20288556@qtp-4884983-6: TRACE]: com.netapp.nwf.dfmui.server.log.BrowserLogServlet: Thu Mar 07 13:43:20 EST 2013 running from http://DNS_of_Server:8080/start.html#st=9 class com.netapp.common.zapi.gwt.client.ZAPIServiceProxy$1, ZAPI Response:

<?xml version='1.0' encoding='UTF-8' ?>

<!DOCTYPE netapp SYSTEM 'http://IP_Address_Of_Server:8088/netapp_server.dtd'>

<netapp version='1.0' xmlns='http://www.netapp.com/filer/admin'>

<results status="passed"><sql-filter-clause><from-clause></from-clause><where-clause> AND (1 = 1)</where-clause></sql-filter-clause></results></netapp>

2013-03-07 13:43:34,329 [20288556@qtp-4884983-6: DEBUG]: com.netapp.nwf.dfmui.server.log.BrowserLogServlet: Thu Mar 07 13:43:20 EST 2013 running from http://DNS_of_Server:8080/start.html#st=9 class com.netapp.common.zapi.gwt.client.ZAPIServiceProxy$1$1, Deserialization finished: 0ms

2013-03-07 13:43:34,329 [20288556@qtp-4884983-6: TRACE]: com.netapp.nwf.dfmui.server.log.BrowserLogServlet: Thu Mar 07 13:43:34 EST 2013 running from http://DNS_of_Server:8080/start.html#st=9 class com.netapp.dfm.api.report.GZReportService_Proxy, ZAPI Request:

<?xml version='1.0' encoding='UTF-8'?><netapp version='1.0' xmlns='http://www.netapp.com/filer/admin'><report-designer-share><email-address-list>my_Email@Address</email-address-list><output-format>xls</output-format><report-name-or-id>43</report-name-or-id><subject-field>Volumes</subject-field><target-object-name-or-id>0</target-object-name-or-id></report-designer-share>

</netapp>

2013-03-07 13:43:34.703:WARN::/ActuateJavaComponent/extractdata_xls

java.lang.NullPointerException

    at com.actuate.sample.DataExtractionServlet.processRequest(Unknown Source)

    at com.actuate.sample.DataExtractionServlet.doGet(Unknown Source)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)

    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)

    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)

    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)

    at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)

    at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)

    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

    at org.mortbay.jetty.Server.handle(Server.java:326)

    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)

    at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926)

    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)

    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)

    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)

    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

 

 

The exception for text and csv is the same (except for the extractdata_text and extractdata_csv)

 

DFM Service list

 

C:\>dfm service list

sql: started

webui: started

http: started

eventd: started

monitor: started

scheduler: started

server: started

watchdog: started

 

 

Any suggestions as to what may be causing this?

 

thanks,

Jeff

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points