Table to big to purge rows (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Table to big to purge rows (AREV Specific) ====
=== At 30 JUN 1999 07:56:02PM Mick wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Hi. We are running Arev 3.11 on Novell 3.12, and I have a table that got too big to purge the rows from. I've even copied everything onto a non-network pc, and it still gives me the "maximum number of variable records exceeded...." error message. I looked at sizelock, and it is set to 0. The OV file is 15 megs, and the LK file is 32 megs. Does it sound like somthing is corrupted? I'm trying to copyrow about one months worth (maybe 30,000 rows) of data to another table, and it bombs about 5% into the process. Is the only way around this to write a routing to read/write/delete the rows one at a time? Thanks for any help...   -Mick-
</QUOTE>
----

=== At 30 JUN 1999 09:44PM Larry Wilson wrote:  ===

<QUOTE>When copying, try putting (SE at the end of the statement.  Usually it's the messages that overflow variables.

</QUOTE>

----

=== At 01 JUL 1999 09:32AM Michael Slack wrote:  ===

<QUOTE>If you are using a SELECT statement, you might try putting a row limiting number within the statement.  Such as:

SELECT 10000 table_name ...



The number can be what ever you want.  It will cause you to have to run your purge process several times to get it all but I assume that is better than not being able to do it at all.



Michael Slack

</QUOTE>

----

=== At 01 JUL 1999 10:07AM Mick wrote:  ===

<QUOTE>Thanks Larry and Michael, I'll give both of these a try tonight. I've been working on this at home to see what will finally work before I do it on our live system at work. Thanks again....



-Mick-

</QUOTE>

----

=== At 02 JUL 1999 04:37PM Mick wrote:  ===

<QUOTE>The (SE did the trick. It froze once in win95, so I tried it in Dos-Mode, and it worked. Thanks again!  -Mick-

</QUOTE>

----

=== At 05 JUL 1999 11:39AM Larry Wilson wrote:  ===

<QUOTE>No problem, glad to help.



I've got a number of FAQs on Rev/AREV issues on my website - you might want to copy them for future reference.



http://www.tardis.cc



Larry Wilson

larry@tardis.cc

TARDIS Systems, Inc.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=E11A50DBE391E463852567A00083794D|View this thread on the  forum...]]