Running a report without indexes
Kenneth Brody
kenbrody at spamcop.net
Thu Mar 21 12:33:56 PDT 2013
On 3/21/2013 3:05 PM, Jay Ashworth wrote:
> ----- Original Message -----
>> From: "Ian Wood" <iwood51 at gmail.com>
>
>> If it becomes a more persistent issue, Steve Wiltsie gave me a kludge
>> workaround, I can move the indexes to another location, run the
>> export, then move the indexes back.
>
> Or, to help diagnose it, if you have space and time, you could make a tarball
> every night of just the indexes (or, preferably, key, data, index, if you
> have space), and keep it until the next morning, when you've checked whether
> you had a runtime error or not.
>
> If/when you do, you'll have files that you can work with Support on, to
> determine why they're really invalid.
The OP said that it's on a Windows Server 2008 system. However, he has not
specifically stated whether or not the indexes in question are on a local
drive or a network share.
In either case, I might suggest checking the Windows event logs to see if
there were any network/disk errors recorded around the time of the failure.
(Both locally and the server, if on a network share.)
--
Kenneth Brody
More information about the Filepro-list
mailing list