ISTech Support Forum - reindex then pervasive rebuild

Welcome, Guest. Please Login.

	05/17/24 at 22:53:24 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›

Pages: 1

reindex then pervasive rebuild (Read 2319 times)

newline

Browser

Posts: 37

reindex then pervasive rebuild
01/28/14 at 03:40:21

We have some files that are 'out of order' since a reindex. (BKARCUST, BKARHIVL, BKARHINV)

For example viewing shipments in AR-A they are in a random order, not ordered by invoice number or date or anything that seems obvious.

Have tried using the command prompt RBLDCLI (following some instructions linked to somewhere on here) but not having much luck. undecided

Not sure if the key number is correct...

Any suggestions of anything else to try?

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: reindex then pervasive rebuild Reply #1 - 01/28/14 at 08:29:25 When you re-index the tables did you use DBA UT-C utility? Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: reindex then pervasive rebuild Reply #2 - 01/28/14 at 08:59:40 AR-A Shipments is BKARHINV, Key 0
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

newline

Browser

Posts: 37

Re: reindex then pervasive rebuild
Reply #3 - 02/10/14 at 21:03:23

When I reindexed I use the NZINDEX.RUN to do several files at once.

I've been ignoring this issue since I have to find time 'out of hours' when noone is using EVO to try and fix it.

When I initially tried the command prompt RBLDCLI, I don't think I did use Key 0, so maybe I muddled it up.

Since your responses below, I tried again using Key 0, didn't get any worse, but no improvement either.

Not sure how I can work out which key refers to which field in the file at the moment?

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: reindex then pervasive rebuild Reply #4 - 02/11/14 at 08:55:27 If you open the file using Maintain Database, the order of the indexes listed in the "Sort By" at the top is the key number order beginning with 0.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›