Text truncated for content from Oracle Clob column

[Former Member]

Hi,

I have a report created on CR 10 that I am calling from a Java application in batch mode to produce pdfs. I am using Java 1.6 and CR Java runtime 12.2.207. The Crystal report file consists of several subreports. One of them fetches data from an Oracle Clob column. This is represented as a Memo field in the .rpt file. My problem is that for the subreport with the Clob field, the text is truncated in the pdf file after a certain number of characters, and a Java exception is thrown. When the number of characters in the Clob is small, all the content is shown and no java exception is thrown. The pdfs are always generated (independent of the java exception). And the rest of the pdf file looks fine. When generating the pdf from the CR client, all the content of the Clob is shown in the pdf independent of the number of characters.

Do you have any clue about what I am doing wrong here?

Thank you!

Jose Orellana

[Adam_Stone]

What's the exception?

[Former Member]

Here is the exception:

java.lang.IllegalArgumentException: Colour: null

at com.crystaldecisions.reports.reportdefinition.FontColourProperties.setColour(SourceFile:362)

at com.crystaldecisions.reports.reportdefinition.f.a(SourceFile:987)

at com.crystaldecisions.reports.reportdefinition.f.a(SourceFile:1015)

at com.crystaldecisions.reports.reportdefinition.f.if(SourceFile:57)

at com.crystaldecisions.reports.reportdefinition.f$b.a(SourceFile:1192)

at com.crystaldecisions.reports.reportdefinition.f$b.handleStartTag(SourceFile:1272)

at javax.swing.text.html.parser.DocumentParser.handleStartTag(DocumentParser.java:143)

at javax.swing.text.html.parser.Parser.startTag(Parser.java:418)

at javax.swing.text.html.parser.Parser.parseTag(Parser.java:1926)

at javax.swing.text.html.parser.Parser.parseContent(Parser.java:2044)

at javax.swing.text.html.parser.Parser.parse(Parser.java:2211)

at javax.swing.text.html.parser.DocumentParser.parse(DocumentParser.java:105)

at com.crystaldecisions.reports.common.CrystalHTMLParserDelegator.parse(SourceFile:332)

at com.crystaldecisions.reports.reportdefinition.f.new(SourceFile:165)

at com.crystaldecisions.reports.reportdefinition.TextDefinition.a(SourceFile:101)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.FormattedStringFieldObject.do(SourceFile:138)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.AbstractFormattedTextualObject.a(SourceFile:282)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.w.for(SourceFile:126)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:428)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:250)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.a(SourceFile:922)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.e(SourceFile:784)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.f.e(SourceFile:383)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.for(SourceFile:242)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:243)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:210)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:185)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:230)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:511)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:452)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:369)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ah.a(SourceFile:72)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ReportColumnFormatter.a(SourceFile:86)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.d.for(SourceFile:355)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:338)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:250)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.a(SourceFile:922)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.e(SourceFile:784)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.f.e(SourceFile:383)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.for(SourceFile:242)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:243)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:210)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:185)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:230)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:511)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:452)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:369)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ah.a(SourceFile:72)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ReportColumnFormatter.a(SourceFile:86)

at com.crystaldecisions.reports.formatter.formatter.paginator.SinglePageFormatter.a(SourceFile:332)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120)

at com.crystaldecisions.reports.formatter.formatter.paginator.SinglePageFormatter.for(SourceFile:177)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.do(SourceFile:737)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.X(SourceFile:399)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(SourceFile:339)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.do(SourceFile:677)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.formatPage(SourceFile:236)

at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:96)

at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:247)

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(SourceFile:642)

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(SourceFile:586)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:636)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:672)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1944)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:661)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)

at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:223)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111)

Kind Regards,

Jose Orellana

[Former Member]

Hi Adam

I have found out that I get this problem whenever the text in the clob has this piece of html:

span style="color: black"

It is as if the HTML parser of the JRC does not like this "color:black". In the original .rpt file the Text Interpretation parameter is set to HTML text. When running the report from the CR client installation, there is no problem with this tag and color property. But when running in batch mode with JRC, it seems as if the HTML parser cannot cope with this tag; the text is truncated from the point where this tag and color property appears. Have you ever seen this problem before? Is this a known problem?

Thank you!