Skip to Content
avatar image
Former Member

(SAP 9.1) Occasional ODBC error (-2039 and -1029)

Hi, we have a program (using SAP DIAPI) that does this to a list of sales orders:

  1. create incoming/outgoing payment
  2. update sales order
  3. go to #1 again until completed

This was working fine when we were still using 2007.

After we upgrade to 9.1, this is still OK, but occasionally (seems to happen randomly/no pattern) errors out with the following:

  • When creating incoming/outgoing payment, sometimes we get error:
    Another user or another operation modified data; to continue, open the window again (ODBC -2039)
  • When updating sales order (ie. DocDueDate as well as the items’ ShipDate fields), sometimes we get error:
    [ORDR.DocDueDate] , 'Field cannot be updated (ODBC -1029)'

FYI we're using 1 user account for the DIAPI, and no other user is connected/logged in using the same account.

Can anybody please advise what's wrong?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 14, 2016 at 04:59 PM

    Hi Tjandra,

    I believe that the first point, you can fix if you add an "start transaction" in the begin of process and call "end the transaction" in the end, but check if this is really necessary.

    About second point, checks if your document or lines that you need update is with open status.

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2016 at 06:28 PM

    Hi Diego, I'll test if I need to add start end end transactions. (NOTE: as I mentioned, in 2007 this worked perfectly)

    For 2nd point: the document is still open. The error was on ORDR.DocDueDate so I believe it's not due do a closed item.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded