AX2009 - LS Retail Error

yassin

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

vinay_singh

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

Anisha

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