Oracle SOA B2B : Slew Of Errors

(Doc ID 2285960.1)

Last updated on AUGUST 16, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.7.8 and later
Information in this document applies to any platform.

Goal

Noticing errors for EDI X12 inbound scenario using JMS Binding.

Error 1


<DaemonWorkThread: '269' of WorkManager: 'wm/SOAWorkManager'> <> <> <1618cf2884db39ac:157459b6:15c69e2f1e1:-8000-00000000002734ee> <1496435098555> <BEA-000000> <Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Error Code: 24816
at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:296)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:758)
at oracle.toplink.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:133)


 Error 2

<Jun 2, 2017 2:24:57 PM MDT> <Error> <oracle.soa.adapter> <BEA-000000> <JMSAdapter <Composite Name> JmsConsumer_translateFromNative: Received TranslationException>>
####<Jun 2, 2017 2:24:57 PM MDT> <Notice> <Stdout> <slvgqz64.safeway.com> <eb2b_soa1> <DaemonWorkThread: '269' of WorkManager: 'wm/SOAWorkManager'> <> <> <1618cf2884db39ac:157459b6:15c69e2f1e1:-8000-00000000002733bf> <1496435097752> <BEA-000000> <ORABPEL-11211

DOM Parsing Exception in translator.
DOM parsing exception in inbound XSD translator while parsing InputStream.
Please make sure that the xml data is valid.

at oracle.tip.pc.services.translation.xlators.xsd.XSDTranslator.translateFromNative(XSDTranslator.java:302)
at oracle.tip.adapter.jms.inbound.JmsConsumer.translateFromNative(JmsConsumer.java:597)
at oracle.tip.adapter.jms.inbound.JmsConsumer.sendInboundMessage(JmsConsumer.java:413)
at oracle.tip.adapter.jms.inbound.JmsConsumer.send(JmsConsumer.java:1193)
at oracle.tip.adapter.jms.inbound.JmsConsumer.run(JmsConsumer.java:1073)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused by: oracle.xml.parser.v2.XMLParseException; lineNumber: 1; columnNumber: 1; Start of root element expected.
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:323)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:447)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:388)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:232)
at oracle.tip.pc.services.translation.xlators.xsd.XSDTranslator.translateFromNative(XSDTranslator.java:296)
... 7 more
>>

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms