Hello,
I have been trying to finalize an update from R1 to R2 in Retail Headquarters and Retail POS. I have been able to push all jobs and table data to the POS except for one - the ADDRESS table within the N-1010 job. This is the error that is generated in the POS AXRETAILMSG db: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done, table ‘ADDRESS’.
Some blogs mention that the problem may be that the data in one of the fields is too big. I did check the field lengths in the HQ AX SQL and in the POS. One outstanding difference that I see is the CITY field length. In AX is is 60 char long and in the POS ADDRESS table it is 30 char long.
Unfortunantly, many of our addresses from the R1 POS ‘Add Customer’ screen are longer than 30 characters - there was only one field in the UI for City, State and Zip so most ‘city’ names are fairly long.
Can anyone point me in the right direction to solve this issue? I have thought of a couple things that might work but any advice as to the correct solution would be very much appreciated.
Thank you,
Hank