Topic
  • 2 replies
  • Latest Post - ‏2013-07-03T11:31:04Z by KushakKain
AnujKhosla
AnujKhosla
1 Post

Pinned topic Email listener:Failed to create staging table record for e-mail address

‏2012-04-05T06:27:38Z |
Hi All,

Bellow error is occurring every time we trying to process incoming emails via listener. Can anybody help me out in determine the 'LS14811X0' field?

Incoming e-mail details - Sender E-mail Address: brittany_crump@cotyinc.com, Subject: L'Eau de Chloé - Reveal of TV Spot, Receive Date: Cannot retrieve date.
psdi.util.MXApplicationException BMXAA4049E - The value specified LS14811X0 exceeds the maximum field length.
at psdi.util.MaxType.checkLength(MaxType.java 517)
at psdi.util.MaxType.setValue(MaxType.java 426)
at psdi.mbo.MboValue._setValue(MboValue.java 1142)
at psdi.mbo.MboValue.setValue(MboValue.java 1052)
at psdi.mbo.Mbo.setValue(Mbo.java 1975)
at psdi.common.emailstner.EmailListnerTask.writeToDocInfoAndDocLinks(EmailListnerTask.java 1894)
at psdi.common.emailstner.EmailListnerTask.writeIntoInboundComm(EmailListnerTask.java 1795)
at psdi.common.emailstner.EmailListnerTask.readMessagesFromMailServer(EmailListnerTask.java 677)
at psdi.common.emailstner.EmailListnerTask.performTask(EmailListnerTask.java 232)
at psdi.common.emailstner.EmailListnerCron.cronAction(EmailListnerCron.java 49)
at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java 1549)
at psdi.server.CronTaskManager.access$400(CronTaskManager.java 83)
at psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java 2067)

Thanks,
ANuj khosla
Updated on 2012-04-05T17:25:14Z at 2012-04-05T17:25:14Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5842 Posts

    Re: Email listener:Failed to create staging table record for e-mail address

    ‏2012-04-05T17:25:14Z  
    Hi,

    I had the same issue a few years ago on Maximo 6.2.1.
    This is not the name of a field but the value it tries to put in a field.
    If I remember correctly, the email listener creates a doclink record and this value is the key.
    The field is 8 characters big and because you probably already used up the free numbers, it now becomes 8 long.
    Look up the field and change the size to 10 and you are back in business.

    Good luck,

    Marcel van der Heide
  • KushakKain
    KushakKain
    1 Post

    Re: Email listener:Failed to create staging table record for e-mail address

    ‏2013-07-03T11:31:04Z  
    Hi,

    I had the same issue a few years ago on Maximo 6.2.1.
    This is not the name of a field but the value it tries to put in a field.
    If I remember correctly, the email listener creates a doclink record and this value is the key.
    The field is 8 characters big and because you probably already used up the free numbers, it now becomes 8 long.
    Look up the field and change the size to 10 and you are back in business.

    Good luck,

    Marcel van der Heide

    In Table INBOUNDCOMM , increase the size of the emailaddress field to say 150.