on 04-29-2008 1:30 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<?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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
can u paste ur XML structure ??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.