I have started using ColdFusion Report Builder and most of the reports created so far have worked well. However a recent one has produced problems I haven't been able to resolve.
When run on our development server, the report output is as expected although the browser tab (IE 7.0) indicates an error has occurred. Can't see any error in the report itself. Running the same report on our staging server it fails completely. Using <CFTRY> and <CFCATCH> I can get an error message that says a java.lang nullpointerexception has occurred. The report never displays as it does on the development server.
Doing a <cfdump> of the query for the report before the report runs shows all records with no null values. So the data to be displayed is there in the query result. Date parameters needed by the report are in the request scope and are also present and have values. So based on the information I can see, I have no clue where a null or missing value might be in the report process. I'm also puzzled by why the report actually runs on one system and not at all on the other.
Here is the code that should generate the report:
<cfreport template="ordersRpt6.cfr" format="PDF" query="qGetUserOrdersRpt" encryption="none" overwrite="Yes">
<cfreportparam name="startMonthDate" value="#request.startMonthDate#">
<cfreportparam name="toMonthDate" value="#request.toMonthDate#">
<cfreportparam name="period" value="#request.period#">
</cfreport>
Nothing fancy there, and nothing missing that I can see. So what could be missing that would generate the null pointer exception error? I haven't gotten this problem on any other report although at least one uses virtually identical code and structure. This one is different in that it uses a specific user ID to get records for one person instead of all. That value is passed correctly and the query results are correct too.
Hope someone can point me in a direction to figure this out. Thanks.
When run on our development server, the report output is as expected although the browser tab (IE 7.0) indicates an error has occurred. Can't see any error in the report itself. Running the same report on our staging server it fails completely. Using <CFTRY> and <CFCATCH> I can get an error message that says a java.lang nullpointerexception has occurred. The report never displays as it does on the development server.
Doing a <cfdump> of the query for the report before the report runs shows all records with no null values. So the data to be displayed is there in the query result. Date parameters needed by the report are in the request scope and are also present and have values. So based on the information I can see, I have no clue where a null or missing value might be in the report process. I'm also puzzled by why the report actually runs on one system and not at all on the other.
Here is the code that should generate the report:
<cfreport template="ordersRpt6.cfr" format="PDF" query="qGetUserOrdersRpt" encryption="none" overwrite="Yes">
<cfreportparam name="startMonthDate" value="#request.startMonthDate#">
<cfreportparam name="toMonthDate" value="#request.toMonthDate#">
<cfreportparam name="period" value="#request.period#">
</cfreport>
Nothing fancy there, and nothing missing that I can see. So what could be missing that would generate the null pointer exception error? I haven't gotten this problem on any other report although at least one uses virtually identical code and structure. This one is different in that it uses a specific user ID to get records for one person instead of all. That value is passed correctly and the query results are correct too.
Hope someone can point me in a direction to figure this out. Thanks.
