Skip to Content
author's profile photo Former Member
Former Member

File Content Conversion pr

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2008 at 12:37 PM

    can u paste ur XML structure ??

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2008 at 01:15 PM

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

    - 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>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2008 at 10:05 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.