ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> INVTXN file missing after update
http://www.istechforum.com/YaBB.pl?num=1104759820

Message started by Aldon-LD on 01/03/05 at 05:43:40

Title: INVTXN file missing after update
Post by Aldon-LD on 01/03/05 at 05:43:40

AFter doing our last update, the INVTXN file was wiped out (12/20). From that point on, it is updating with current activity. No other files seem to be effected. If we reload the file from our 12/19 backup, is there a way to then append the current detail (12/20 - today) to it?
Lorraine

Title: Re: INVTXN file missing after update
Post by Lynn Pantic on 01/03/05 at 06:53:39

There is a Pervasive utility that can merge 2 files of the same data structure together which would accomplish what you need to do. Copy your 12/19 backup file into the same folder as your active data with a different extension so you have (for example) both INVTXN.B and INVTXN.BAK in the folder. Then in the Pervasive utilities, choose Maintenance - Data - Copy and copy from INVTXN.BAK to INVTXN.B.

Title: Re: INVTXN file missing after update
Post by Tim Keating on 01/03/05 at 09:01:04

Why would this happen?

Title: Re: INVTXN file missing after update
Post by Lynn Pantic on 01/03/05 at 09:56:52

That's a good question. I know they are a new IS Tech Support subscriber and had to run DBA update from a prior version before the IS Tech updates could be installed. The DBA Update did rebuild the INVTXN file back several versions ago so if they were updating from something really old, it may have had a problem with the rebuild. Recent DBA updates and the IS Tech updates have not rebuilt the INVTXN file.