Skip to Content
0
Aug 09, 2023 at 06:05 AM

Another user or another operation modified data; to continue, open the window again (ODBC -2039)

51 Views Last edit Aug 09, 2023 at 06:13 AM 2 rev

Hi everyone,

I receive this error message when I try to pick a picking by Service Layer (SBO 10.0 FP 2208).

Steps:

1) I create an order sales by UI API

2) I create a picking by UI API

3) call to service layer twice (one to set the order sales batchnumbers, and another to set the picking batchnumbers). I need to call twice because sBO needs to set the batchnumbers first in order.

Call to set order sales batchnumbers, and then all to set picking batchnumbers:

{
    "DocumentLines": [{
            "LineNum": 0,
            "BatchNumbers": [{
                    "BatchNumber": "1",
                    "Quantity": 1080.0,
                    "BaseLineNumber": 0,
                    "ItemCode": "0001",
                    "SystemSerialNumber": 30
                }
            ]
        }, {
            "LineNum": 1,
            "BatchNumbers": [{
                    "BatchNumber": "1",
                    "Quantity": 60.0,
                    "BaseLineNumber": 1,
                    "ItemCode": "0065",
                    "SystemSerialNumber": 4
                }
            ]
        }
    ]
}
{
    "PickListsLines": [{
            "LineNumber": 0,
            "PickedQuantity": 3.0,
            "BatchNumbers": [{
                    "BatchNumber": "1",
                    "Quantity": 1080.0,
                    "BaseLineNumber": 0,
                    "ItemCode": "0001",
                    "SystemSerialNumber": 30
                }
            ]
        }, {            
            "LineNumber": 1,
            "PickedQuantity": 2.0,
            "BatchNumbers": [{
                    "BatchNumber": "1",
                    "Quantity": 60.0,
                    "BaseLineNumber": 1,
                    "ItemCode": "0065",
                    "SystemSerialNumber": 4
                }
            ]
        }
    ]
}
For the second call i receive the eror message:Another user or another operation modified data; to continue, open the window again (ODBC -2039)
To fix it I have to open the picking by UI and pick it. After that, I can remove all quantities and then I can call the two calls without problems.I can not set the batchnumbers by service layer just after create the picking by UI.I seems like after create a picking by SBO, something remain opened. Thanks in advance.