Vantage 5 Conversion?

Yahoo Archive
1
Tim:

This is a issue usually comes around with databases from about 900 meg and
larger. Your best bet is to stop the database which it seems you have,
scrap the 4.0 database which you copied over, and then copy a fresh database
back over. Perform a prostrct repair on the drive which the database sits,
open the schema.vtg file, change the connect options to just -1 (you can put
a colon or semi colon in front of your old one), Do not restart your
database, the -1 is connecting as a single user,and then try your schema
again. This reduced my time to about 3 hours total. Remember to put back
your connect options plus perform another prostrct repair when you are done.


If you have any questions about this process you may contact me offline or
contact Epicor support.

Respectfully,

Mark Engemann
Business Application Manager
Hydromat, Inc. / Turmatic Systems
Voice: 314.432.4644
Fax: 314.692-9195
E-mail: mengemann@... / mengemann@...


-----Original Message-----
From: Tim Care [mailto:ecfmis@...]
Sent: Tuesday, January 02, 2001 7:44 AM
To: vantage@egroups.com
Subject: [Vantage] Vantage 5 Conversion?


Has anyone run into any problems doing their
conversion to 5.0? I started last week, trying to
load it onto a test system, and as of noon today,
the Schema change to go between 4 and 5 will have
been running for 4 days. I'm going to stop it, and
try again, is there anything I can check before running
the change to verify my database, and ensure that it
will run? Any other suggestions for this step? Our
DB is about 1 GB, and I was following the installation
instructions that I downloaded from the Epicor support
web site. Thanks in advance.

Tim Care
Electro Chemical Finishing


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
2
Has anyone run into any problems doing their
conversion to 5.0? I started last week, trying to
load it onto a test system, and as of noon today,
the Schema change to go between 4 and 5 will have
been running for 4 days. I'm going to stop it, and
try again, is there anything I can check before running
the change to verify my database, and ensure that it
will run? Any other suggestions for this step? Our
DB is about 1 GB, and I was following the installation
instructions that I downloaded from the Epicor support
web site. Thanks in advance.

Tim Care
Electro Chemical Finishing
3
If you turn off the crash protect on the database (per instructions from
epicor), the schemachange will run much much faster. I have it on a test
server with a 350 meg database. With write protect off it took about 10 1/2
hrs and 2 hrs to do the data conversions. MAKE SURE YOU TURN WRITE PROTECT
BACK ON!!! I rebooted the server before turning it back on and the database
was corrupted and had to start over. This time, after running the
schemachange, I turned the crash protect back on and then started the
dataconversions and it took 9 hours this time. My guess is it has the same
effect on the schemachange, so I can't imagine how long that might take with
crash protect on if the dataconversions took almost 4 times as long. This
is what I found. REMEMBER TO TURN CRASH PROTECT BACK ON!!!

Michael Podlin

-----Original Message-----
From: Tim Care [mailto:ecfmis@...]
Sent: Tuesday, January 02, 2001 7:44 AM
To: vantage@egroups.com
Subject: [Vantage] Vantage 5 Conversion?


Has anyone run into any problems doing their
conversion to 5.0? I started last week, trying to
load it onto a test system, and as of noon today,
the Schema change to go between 4 and 5 will have
been running for 4 days. I'm going to stop it, and
try again, is there anything I can check before running
the change to verify my database, and ensure that it
will run? Any other suggestions for this step? Our
DB is about 1 GB, and I was following the installation
instructions that I downloaded from the Epicor support
web site. Thanks in advance.

Tim Care
Electro Chemical Finishing


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
4
I followed the install instructions, ran the reindex, and then
turned off Crash protection before running the schema change.
Even with that, it was running all weekend, and came in this
morning, and it was still running. I don't think that the schema
change should take 96 hours (even with Crash Protection on).
I'm going to try again...................................................

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: "Podlin, Michael" <michael.podlin@...>
To: <vantage@egroups.com>
Sent: Tuesday, January 02, 2001 8:52 AM
Subject: RE: [Vantage] Vantage 5 Conversion?


> If you turn off the crash protect on the database (per instructions from
> epicor), the schemachange will run much much faster. I have it on a test
> server with a 350 meg database. With write protect off it took about 10
1/2
> hrs and 2 hrs to do the data conversions. MAKE SURE YOU TURN WRITE
PROTECT
> BACK ON!!! I rebooted the server before turning it back on and the
database
> was corrupted and had to start over. This time, after running the
> schemachange, I turned the crash protect back on and then started the
> dataconversions and it took 9 hours this time. My guess is it has the
same
> effect on the schemachange, so I can't imagine how long that might take
with
> crash protect on if the dataconversions took almost 4 times as long. This
> is what I found. REMEMBER TO TURN CRASH PROTECT BACK ON!!!
>
> Michael Podlin
>
> -----Original Message-----
> From: Tim Care [mailto:ecfmis@...]
> Sent: Tuesday, January 02, 2001 7:44 AM
> To: vantage@egroups.com
> Subject: [Vantage] Vantage 5 Conversion?
>
>
> Has anyone run into any problems doing their
> conversion to 5.0? I started last week, trying to
> load it onto a test system, and as of noon today,
> the Schema change to go between 4 and 5 will have
> been running for 4 days. I'm going to stop it, and
> try again, is there anything I can check before running
> the change to verify my database, and ensure that it
> will run? Any other suggestions for this step? Our
> DB is about 1 GB, and I was following the installation
> instructions that I downloaded from the Epicor support
> web site. Thanks in advance.
>
> Tim Care
> Electro Chemical Finishing
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>