Software/Hardware Inventory - some item types generate internal error in reports

Home

Forums

Feature Requests

Beta Issues

SysAid Resources

Documentation

Support

Hello Guest,

DOWNLOAD FREE EDITION

Recent Topics

Hottest Topics

Online Members

Member Listing

Advanced Search

Software/Hardware Inventory - some item types generate internal error in reports

Forum Index » Analyzer/Reporting

Author

Message

25/08/2011 18:51:16

Subject: Software/Hardware Inventory - some item types generate internal error in reports

Saimonsais
SysAider

SysAider from release 7.5

Joined: 24/07/2011
Messages: 12
Offline

I was playing around whit Analyzer, and found some strange issues whitin it.

If i make a Software/Hardware Inventory report - most of the reports are running fine,
but some give the following error in the browser:

Internal error while executing report (Inventory).

I did checked back the logs and found some clues,
but they are not too much information for me:

in case of Display Adapter type - the logs are the following:

2011-08-25 20:39:15,303 [http-8080-1] ERROR com.ilient - Error while executing report (Inventory)
net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :.
<------>Source text : Integer.toString((int)((java.lang.Math.round((1.0 * Double.parseDouble($F{fld}) ) / 1048576 / 1) * 1))).toString()+" MB"
<------>at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195)
<------>at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)
<------>at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)
<------>at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929)
<------>at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:383)
<------>at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:368)
<------>at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)
<------>at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2033)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:760)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:270)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)
<------>at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)
<------>at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
<------>at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
<------>at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
<------>at com.ilient.report.GenericReport.a(Unknown Source)
<------>at com.ilient.report.GenericReport.doPost(Unknown Source)
<------>at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
<------>at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
<------>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
<------>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<------>at com.ilient.server.LoginFilter.doFilter(Unknown Source)
<------>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
<------>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<------>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
<------>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
<------>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
<------>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
<------>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
<------>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
<------>at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
<------>at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
<------>at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
<------>at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NumberFormatException: For input string: "ATI MOBILITY RADEON 9600/9700 Series"
<------>at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
<------>at java.lang.Double.parseDouble(Double.java:510)
<------>at Inventory_1314297555020_895023.evaluate(Inventory_1314297555020_895023:320)
<------>at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182)
<------>... 34 more

in case of Display Resolution type - the logs are the following:

Anbody any idea?
2011-08-25 20:39:19,975 [http-8080-1] ERROR com.ilient - Error while executing report (Inventory)
net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :.
<------>Source text : Integer.toString((int)((java.lang.Math.round((1.0 * Double.parseDouble($F{fld}) ) / 1048576 / 1) * 1))).toString()+" MB"
<------>at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195)
<------>at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)
<------>at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)
<------>at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929)
<------>at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:383)
<------>at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:368)
<------>at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)
<------>at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2033)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:760)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:270)
<------>at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)
<------>at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)
<------>at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
<------>at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
<------>at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
<------>at com.ilient.report.GenericReport.a(Unknown Source)
<------>at com.ilient.report.GenericReport.doPost(Unknown Source)
<------>at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
<------>at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
<------>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
<------>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<------>at com.ilient.server.LoginFilter.doFilter(Unknown Source)
<------>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
<------>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<------>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
<------>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
<------>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
<------>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
<------>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
<------>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
<------>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
<------>at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
<------>at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
<------>at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
<------>at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NumberFormatException: For input string: "1024x768"
<------>at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
<------>at java.lang.Double.parseDouble(Double.java:510)
<------>at Inventory_1314297555020_895023.evaluate(Inventory_1314297555020_895023:320)
<------>at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182)
<------>... 34 more

21/09/2011 21:20:33

Subject: Re:Software/Hardware Inventory - some item types generate internal error in reports

techguy
SysAid Mod

Meet me in Vegas - SysAid technology Conference - 28-30/4/2010

Joined: 11/06/2008
Messages: 1506
Location: England
Offline

Hi Saimonsais, Sorry no-one got back to you sooner.
Well spotted!

I will raise this as an issue with the helpdesk, and in the mean time here is how to fix that report.
Go in to the manager portal an select Design Reports,

Select Software/Hardware Inventory
Click on the edit report icon
Click on the script tab and change the line that says

and replace it with

Then click apply and close the window (The ok button seems to be broken too at the moment

)

There you go !

This message was edited 1 time. Last update was at 21/09/2011 21:44:06

Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki

02/10/2011 09:47:35

Subject: Re:Software/Hardware Inventory - some item types generate internal error in reports

David Lee
SysAid Customer Relations

Joined: 24/06/2009
Messages: 40
Offline

Sorry for the delay guys, its the holiday season here.

Techguy, you are right on the money as always, as your service request helped a lot, both in getting this issue to us as well as in understanding the source of this issue (still not sure how you figured this out).

Your SR is now with the development team being investigated.

Thanks again and sorry for the delay again .

03/10/2011 13:35:42

Subject: Re:Software/Hardware Inventory - some item types generate internal error in reports

Saimonsais
SysAider

SysAider from release 7.5

Joined: 24/07/2011
Messages: 12
Offline

No problem mates, it was summer season

By the way, sadly I dont have manager portal, so I still look forward for a solution for those errors ...

best regards

Forum Index » Analyzer/Reporting

Go to:

Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software

   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011

   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software