8.00.800 to 8.03.305

Yahoo Archive
1
It's always finished with a message saying "0 errors" for me when converting 8.03.408 to 9.04.503b.

And 8.03.408 to 9.03.504.

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Chris wrote:
> > The Schema Change shouldn't disappear.
>
> It does (did) when you go to 9.04. It stops without a message after 8.03.500
> then you restart it and it takes you to 9.04.503. Epicor says it's a bug.
>
> Mark W.
>
2
I am trying to upgrade my database from 8.00 to 8.03

I restored an 8.0 backup to my 803 folder and repaired and truncated,
then started the database. I then went to 8.03 menu and ran Vantage
Schema Change. It runs then later I come back to it and it has
disappeared. I then go to the Vantage 8.03 Admint Tools and it tells me
database schema changes are required:

Database Level: 8.00.800

Program Level: 8.03.305



I go back to schema change and it shows the same info in the status
field. Am I missing something?



Toby Boogerd
Information Systems

712.324.4854 | tboogerd@... <mailto:tboogerd@...>


NOTICE: This email may contain confidential and proprietary information
of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.

Please consider the environment before printing this email.





[Non-text portions of this message have been removed]
3
I do believe you need to run schema change twice
First time gets db to 8.00.800
Next time gets it to 8.03.xxx

--- In vantage@yahoogroups.com, "Toby Boogerd" <tboogerd@...> wrote:
>
> I am trying to upgrade my database from 8.00 to 8.03
>
> I restored an 8.0 backup to my 803 folder and repaired and truncated,
> then started the database. I then went to 8.03 menu and ran Vantage
> Schema Change. It runs then later I come back to it and it has
> disappeared. I then go to the Vantage 8.03 Admint Tools and it tells me
> database schema changes are required:
>
> Database Level: 8.00.800
>
> Program Level: 8.03.305
>
>
>
> I go back to schema change and it shows the same info in the status
> field. Am I missing something?
>
>
>
> Toby Boogerd
> Information Systems
>
> 712.324.4854 | tboogerd@... <mailto:tboogerd@...>
>
>
> NOTICE: This email may contain confidential and proprietary information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
> recipient agrees not to use, reproduce, disclose, or manufacture its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> Please consider the environment before printing this email.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
The Schema Change shouldn't disappear. Does your server have a session timeout limit? If it's shorter than how long it takes to do the conversion, I suspect that's what happened. You should remove the timeouts for conversions... some of them can be quite long.

Also if you're on SQL, there's a file called ...clientserver\db\sql\vschmsql.dcd. You should save this BEFORE the conversion in case you have to run the conversion again. It keeps track of the schema changes. You should restore it from the original before running the Schema Change again. Not sure if this applies to versions before 8.03.405a.

----- Original Message -----
From: Toby Boogerd
To: vantage@yahoogroups.com
Sent: Wednesday, July 01, 2009 8:42 AM
Subject: [Vantage] 8.00.800 to 8.03.305


I am trying to upgrade my database from 8.00 to 8.03

I restored an 8.0 backup to my 803 folder and repaired and truncated,
then started the database. I then went to 8.03 menu and ran Vantage
Schema Change. It runs then later I come back to it and it has
disappeared. I then go to the Vantage 8.03 Admint Tools and it tells me
database schema changes are required:

Database Level: 8.00.800

Program Level: 8.03.305



I go back to schema change and it shows the same info in the status
field. Am I missing something?



Toby Boogerd
Information Systems

712.324.4854 | tboogerd@... <mailto:tboogerd@...>

[Non-text portions of this message have been removed]
5
Where do I look for this session timeout?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Robisch
Sent: Wednesday, July 01, 2009 11:22 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.00.800 to 8.03.305








The Schema Change shouldn't disappear. Does your server have a session
timeout limit? If it's shorter than how long it takes to do the
conversion, I suspect that's what happened. You should remove the
timeouts for conversions... some of them can be quite long.

Also if you're on SQL, there's a file called
...clientserver\db\sql\vschmsql.dcd. You should save this BEFORE the
conversion in case you have to run the conversion again. It keeps track
of the schema changes. You should restore it from the original before
running the Schema Change again. Not sure if this applies to versions
before 8.03.405a.

----- Original Message -----
From: Toby Boogerd
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, July 01, 2009 8:42 AM
Subject: [Vantage] 8.00.800 to 8.03.305

I am trying to upgrade my database from 8.00 to 8.03

