NullPointerException when running reports with SP25

[former_member612801]

We're trying to upgrade to SP25 of CR4E but have found that several of our reports are failing with a NullPointerException when generating the report. I have tried switching to SP24 and the reports run fine there. I can't find any commonality between the reports in question. I've included the stack trace below - does anyone have any idea what may be wrong or have any workarounds please?

Caused by: java.lang.NullPointerException
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.d.a(SourceFile:154) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:332) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:250) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.a(SourceFile:922) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.e(SourceFile:784) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.for(SourceFile:242) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.WideSectionFormatter.a(SourceFile:40) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:243) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:210) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:185) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:230) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.a(SourceFile:41) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:511) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:452) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:369) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ah.a(SourceFile:72) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ReportColumnFormatter.a(SourceFile:86) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.SinglePageFormatter.a(SourceFile:332) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.SinglePageFormatter.for(SourceFile:177) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.a(SourceFile:41) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.do(SourceFile:737) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.Y(SourceFile:399) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(SourceFile:339) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.do(SourceFile:677) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.formatPage(SourceFile:236) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.byte(SourceFile:220) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1908) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:660) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:166) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:528) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:525) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:524) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:423) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:351) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.sdk.occa.report.application.dt.a(SourceFile:186) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(SourceFile:767) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(SourceFile:324) ~[CrystalReportsRuntime.jar:12.2.226.3772]
    at com.businessobjects.report.web.event.s.a(SourceFile:158) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.event.s.a(SourceFile:127) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.event.bt.a(SourceFile:47) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.event.bw.broadcast(SourceFile:93) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.event.am.a(SourceFile:53) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.a.v.if(SourceFile:2151) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.e.a(SourceFile:304) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.e.a(SourceFile:206) ~[webreporting.jar:12.2.226.3772]
    at com.businessobjects.report.web.e.a(SourceFile:135) ~[webreporting.jar:12.2.226.3772]
    at com.crystaldecisions.report.web.ServerControl.a(SourceFile:607) ~[webreporting.jar:12.2.226.3772]
    at com.crystaldecisions.report.web.ServerControl.processHttpRequest(SourceFile:342) ~[webreporting.jar:12.2.226.3772]

[former_member1375099]

Hi,

We are facing same issue with SP24. Could you please let me know how you resolved it. We are stuck with this error since 3 months now. Please suggest.

[former_member203619 · Accepted solution]

The issue has been escalated to development and fixed. It is a bug which exists in 12.2.225 and 12.2.226. The fix should be in 12.2.227. I do not have a targeted release date for that version though.

As a note - this issue does not occur in the BOE SDK - only in those two version of CR for Eclipse.

Shawn

[former_member612801 · Accepted solution]

That’s great - thanks for your help guys!

[former_member11696]

Hi Rich,

Do those reports have Parameters in them?

We switch from using Flash to HTML5, may be the cause, just guessing here though...

If you recreate the report does it work?

Try removing objects, start with whole sections until you find the object(s) causing the problem.

Have a great day

Don

[former_member612801]

don.williams and shawn.penner, thanks so much for your help on this but it seems that we have run into a similar issue with SP26 - now instead of a NullPointerException we're getting an infinite loop in similar circumstances. I've put the details in a new post here - do you have any ideas or suggestions please?

[former_member11696]

Great Shawn had an answer.

CR for Eclipse typically comes out every 6 months so we are close to SP 27.

Thanks again

Don

[former_member612801]

Thanks for the suggestions, Don. The reports do have parameters and we’re managing to select values fine using the new HTML UI. The exception is occurring in about 50% of the reports that we supply with our product and I can see other users on this forum have run into the same stacktrace so it seems likely that reports that our customers have created for use with our product will have the issue too. I’ve tried taking components out of the reports in question but they’re pretty complex and I haven’t managed to find any commonality in what causes or prevents the issue. From playing around I suspect it’s something to do with exactly where the pagination occurs. Downgrading from SP25 to SP24 fixes it but given the imminent complete removal of support for flash in browsers we need to move to the SAP UI5 prompting enabled by SP25 ASAP.

In the debugger I can see, despite the code obfuscation, that the NullPointerException is being produced when obtaining values to be compared for a CrystalAssert. If I skip over these lines in the debugger the report renders fine.

Thanks again for taking a look at this.

[former_member612801]

We haven't found any solutions so far. Our support contract has expired so we've been trying to purchase a one-off incident to raise it with SAP but they don't seem to be interested unfortunately.