Skip to Content
avatar image
Former Member

lock table overflow and background jobs are not running please explain

Hi,

There was a lock table overflow in our system.After the time the lock table over flow ocurred, the periodic jobs did not run.(there were no jobs in cancelled ststus).

If i am correct ,when the lock table over flow occured the atleast some dialog and background work processes were free then ideally the background jobs should have ideally started if not completed.

But job did not start at all..please tell what could be reason.or tell me how to analyze..

Thanks for your reply.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 30, 2008 at 02:42 PM

    Hi

    Pls check the count in SM12

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2008 at 02:51 PM

    its a really huge number..normally we see entries around 200-500..but wen the overflow occures the entries were aroubd 17500...but my question is why did the background jobs fail to start...

    Thanks for your inputs...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In most cases, If the lock table would not have any vacant places for additional update records, user initiated (e.g from transaction) request for update (from dialogue process ) would see in the status bar something like this: "Lock table overflow..", so dialogue wp wouldn't be busy any more.

      Vladimir