File Content Conversion pr

[Former Member]

Hi Guys,

I have a problem with a file-to-file scenario. It brings up the following error when trying to read the file i.e from the receiver:-

Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 3: missing structure(s) before type 'UserHeaderRec'

Structure:-

EFTRec 1-unbounded

Header 1

UserRec 1

StdTr 1-unbounded

ContraRec 1

UserTrailer 1

Trailer 1

The following is the Structure that I've defined from Config:-

Recordset Name = EFTRec

Recordset Structure = TxHeaderRec,1,UserHeaderRec,1,StndTransactionRec,*,ContraRec,1,TxTrailerRec,1

Does anyone have a solution to this problem?

[Former Member]

Hi,

one thing that I've seen is that <UserTrailerRec> is not mentioned in your Recordset Structure above. This may cause your problems.

Regards,

Ralph

[Former Member]

<?xml version="1.0" encoding="utf-8" ?>

- <ns:MT_SapIsuToLDSAbsa_EFT xmlns:ns="http://www.Coj.co.za/SapIsuToLDSAbsa/EFT">

- <EFTRec>

- <TxHeaderRec>

<Rec_Id>000</Rec_Id>

<Rec_Status>L</Rec_Status>

<Tx_Date>20070706</Tx_Date>

<BI_UserCode>10111</BI_UserCode>

<BI_IntUser_Name>Business Int User Name</BI_IntUser_Name>

<Tx_Number>0000000</Tx_Number>

<Destination>00000</Destination>

<Filler />

<User_Use>Revenue Refunds</User_Use>

<Filler_1 />

</TxHeaderRec>

- <UserHeaderRec>

<Rec_Id>020</Rec_Id>

<DataSet_St>L</DataSet_St>

<BankServ_RecId>04</BankServ_RecId>

<BankServ_UserCode>8141</BankServ_UserCode>

<BankServ_CreatDate>070706</BankServ_CreatDate>

<BankServ_PDate>070707</BankServ_PDate>

<Action_Date1>070706</Action_Date1>

<Action_Date2>070706</Action_Date2>

<First_SeqNo>000000</First_SeqNo>

<User_GenNo>0000</User_GenNo>

<Destination>00000</Destination>

<Filler />

<Serv_Type>SSV</Serv_Type>

<Accptd_Rpt>Y</Accptd_Rpt>

<Acc_Type>Y</Acc_Type>

<Filler_1 />

</UserHeaderRec>

- <StndTransactionRec>

<Rec_Id>020</Rec_Id>

<DataSet_St>L</DataSet_St>

<BankServ_RecId>10</BankServ_RecId>

<User_Branch>637956</User_Branch>

<User_NomAcc>04054398227</User_NomAcc>

<User_Code>8141</User_Code>

<User_SeqNo>000002</User_SeqNo>

<Homing_Branch>050015</Homing_Branch>

<Homing_AccNo>00000000000</Homing_AccNo>

<Acc_Type>0</Acc_Type>

<Amnt>10000340.60</Amnt>

<Action_Date>-07070</Action_Date>

<Entry_Class>68</Entry_Class>

<Tax_Code>8</Tax_Code>

<Filler>0</Filler>

<User_Ref>Craig Avon</User_Ref>

<Acc_name>STANDARD BANK SA</Acc_name>

<NonStd_HomingAccNo>0000000055454545454</NonStd_HomingAccNo>

<Filler_1>5</Filler_1>

<Homing_Inst>2</Homing_Inst>

<Filler_2>1</Filler_2>

</StndTransactionRec>

- <ContraRec>

<Rec_Id>020</Rec_Id>

<DataSet_St>L</DataSet_St>

<BankServ_RecId>12</BankServ_RecId>

<User_Branch>637956</User_Branch>

<User_NomAcc>04054398227</User_NomAcc>

<User_Code>8141</User_Code>

<User_SeqNo>000003</User_SeqNo>

<Homing_Branch>637956</Homing_Branch>

<Homing_AccNo>04054398227</Homing_AccNo>

<Acc_Type>0</Acc_Type>

<Amnt>10000340.60</Amnt>

<Action_Date>-07070</Action_Date>

<Entry_Class>61</Entry_Class>

<Filler>0000</Filler>

<User_Ref>0City O Jhb40543920070706REFUN</User_Ref>

<Filler_1 />

<Filler_2 />

</ContraRec>

- <UserTrailerRec>

<Rec_Id>020</Rec_Id>

<DataSet_St>L</DataSet_St>

<BankServ_RecId>92</BankServ_RecId>

<User_Code>8141</User_Code>

<First_SeqNo>000000</First_SeqNo>

<Last_SeqNo>000003</Last_SeqNo>

<Action_Date1>070706</Action_Date1>

<Action_Date2>070706</Action_Date2>

<NoDebit_Rec>000000</NoDebit_Rec>

<NoCredit_Rec>000001</NoCredit_Rec>

<Contra_RecNo>000001</Contra_RecNo>

<Total_Debit_Val>000000000.00</Total_Debit_Val>

<Total_Credit_Val>00000340.60-</Total_Credit_Val>

<Total_HomingAccNo>000000058599</Total_HomingAccNo>

<Filler />

</UserTrailerRec>

- <TxTrailerRec>

<Rec_Id>999</Rec_Id>

<DataSet_St>L</DataSet_St>

<Tx_RecNo>000000005</Tx_RecNo>

<Filler />

</TxTrailerRec>

</EFTRec>

</ns:MT_SapIsuToLDSAbsa_EFT>

[Former Member]

can u paste ur XML structure ??