[5.2] dump and load problems

Yahoo Archive
1
I haven't seen Progress corruption but was able to fix Vantage corruption on
the JobAsmbl table with ProVision when Child/Next/BOMSequence fields were
corrupted. By the way, the V8 conversion can corrupt the BOMSequence -- it
renumbers the field producing duplicates in 6 of our jobs.

I don't understand why Epicor's solution wouldn't work on the normal Dump &
Load so you wouldn't have to buy ProVision. Maybe you could move the
corrupted tables to a different directory if the process would take too long
on all of them.

We use ProVision to update the database. It also provides a GUI programming
interface similar to Visual Basic that's much easier to program GUI than the
non-updating 4GL provided with Vantage. But beware of this powerful product
for without careful analysis, you can damage the database yourself real
easy.

----- Original Message -----
From: "Norm Watkins" <nwatkins@...>
To: "Vantage@Yahoogroups. Com" <vantage@yahoogroups.com>
Sent: Tuesday, September 20, 2005 6:27 AM
Subject: [Vantage][5.2] dump and load problems


> I have some db corruption, and am looking for a 'workaround' to the
problem.
>
> Trying to "dump and load" the db, it produces an error on the jobasmbl
> table, but continues, and then crashes on the labordtl table. Looking at
> the 'vantage.lg' file, it identifies several recid #s that are problems.
> I'm thinking that running idxfix and removing those corrupt recid's might
be
> a possibility. Has anyone had a similar problem, and is there a fix other
> than sending the db to Epicor and "running on paper" for however long it
> takes for them to fix it and get it back.
>
> Epicor said to selectively dump and load the tables with Provision, which
I
> don't have, and then run a program they got from Progress that "might" fix
> the problem. We're debating spending $4000 for Provision, not knowing if
> will solve the problem.
>
> As a side question - those of you that have/use Provision, is it worth the
> $? What can Provision do for me?
>
> thanks,
>
> Norm Watkins
> Engineering Manager
> ELECPAC
> Phone: 847-639-2307
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
2
I have some db corruption, and am looking for a 'workaround' to the problem.

Trying to "dump and load" the db, it produces an error on the jobasmbl
table, but continues, and then crashes on the labordtl table. Looking at
the 'vantage.lg' file, it identifies several recid #s that are problems.
I'm thinking that running idxfix and removing those corrupt recid's might be
a possibility. Has anyone had a similar problem, and is there a fix other
than sending the db to Epicor and "running on paper" for however long it
takes for them to fix it and get it back.

Epicor said to selectively dump and load the tables with Provision, which I
don't have, and then run a program they got from Progress that "might" fix
the problem. We're debating spending $4000 for Provision, not knowing if
will solve the problem.

As a side question - those of you that have/use Provision, is it worth the
$? What can Provision do for me?

thanks,

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307