Hi, This question is about the RMS Synchronize Offline Database feature, few months ago it use to work fine, but now it is doing this:
after close the POS, and when: Synchronize Offline Database > Synchronizing table: Item (it syncs nice the Alias and the Customer table, but is breaks when Item table and returns this message:)
Microsoft Store Operations POS Run-time error '-2147217833 (80040e57)': String or binary data would be truncated.
I tried this:
1- Since the POS client its a firewalled windows xp SP2 machine, I make 2 exeptions: I opened port 1433 with subnet scope, also enabled the C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe with subnet scope. and it makes no difference
2- I tried to create the database locally for testing but it cant be the same machine as the offline database. Things are the same.
3-I verified the data integrity of Item table and it seems to be ok, no duplicated items, no null lookup fields, etc. Things are the same.
4- I analize the source and target columns lenght and i fixed a difference of size in SubDescription3 field, but it makes no difference, the error code is the same and the halt of proccess persist like a nightmare
Thanks for readint this post