Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Exception when running report with CLOB
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
Answers
-
When removing the CLOB from the report, the XLSX works as expected.
0 -
Any ideas?
0 -
Hi,
Please try the following:
1. Open the report and click on Edit
2. Click on Properties button on top left
3. Select the Formatting tab
4. Scroll down to the bottom
5. Find the property 'Use 11.1.1.5 compatibility mode' and set it to FALSE
6. Click OK
7. Save the report.
8. Retest
Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it.
Regards,
Violeta
0 -
Hi Violeta,
Thanks for the response. I have tried what you've suggested but that did not resolve the problem. I think the issue is related to the size of the CLOB. One of the CLOBs that fails is 33,872 bytes.
--
Bill
0