Alpha Video Training
Results 1 to 2 of 2

Thread: Heap Lock Error

  1. #1
    Member
    Real Name
    D.Chiasson
    Join Date
    Jan 2004
    Location
    West Coast of Canada
    Posts
    632

    Default Heap Lock Error

    I have a client running an app in Alpha5, version4.0 & he was "attempting" to delete some records from a table with these indexes. There are "1070 records" in the file

    He got a HEAP LOCK ERROR.

    Name Order Exp Filter

    Completed WORKNO WORKSTAT="COMPLETED"
    Equipment EQUIPMENT
    Hold WORKNO WORKSTAT="HOLD"
    Open WORKNO WORKSTAT"""COMPLETED"
    Pm_Number PM_NUMBER
    Project PROJECT

    I would not say these indexes would be putting extensive demands on Alpha5

    What do you recommend he do?

    Thanks.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default RE: Heap Lock Error

    I recommend he update to v. 4.03 at least. Going to 4.5 would be better.

    I prefer not to ever use filtered indexes, so if I were troubleshooting this, I'd strip them out, and substitute new queries throughout the app where needed.

    Search this forum for other threads dealing with this error. Examine the sequence that was being done. If he was automating the deletion sequence with a script, the script itself may be the source of the problem. Something somewhere has cause Alpha Five to begin a process before previous processes were finished. For example, if undo on delete is present in a post field rule, a bulk deletion may overwhelm resources.

    -- tom

Similar Threads

  1. Error Message: "heap lock failure"
    By Jerry Jalbert in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-22-2004, 04:02 AM
  2. Heap Lock Failure error. Why?
    By Joseph Cincotta in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-02-2003, 05:18 AM
  3. HEAP LOCK error prevents updates to a table
    By Keven Thibeault in forum Alpha Five Version 4
    Replies: 10
    Last Post: 05-09-2002, 03:37 PM
  4. Got a heap lock in v4.5...
    By Stephen Williams in forum Alpha Five Version 4
    Replies: 0
    Last Post: 03-10-2001, 01:35 PM
  5. Heap Lock Failure
    By richardurban in forum Alpha Five Version 4
    Replies: 5
    Last Post: 12-21-2000, 05:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •