Translation Exception while reading input file - Urgent
35516Jun 30 2009 — edited Jul 1 2009Hi,
I'm getting a Translation Exception while reading the input xml file. Appreicate if you can help me please as it is urgent. Below are the domain.log, the xml and xsd files I'm using.
Thanks
-Prapoorna
Here is the error in the domain.log
----------------------------------------------
<2009-06-30 18:53:09,245> <INFO> <verint.collaxa.cube.activation> <File Adapter::Inbound> Since a translation exception was thrown, this indicates that it is a non-debatching scenario.
<2009-06-30 18:53:09,246> <INFO> <verint.collaxa.cube.activation> <File Adapter::Inbound> Failed to translate file : {tmp/edi/TestOTLLoad.xml}
<2009-06-30 18:53:09,247> <INFO> <verint.collaxa.cube.activation> <File Adapter::Inbound> Sending message to Adapter Framework for rejection to user-configured rejection handlers : {
file=/tmp/edi/TestOTLLoad.xml, Exception=ORABPEL-11210
SAX Exception in translator.
SAX Exception raised while trying to SAX Parse InputStream .
Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
}
<2009-06-30 18:53:09,248> <WARN> <verint.collaxa.cube.activation> <AdapterFramework::Inbound> [Read_ptt::Read(time_and_attendance)]onReject: Sending invalid inbound message to Exception Handler: file:///prod/oemdata/oemhome/bpel/as/bpel/domains/verint/jca/TestOTLLoad/rejectedMessages
<2009-06-30 18:53:09,288> <ERROR> <verint.collaxa.cube.activation> <AdapterFramework::Inbound> onBatchFailure: Batch 'bpel://localhost/verint/TestOTLLoad~1.0//TestOTLLoad.xml_1246377188000' (/tmp/edi/TestOTLLoad.xml) has failed due to: ORABPEL-11008
Error while translating.
Error occured while translating content from file /tmp/edi/TestOTLLoad.xml [Caused by: <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected.]
Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
XML file:
----------
<time_and_attendance xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd">
<attendance_row>
<oracle_person_id>1373852</oracle_person_id>
<absence_reason></absence_reason>
<action_type>W</action_type>
<date>25/05/2009</date>
<total_hours>0</total_hours>
<last_update_date>26/05/2009 13:48:12</last_update_date>
</attendance_row>
<attendance_row>
<oracle_person_id>1373853</oracle_person_id>
<absence_reason></absence_reason>
<action_type>W</action_type>
<date>24/05/2009</date>
<total_hours>0</total_hours>
<last_update_date>26/05/2009 13:48:12</last_update_date>
</attendance_row>
</time_and_attendance>
XSD file:
-------------
<?xml version="1.0" encoding="UTF-8" ?>
<!--This Schema has been generated from a DTD. A target namespace has been added to the schema.-->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://TargetNamespace.com/ReadFile" xmlns="http://TargetNamespace.com/ReadFile" nxsd:version="DTD" xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd">
<xs:element name="oracle_person_id" type="xs:string"/>
<xs:element name="total_hours" type="xs:string"/>
<xs:element name="action_type" type="xs:string"/>
<xs:element name="last_update_date" type="xs:string"/>
<xs:element name="absence_reason">
<xs:complexType/>
</xs:element>
<xs:element name="attendance_row">
<xs:complexType>
<xs:sequence>
<xs:element ref="oracle_person_id"/>
<xs:element ref="absence_reason"/>
<xs:element ref="action_type"/>
<xs:element ref="date"/>
<xs:element ref="total_hours"/>
<xs:element ref="last_update_date"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="date" type="xs:string"/>
<xs:element name="time_and_attendance">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" ref="attendance_row"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>