Options

AX2009 - LS Retail Error

yassinyassin Member Posts: 2
edited 2011-07-26 in Dynamics AX
Deal All,

Anyone has information on how to solve the belwo error:

IDispatch error #3092: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or sin

Comments

  • Options
    vinay_singhvinay_singh Member Posts: 6
    Hi,

    This error mainly comes when the datatype and size in the POS db is not similar to AX DB.
    Firstly, diagnose the subjob which is creating problem and then check the datatype and filed of the table of that particular subjob.

    Also, in the location card, Setup, location table check the datatype of RECID .
    It should be int and make the length 12.

    Regards,
    Vinay
    Vinay
    http://blog.vinaysingh.in/
    Committed to winning
  • Options
    AnishaAnisha Member Posts: 1
    Hi,

    I have the same issue. I did do what you have suggested but this is still not working.

    I receive the error in the message db on the POS machine.

    What else can I do?

    Thanking you in advance

    Regards,
    Anisha
Sign In or Register to comment.