Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Exception when running report with CLOB

Received Response
174
Views
4
Comments
Wpateracki
Wpateracki Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

  • Wpateracki
    Wpateracki Rank 3 - Community Apprentice

    When removing the CLOB from the report, the XLSX works as expected.

  • Wpateracki
    Wpateracki Rank 3 - Community Apprentice

    Any ideas?

  • Violeta F
    Violeta F Rank 4 - Community Specialist

    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

  • Wpateracki
    Wpateracki Rank 3 - Community Apprentice

    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