Skip to Content
0

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

Oct 14, 2016 at 04:31 PM

221

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

Hi Tjandra,

Could you share your code?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

DIEGO LOTHER Oct 14, 2016 at 04:59 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 14, 2016 at 06:28 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Tjandra,

I have mentioned the status of line because you said that you update Ship Date at line level, If I understood correctly.

Kind Regards,

Diego Lother

0