I restored an 8.0 backup to my 803 folder and repaired and truncated,
then started the database. I then went to 8.03 menu and ran Vantage
Schema Change. It runs then later I come back to it and it has
disappeared. I then go to the Vantage 8.03 Admint Tools and it tells me
database schema changes are required:

Database Level: 8.00.800

Program Level: 8.03.305

I go back to schema change and it shows the same info in the status
field. Am I missing something?

Toby Boogerd
Information Systems

712.324.4854 | tboogerd@... <mailto:tboogerd%40rosenboom.com>
<mailto:tboogerd@... <mailto:tboogerd%40rosenboom.com> >

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
I don't think it is a session issue since I did this from 6.1 to 8.0 and
that happened throughout a span of 3 days



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Toby Boogerd
Sent: Wednesday, July 01, 2009 11:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.00.800 to 8.03.305








Where do I look for this session timeout?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Robisch
Sent: Wednesday, July 01, 2009 11:22 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] 8.00.800 to 8.03.305

The Schema Change shouldn't disappear. Does your server have a session
timeout limit? If it's shorter than how long it takes to do the
conversion, I suspect that's what happened. You should remove the
timeouts for conversions... some of them can be quite long.

Also if you're on SQL, there's a file called
...clientserver\db\sql\vschmsql.dcd. You should save this BEFORE the
conversion in case you have to run the conversion again. It keeps track
of the schema changes. You should restore it from the original before
running the Schema Change again. Not sure if this applies to versions
before 8.03.405a.

----- Original Message -----
From: Toby Boogerd
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, July 01, 2009 8:42 AM
Subject: [Vantage] 8.00.800 to 8.03.305

I am trying to upgrade my database from 8.00 to 8.03

I restored an 8.0 backup to my 803 folder and repaired and truncated,
then started the database. I then went to 8.03 menu and ran Vantage
Schema Change. It runs then later I come back to it and it has
disappeared. I then go to the Vantage 8.03 Admint Tools and it tells me
database schema changes are required:

Database Level: 8.00.800

Program Level: 8.03.305

I go back to schema change and it shows the same info in the status
field. Am I missing something?

Toby Boogerd
Information Systems

712.324.4854 | tboogerd@... <mailto:tboogerd%40rosenboom.com>
<mailto:tboogerd%40rosenboom.com>
<mailto:tboogerd@... <mailto:tboogerd%40rosenboom.com>
<mailto:tboogerd%40rosenboom.com> >

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
7
Chris wrote:
> The Schema Change shouldn't disappear.

It does (did) when you go to 9.04. It stops without a message after 8.03.500
then you restart it and it takes you to 9.04.503. Epicor says it's a bug.

Mark W.
8
If you are running MS SQL, personally I always prefer running the schema
changes manually instead of via the Schema change took, it's much faster.

epicor\mfgsys803\Clientserver\db\SQL


----- Original Message -----
From: "Chris Robisch" <bluewine@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, July 01, 2009 12:22 PM
Subject: Re: [Vantage] 8.00.800 to 8.03.305


> The Schema Change shouldn't disappear. Does your server have a session
> timeout limit? If it's shorter than how long it takes to do the
> conversion, I suspect that's what happened. You should remove the timeouts
> for conversions... some of them can be quite long.
>
> Also if you're on SQL, there's a file called
> ...clientserver\db\sql\vschmsql.dcd. You should save this BEFORE the
> conversion in case you have to run the conversion again. It keeps track of
> the schema changes. You should restore it from the original before running
> the Schema Change again. Not sure if this applies to versions before
> 8.03.405a.
>
> ----- Original Message -----
> From: Toby Boogerd
> To: vantage@yahoogroups.com
> Sent: Wednesday, July 01, 2009 8:42 AM
> Subject: [Vantage] 8.00.800 to 8.03.305
>
>
> I am trying to upgrade my database from 8.00 to 8.03
>
> I restored an 8.0 backup to my 803 folder and repaired and truncated,
> then started the database. I then went to 8.03 menu and ran Vantage
> Schema Change. It runs then later I come back to it and it has
> disappeared. I then go to the Vantage 8.03 Admint Tools and it tells me
> database schema changes are required:
>
> Database Level: 8.00.800
>
> Program Level: 8.03.305
>
>
>
> I go back to schema change and it shows the same info in the status
> field. Am I missing something?
>
>
>
> Toby Boogerd
> Information Systems
>
> 712.324.4854 | tboogerd@... <mailto:tboogerd@...>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
>
>