Get a Jumpstart with our Sample Apps
Results 1 to 5 of 5

Thread: Relation Exhausted

  1. #1
    Member
    Real Name
    Nancy Labbe
    Join Date
    Aug 2008
    Posts
    39

    Default Relation Exhausted

    In the orders database, when clicking on "New RECORD" this error appears. Can anyone tell me what it is?

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,382

    Default Re: Relation Exhausted

    Quote Originally Posted by NancyL View Post
    In the orders database, when clicking on "New RECORD" this error appears. Can anyone tell me what it is?
    Nancy

    I noticed that all of your other posts are in the A5v9 forum.

    Did this system move from A4 to A5v9?

    So many questions we must both have....

    I would check indices and/or rebuild them.

    Do you have a set with referential integrity turned on?

    Is there something about this order that is special? More lines, ....

    I noticed in the help file that it is error 1053.

    Does restarting Alpha eliminate the error?

    Can you post a sample that shows the error?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    Nancy Labbe
    Join Date
    Aug 2008
    Posts
    39

    Default Re: Relation Exhausted

    We are going to from A4 to A5V9. It seemed that every time there was a patch it would create another problem. It is my understanding there will be no more patches! Yeah! I'm not as concerned about the errors as much as the cross overs. We thought it was fixed by saving the items regions before continuing the order but it hasn't. When multiple users are entering orders, we soon as one clicks NEW ITEM, they see the items from another user.

  4. #4
    Member Chuck Bytes's Avatar
    Real Name
    Charles Luke
    Join Date
    Nov 2009
    Location
    Toronto, Ontario, Canada
    Posts
    138

    Default Re: Relation Exhausted

    This is an old post but also the only one related to the query I did on Relation exhausted Error

    I dont' really see a resolution posted on what this error is or how to fix it, but our organization just ran into the same problem.

    Just finished installing a patch upgrade and now when users try to enter new records, they get a "Relation exhausted" error and it does not allow for new records to be entered.

    Is there any updates on this error or what it is related to.

  5. #5
    Member Chuck Bytes's Avatar
    Real Name
    Charles Luke
    Join Date
    Nov 2009
    Location
    Toronto, Ontario, Canada
    Posts
    138

    Default Re: Relation Exhausted

    In case anyone runs into this error, it has something to do with indexes.
    I've rebuilt all indexes and the error seems to have gone away

    I suggest that a constant maintenance be performed on your data by rebuilding indexes on a regular basis.

    Probably nothing new for most users, but I tend to learn things the hard way :)

Similar Threads

  1. latest patch relation.add bug
    By Greg Suhok in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-14-2004, 03:02 PM
  2. v5 Spec in relation to file locking
    By Ian Marshall in forum Alpha Five Version 5
    Replies: 3
    Last Post: 07-18-2003, 05:12 AM
  3. relation problem
    By Rick Walworth in forum Alpha Five Version 4
    Replies: 1
    Last Post: 01-29-2003, 01:43 PM
  4. Memo field - Changing set relation
    By back4more in forum Alpha Five Version 4
    Replies: 4
    Last Post: 11-19-2000, 08:04 PM
  5. Relation Corrupt???
    By Phil Rolf in forum Alpha Five Version 4
    Replies: 3
    Last Post: 04-10-2000, 06:01 AM

Posting Permissions

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