Skip to Content
avatar image
Former Member

Receiver file adapter error

I am getting the following error, the message mapping did not give any error and I have given all the fixed field lengths in the file adapter but still getting the error:

Attempt to process file failed with java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value '20060323' too long (>6 for 34. column) - must stop', probably configuration error in file adapter (XML parser error)'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 30, 2007 at 07:30 AM

    HI,

    There is a mapping error for 6 field. check it with SXMB_MONI source xml , come back to MM -- test tab , insert the xml in message mapping and check the runtime error.

    Are you using any file content conversion

    Regards

    Chilla

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 30, 2007 at 07:52 AM

    <b>20060323</b> ....this shud be a date field if i'm correct. check the lenght defintion in the DT for recv/target and also in the content converison

    Message was edited by:

    Prabhu S

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      this is quite easy... the 34th column is configured for 6 characters and you are trying to put ther elonger string...

      Peter

  • avatar image
    Former Member
    Apr 07, 2008 at 09:25 AM

    Hi sangita

    Attempt to process file failed with java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value '20060323' too long (>6 for 34. column) - must stop', probably configuration error in file adapter (XML parser error)'

    this problem seems to be with table field value.when you define field length and you give field value more then length.

    here you have defined field length 6 for your date field

    so possible solutions are

    1)go to your interface and in interface modify the field length for the column 34 (it must be date field)

    at present you have gieven field lenght 6

    and you are trying to enter a value (20060323) whose length is 8 so modify your date field

    2)or the second solution may be that if you dont want to modify your field table then you must give date in the format like

    06032003 instead of 20060323

    but preferable solution is the first one

    make the change and activate

    This will solve your problem

    Thanks

    Sandeep

    Ps: if helpful kindly reward points

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      This type of error occur only if the data type field of date exceed the maximum lenght permissible.

      So just go to that data type of Date you are using with this scenario and change the field length save and activate that.

      Any how this time you have to cancel the message.

      kindly rewards points if useful.

      Regards,

      Sumit Gupta

  • Mar 30, 2007 at 07:33 AM

    <i>Attempt to process file failed with java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: <b>Column value '20060323' too long (>6 for 34. column)</b> - must stop', probably configuration error in file adapter (XML parser error)'</i>

    is this the error you get in your adapter monitoring ?

    in that case check your FCC. check if you have given the length as 8 for 20060323 field !!!

    it seems u have given it as 6 ....

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2010 at 02:33 PM

    Closing this thread. Thanks to all who helped.

    Add comment
    10|10000 characters needed characters exceeded