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

[JTVNETAPP]

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+%3...) 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

[adaikkap]

Hi Jeff,

     Firstly a big thanks for the details on the post, like version, edition, mode, os log error msg etc. It looks like a known issue with a workaround.

Pls see if following the workaround solves your problem

http://support.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=540524

Regards

adai

[JTVNETAPP]

Hello Adai,

I had opened up a NetApp support case for this issue this past Friday March 15, and that same bug report and work-around was suggested to me.  Unfortunately it did not correct the problem.

I did some searching online today, and with the suggestion from the bug report that the issue was related to AppData\Local\, did find a work-around.

This thread:

http://social.msdn.microsoft.com/Forums/en-US/msbuild/thread/70f80ccd-9e15-49db-94ea-4564dfc1e593/

has a similar issue with the presence/absence of the temp folder.  It suggested creating a temp folder in "C:\Windows\system32\config\systemprofile\AppData\Local\" (see last post at bottom of page).

I tried that, and now the csv, excel and txt reports can be shared.

The last post in that forum thread included a link (http://msdn.microsoft.com/en-us/library/windows/desktop/aa384187%28v=vs.85%29.aspx) which has interesting information about 32bit vs 64bit applications, and folder redirection within %windir%\System32 to %windir%\SysWOW64.

I have not looked into the java configuration, but I am wondering if there are different processes for the different types of reports.  Perhaps there is one process for the PDF and HTML, and another for the excel, csv, and text, and one is 64bit one 32?, or perhaps one is hard-coded and the other not.

This issue, and the bug report, probably deserves a second look from NetApp, to see if there is an issue with hard coded paths, a 32bit application called when it should have been 64 or vice-versa.

I am going to put this same note into the case (that is where I hope the second look gets triggered).

thanks,

Jeff

[adaikkap]

Hi Jeff,

     Happy that your could solve your problem yourself . I have passed this comment back to the concerned team to take a look and amend it appropriately.

Regards

adai