java error on report

NaWensheng

I created a query to display a simple list of transactions showing some detail of a newly created objects including a column of fees charged. I created a report using the query option for the data with all the elements in the query on the report. I put a sum tag for the attribute of the fee to tally them in the summary area.

The query runs fine on its own and shows the correct data. I put the report in the user perspective using the 'create document' selection and naming the report. I assume 'create document' is the right action it's the closest to 'run report' that I can see.

When selected from the menu the query launches and asks for the transaction date but then there is a 'java.lang.NullPointerException' error. One of the fee elements is either null or zero. Could that be the problem? The attribute is defined as a number with two decimal places.

Thanks for any help

NaWensheng

This is the 'Tomcat' of the java.lang.NullPointerException if it helps
</root>

Got XML request <root><run_document_action doc_name="Unit Enrollments" >

<prompted_value name="Date Updated" >03/27/2009</prompted_value>

</run_document_action>

</root>

Exception thrown java.lang.NullPointerException null

java.lang.NullPointerException

at com.bas.webapp.thin.a.e.i.a(Unknown Source)

at com.bas.webapp.thin.a.c.a(Unknown Source)

at com.bas.webapp.thin.a.c.a(Unknown Source)

at com.bas.webapp.thin.servlets.WebInterfaceServlet.doPost(Unknown Source)

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

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188-)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108-)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528-)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Unknown Source)

NaWensheng

What I have discovered is that the query has an "Ask at Runtime" input for a date selection. If I omitt the date entry and just use Current_Date it works fine.

It looks like the java script created is missing an ending </root> tag.

aware_support

What is your build number? I vaguely remember that we fixed a similar problem in one of the latest builds. So if you are not running the latest build (1184) please update your system.

NaWensheng

I'm ussing an evaluation copy which is build 1162. Not being able to use a variable for report generation is a big problem in our business model. I can show the reports by rigging them without user input but if someone asks me how to do another date or local association without resorting to the configuration tool I'll have a serious problem. Otherwise this is the simplest development possibility I've seen so far.

Thanks

aware_support

So download the latest build from our web site and install it on top of your old evaluation version. The new build is very likely to be OK.

NaWensheng

Will that not effect my current business space? This is an evaluatin version I'm using.

aware_support

No, it shouldn't. Just in case, save your version as a BSV file prior to updating.

NaWensheng

I did just that and all worked fine. Even keeps track of the number of days left. Very nice and thank you.

Wensheng

NaWensheng

I did just that and all worked fine. Even keeps track of the number of days left. Very nice and thank you.

Wensheng

NaWensheng

Well, again I've spoken too soon. There is no java.lang error running the report but the report does not pick up any data. The query gets and displays precisely the objects created on the date requested but the report is blank.

Must I recreate and regenerate the report?

Thanks

NaWensheng

I deleted the report and went through the new/use existing query/design/create operations again but to no avail. The query selects the correct objects based on date input. The report comes up blank.

Suggestions?

aware_support

The report is most probably wrong - for example, you have put your elements in the wrong bands of the report or you refer to them incorrectly or something like that. If you are sure that everything has been done correctly please send your BSV to support@awareim.com and let us know how to reproduce the problem.

NaWensheng

I only specified use "existing query". In the design window "use template'" I added the same attributes, in the same order as the query and a "Sum" tag for 1 attribute.

I don't see an attachment mode here so I'll send the bsv in a seperate email.

aware_support

We haven't received any e-mails.