#4237 DB Blocking Payment allocation

R2.5.2
closed
nobody
5
2007-01-21
2007-01-09
vincentwong
No

Hi All,

We are implementing a Compiere system.
When some client PC doing the Payment Allocation, the compiere application seems to be hang for all client PC which are accessing the invoice, payment tables.

By monitoring in the oracle enterprise manager,there are some DB Blocking sessions occurs and the waiting time for more then 30 mins.

Is this a problem when the system handling a lot of transactions or necessary to wait for client session?

Thx!
Vincent

Discussion

  • vincentwong

    vincentwong - 2007-01-09

    Logged In: YES
    user_id=1024975
    Originator: YES

    The compiere version is 252d.
    The problem also happen in deleting an order, generate invoice.
    compiere is freezing.
    The oracle enterprise manager lists some oracle sessions are blocked by another session. On the blocking session i have:

    Current Status INACTIVE
    Serial Number 38400
    DB User Name COMPIERE
    OS Process ID 31593

    Wait
    Current Wait Event: SQL*Net message from client

    Current Wait Class: Idle
    Waiting for: 33 Minutes, 12Seconds
    P1: driver id 1297371904
    P2: #bytes 1

     
  • Jorg Janke

    Jorg Janke - 2007-01-14

    Logged In: YES
    user_id=87038
    Originator: NO

    Suggest you migrate to the current version. Seems to work there.

     
  • Jorg Janke

    Jorg Janke - 2007-01-14
    • status: open --> pending
     
  • SourceForge Robot

    • status: pending --> closed
     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 7 days (the time period specified by
    the administrator of this Tracker).

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks