View Full Version : Relation Exhausted


11-10-2009, 10:25 AM
In the orders database, when clicking on "New RECORD" this error appears. Can anyone tell me what it is?

Al Buchholz
11-10-2009, 11:38 AM
In the orders database, when clicking on "New RECORD" this error appears. Can anyone tell me what it is?

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?

11-10-2009, 11:56 AM
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.

Chuck Bytes
09-30-2010, 04:01 PM
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.

Chuck Bytes
09-30-2010, 08:39 PM
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 :)