Oracle SOA B2B : Slew Of Errors (Doc ID 2285960.1)

Last updated on AUGUST 16, 2024

Applies to:

Goal

Noticing errors for EDI X12 inbound scenario using JMS Binding.

Error 1

<DaemonWorkThread: '269' of WorkManager: 'wm/SOAWorkManager'> <> <> <nnnnnnnnnnnn> <nnnnn> <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> <machinename> <B2B server> <DaemonWorkThread: '269' of WorkManager: 'wm/SOAWorkManager'> <> <> <nnnnnnnn> <nnnnnn> <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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.