Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Translation Exception while reading input file - Urgent

35516Jun 30 2009 — edited Jul 1 2009
Hi,

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>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2009
Added on Jun 30 2009
17 comments
3,843 views