BI Publisher (MOSC)

MOSC Banner

ReqID34507608.txt

934101
934101 Posts: 17 Red Ribbon
edited Jul 24, 2014 5:32AM in BI Publisher (MOSC) 3 comments
Tagged:

Comments

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    There are usually multiple OPP logs as there are usually more than one running at the same time,

    so check all the files. I expect it is an empty file error: "Start of root element expected".

    Because the error in the program is fatal:.

    Calling XDO Data Engine...

    java.lang.ArrayIndexOutOfBoundsException: -16

        at oracle.sql.LnxLibThin.lnxnuc(LnxLibThin.java:6068)

        at oracle.sql.NUMBER.toText(NUMBER.java:2682)

    Run the program with DebugFlag = Y, it should provide more details.

    Kevin

  • 934101
    934101 Posts: 17 Red Ribbon

    Hi Kevin

    I checked the OPP log and below issue is shown:

    [7/24/14 2:16:57 AM] [OPPServiceThread1] Post-processing request 34514585.

    [7/24/14 2:16:58 AM] [411506:RT34514585] Executing post-processing actions for request 34514585.

    [7/24/14 2:16:58 AM] [411506:RT34514585] Starting XML Publisher post-processing action.

    [7/24/14 2:16:58 AM] [411506:RT34514585]

    Template code: AEXPESSSTATPFTLDREP

    Template app:  AEXP

    Language:      en

    Territory:     US

    Output type:   EXCEL

    [7/24/14 2:16:58 AM] [UNEXPECTED] [411506:RT34514585] java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

        at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:570)

        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:235)

        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)

        at oracle.apps.xdo.template.excel.ExcelController.processActionLanguage(ExcelController.java:337)

        at oracle.apps.xdo.template.excel.ExcelController.process(ExcelController.java:241)

        at oracle.apps.xdo.template.ExcelProcessor.process(ExcelProcessor.java:245)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:6159)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3458)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)

        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:282)

        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)

    Caused by: org.xml.sax.SAXParseException: <Line 6, Column 1>: XML-20210: (Fatal Error) Unexpected EOF.

        at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)

        at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:303)

        at oracle.xdo.parser.v2.XMLReader.popXMLReader(XMLReader.java:530)

        at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1312)

        at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)

        at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)

        at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)

        ... 15 more

    [7/24/14 2:16:58 AM] [411506:RT34514585] Completed post-processing actions for request 34514585.

    [7/24/14 2:27:45 AM] [OPPServiceThread2] Post-processing request 34514587.

    [7/24/14 2:27:45 AM] [411506:RT34514587] Executing post-processing actions for request 34514587.

    [7/24/14 2:27:45 AM] [411506:RT34514587] Starting XML Publisher post-processing action.

    [7/24/14 2:27:45 AM] [411506:RT34514587]

    Template code: AEXPESSSTATPFTLDREP

    Template app:  AEXP

    Language:      en

    Territory:     US

    Output type:   EXCEL

    [7/24/14 2:27:48 AM] [411506:RT34514587] XML Publisher post-processing action complete.

    [7/24/14 2:27:48 AM] [411506:RT34514587] Completed post-processing actions for request 34514587.

    7920K->56626K(153380K), 0.0213920 secs]

    [GC 99058K->57771K(153380K), 0.0239190 secs]

    [GC 100203K->58908K(153380K), 0.0203010 secs]

    [GC 101340K->60062K(153380K), 0.0206090 secs]

    [GC 102494K->61013K(153380K), 0.0211130 secs]

    Is it possible to investigate on the basis of this information ?

    Regards,

    Amit

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader
    edited Jul 24, 2014 8:20AM

    Hi Kevin

    I checked the OPP log and below issue is shown:

    [7/24/14 2:16:57 AM] [OPPServiceThread1] Post-processing request 34514585.

    [7/24/14 2:16:58 AM] [411506:RT34514585] Executing post-processing actions for request 34514585.

    [7/24/14 2:16:58 AM] [411506:RT34514585] Starting XML Publisher post-processing action.

    [7/24/14 2:16:58 AM] [411506:RT34514585]

    Template code: AEXPESSSTATPFTLDREP

    Template app:  AEXP

    Language:      en

    Territory:     US

    Output type:   EXCEL

    [7/24/14 2:16:58 AM] [UNEXPECTED] [411506:RT34514585] java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

        at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:570)

        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:235)

        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)

        at oracle.apps.xdo.template.excel.ExcelController.processActionLanguage(ExcelController.java:337)

        at oracle.apps.xdo.template.excel.ExcelController.process(ExcelController.java:241)

        at oracle.apps.xdo.template.ExcelProcessor.process(ExcelProcessor.java:245)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:6159)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3458)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)

        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:282)

        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)

    Caused by: org.xml.sax.SAXParseException: <Line 6, Column 1>: XML-20210: (Fatal Error) Unexpected EOF.

        at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)

        at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:303)

        at oracle.xdo.parser.v2.XMLReader.popXMLReader(XMLReader.java:530)

        at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1312)

        at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)

        at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)

        at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)

        ... 15 more

    [7/24/14 2:16:58 AM] [411506:RT34514585] Completed post-processing actions for request 34514585.

    [7/24/14 2:27:45 AM] [OPPServiceThread2] Post-processing request 34514587.

    [7/24/14 2:27:45 AM] [411506:RT34514587] Executing post-processing actions for request 34514587.

    [7/24/14 2:27:45 AM] [411506:RT34514587] Starting XML Publisher post-processing action.

    [7/24/14 2:27:45 AM] [411506:RT34514587]

    Template code: AEXPESSSTATPFTLDREP

    Template app:  AEXP

    Language:      en

    Territory:     US

    Output type:   EXCEL

    [7/24/14 2:27:48 AM] [411506:RT34514587] XML Publisher post-processing action complete.

    [7/24/14 2:27:48 AM] [411506:RT34514587] Completed post-processing actions for request 34514587.

    7920K->56626K(153380K), 0.0213920 secs]

    [GC 99058K->57771K(153380K), 0.0239190 secs]

    [GC 100203K->58908K(153380K), 0.0203010 secs]

    [GC 101340K->60062K(153380K), 0.0206090 secs]

    [GC 102494K->61013K(153380K), 0.0211130 secs]

    Is it possible to investigate on the basis of this information ?

    Regards,

    Amit

    This is pretty much the same basic error: the base program failed after starting to write the file.

    So the issue is your Data Template extract.

    Run the program with DebugFlag = Y, it should provide more details in the request log.

    You can also test your queries using SQL Developer.

    Kevin

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center