Summary
Exception when running report with CLOB
Content
Hi everyone,
I created a data model that has a CLOB field. I tested the data model from within the BIP web console and it successfully returned data. I then created a report for it directly from the data model page. Testing the "interactive" format from the BIP web console works, however testing other formats fail.
Generating CSV results in this exception:
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.lang.StringIndexOutOfBoundsException: String index out of range: -24549[[
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:411)
at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:86)
at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:61)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.lang.StringIndexOutOfBoundsException: String index out of range: -24549
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:878)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1418)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:395)
... 6 more
Caused by: oracle.xdo.XDOException: java.lang.StringIndexOutOfBoundsException: String index out of range: -24549
at oracle.xdo.common.xml.flatten.FlattenXML.process(FlattenXML.java:331)
at oracle.xdo.servlet.CoreProcessor.generateCSV(CoreProcessor.java:1814)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:590)
... 9 more
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -24549
at java.lang.String.<init>(String.java:196)
at java.lang.String.valueOf(String.java:3032)
at oracle.xdo.common.xml.flatten.RAFReadCharsHelper._readChars(ElementValue.java:528)
at oracle.xdo.common.xml.flatten.RAFReadCharsHelper.readChars(ElementValue.java:521)
at oracle.xdo.common.xml.flatten.ValueStruct.read(ElementValue.java:436)
at oracle.xdo.common.xml.flatten.ElementValue.read(ElementValue.java:235)
at oracle.xdo.common.xml.flatten.ElementValue.loadFromFile(ElementValue.java:219)
at oracle.xdo.common.xml.flatten.ElementModel.loadFromFile(ElementModel.java:539)
at oracle.xdo.common.xml.flatten.ElementModel.loadElementValueWithCache(ElementModel.java:525)
at oracle.xdo.common.xml.flatten.ElementModel.flattenGetData(ElementModel.java:746)
at oracle.xdo.common.xml.flatten.ElementModel.flattenGetData(ElementModel.java:730)
at oracle.xdo.common.xml.flatten.DataModel.flattenGetData(DataModel.java:154)
at oracle.xdo.common.xml.flatten.DocLoader.writeCSV(DocLoader.java:263)
at oracle.xdo.common.xml.flatten.DocLoader.process(DocLoader.java:200)
at oracle.xdo.common.xml.flatten.FlattenXML.process(FlattenXML.java:316)
... 11 more
This is the exception when generating XLSX:
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDORuntimeException: Failed in writing XLSX tmp file.[[
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:411)
at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:86)
at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:61)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDORuntimeException: Failed in writing XLSX tmp file.
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:878)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1418)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:395)
... 6 more
Caused by: oracle.xdo.servlet.data.DataException: oracle.xdo.XDORuntimeException: Failed in writing XLSX tmp file.
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:750)
... 9 more
Caused by: oracle.xdo.XDORuntimeException: Failed in writing XLSX tmp file.
at oracle.xdo.flowgenerator.spreadsheet.SpreadsheetGenerator.createLeafNode(SpreadsheetGenerator.java:1525)
at oracle.xdo.flowgenerator.spreadsheet.SpreadsheetGenerator.addParagraph(SpreadsheetGenerator.java:609)
at oracle.xdo.generator.pseudo.FlowLayoutGenerator.endParagraph(FlowLayoutGenerator.java:992)
at oracle.xdo.template.fo.area.BlockArea.doFlowOutput(BlockArea.java:775)
at oracle.xdo.template.fo.area.TableCell.doFlowOutput(TableCell.java:549)
at oracle.xdo.template.fo.area.TableRow.doFlowOutput(TableRow.java:761)
at oracle.xdo.template.fo.area.TableBody.doFlowOutput(TableBody.java:242)
at oracle.xdo.template.fo.area.TableArea.doFlowOutput(TableArea.java:528)
at oracle.xdo.template.fo.area.BlockArea.doFlowOutput(BlockArea.java:729)
at oracle.xdo.template.fo.area.BlockArea.doFlowOutput(BlockArea.java:729)
at oracle.xdo.template.fo.area.BlockArea.doFlowOutput(BlockArea.java:729)
at oracle.xdo.template.fo.area.NormalFlowReferenceArea.doFlowOutput(NormalFlowReferenceArea.java:81)
at oracle.xdo.template.fo.area.SpanReferenceArea.doFlowOutput(SpanReferenceArea.java:203)
at oracle.xdo.template.fo.area.BodyRegionArea.doFlowOutput(BodyRegionArea.java:156)
at oracle.xdo.template.fo.area.PageArea.doFlowOutput(PageArea.java:1079)
at oracle.xdo.template.fo.area.AreaTree.doOutput(AreaTree.java:585)
at oracle.xdo.template.fo.elements.FormattingEngine.startLayout(FormattingEngine.java:455)
at oracle.xdo.template.fo.elements.FormattingEngine.run(FormattingEngine.java:165)
at oracle.xdo.template.fo.FOHandler.endElement(FOHandler.java:606)
at oracle.xdo12c.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:211)
at oracle.xdo12c.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1666)
at oracle.xdo12c.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:458)
at oracle.xdo12c.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:404)
at oracle.xdo12c.parser.v2.XMLParser.parse(XMLParser.java:246)
at sun.reflect.GeneratedMethodAccessor3899.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.xdo.common.xml.XDOSAXParser.invokeParse(XDOSAXParser.java:300)
at oracle.xdo.common.xml.XDOSAXParser.parse(XDOSAXParser.java:149)
at oracle.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:441)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1278)
at oracle.xdo.template.FOPWrapper.generate(FOPWrapper.java:45)
at oracle.xdo.template.online.dms.mediation.ReportingService.generateReport(ReportingService.java:202)
at oracle.xdo.servlet.XDLCoreProcessor.transform(XDLCoreProcessor.java:179)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:647)
... 9 more
Caused by: oracle.xdo.XDOIOException: Failed to write LeafNode
at oracle.xdo.common.io.tree.LeafNode.writeToByteBuffer(LeafNode.java:208)
at oracle.xdo.common.io.tree.LeafNode.writeNode(LeafNode.java:227)
at oracle.xdo.common.io.tree.NavigableTree.createNode(NavigableTree.java:168)
at oracle.xdo.flowgenerator.spreadsheet.SpreadsheetGenerator.createLeafNode(SpreadsheetGenerator.java:1518)
... 43 more
Caused by: java.io.UTFDataFormatException: encoded string too long: 170970 bytes
at java.io.DataOutputStream.writeUTF(DataOutputStream.java:364)
at java.io.DataOutputStream.writeUTF(DataOutputStream.java:323)
at oracle.xdo.common.io.tree.LeafNode.writeString(LeafNode.java:432)
at oracle.xdo.flowgenerator.chunks.Text.writeData(Text.java:96)
at oracle.xdo.common.io.tree.LeafNode.writeVector(LeafNode.java:391)
at oracle.xdo.flowgenerator.Paragraph.writeData(Paragraph.java:1135)
at oracle.xdo.flowgenerator.spreadsheet.SSParagraph.writeData(SSParagraph.java:123)
at oracle.xdo.common.io.tree.LeafNode.writeToByteBuffer(LeafNode.java:203)
... 46 more
Any ideas how to remedy this? I need the report as a tab delimited CSV file.
I'm using BIP 12.2.1.2.
Thanks,
Bill
