Bitalk adapter pack 2.0: Polling Oracle DB, Error: ORA-02049: timeout: distributed transaction waiting for lock

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Bitalk adapter pack 2.0: Polling Oracle DB, Error: ORA-02049: timeout: distributed transaction waiting for lock

Viewing 0 reply threads
  • Author
    Posts
    • #24762

      I’m polling a stored procedure on an Oracle Database. The table I’m reading from is fed by a trigger on an ERP table (can’t touch the real table, only a “copy”)

      There is a HUGE amount of data in the table, so I’m just grabbing the first 1k records every 2 min. I sometimes get behind during big commits, but I always catch up within a few minutes.

      Once in a while we are seeing ORA-02049: timeout: distributed transaction waiting for lock.

      Has anyone else dealt with this? I can post my procedures if that will help.

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.