Epicor 904 Schema Change Freezing

Yahoo Archive
1
You need to be looking at the Process tab, not the "application" tab on the
task manager.

The "Application" is not responding because the application you see is not
actually doing anything, it's just a drapery hanging up to make the window
look pretty while all the work is going on in the background.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
nustepvantage
Sent: Thursday, June 09, 2011 5:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 904 Schema Change Freezing

Thanks for the responses.

In the task manager ProWin32.exe is running and says it is not responding.
Memory usage steadily increases and CPU usage gets close to 100%. The
database bi file also grows. Once I just let the schema change application
go and it eventually stopped on its own. When I did this the bi file grew to
over 2 GB in size. I think it may have stopped when it ran out of memory.

Also, during phase 1 of the process when the schema change program scrolls
through the database tables and fields loading the table definitions it
always gets hung up early in the process usually stopping with tables
beginning with the letter A.

David

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> Are you sure it's locking up and not just taking forever? How much
> time have you given it? That one does take a while.
>
> On Wed, Jun 8, 2011 at 4:58 PM, nustepvantage <dpfiester@...> wrote:
>
> >
> >
> >
> > Hi All,
> >
> > I have a test VMWare virtual machine running Windows 2008 Server 64
> > bit that has Epicor 904.507A running Progress. I am trying to load a
> > backup copy of a Progress Vantage 803.409C database and convert it
> > to 904. When I attempt to run the change schema program it always
> > locks up during phase 1 of the schema change process when the program is
loading table definitions.
> > I truncated the bi file after I restored my 409C database to it
> > thinking that was the problem, but I still can't get beyond the
> > loading of table definitions. So far tech support hasn't been much
> > help. Has anyone in the group had this problem before?
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> > David Pfiester
> > NuStep, Inc.
> > 734-418-1850
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [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
2
Hi All,

I have a test VMWare virtual machine running Windows 2008 Server 64 bit that has Epicor 904.507A running Progress. I am trying to load a backup copy of a Progress Vantage 803.409C database and convert it to 904. When I attempt to run the change schema program it always locks up during phase 1 of the schema change process when the program is loading table definitions. I truncated the bi file after I restored my 409C database to it thinking that was the problem, but I still can't get beyond the loading of table definitions. So far tech support hasn't been much help. Has anyone in the group had this problem before?

Any help would be greatly appreciated.

Thanks,
David Pfiester
NuStep, Inc.
734-418-1850
3
Are you sure it's locking up and not just taking forever? How much time have
you given it? That one does take a while.

On Wed, Jun 8, 2011 at 4:58 PM, nustepvantage <dpfiester@...> wrote:

>
>
>
> Hi All,
>
> I have a test VMWare virtual machine running Windows 2008 Server 64 bit
> that has Epicor 904.507A running Progress. I am trying to load a backup copy
> of a Progress Vantage 803.409C database and convert it to 904. When I
> attempt to run the change schema program it always locks up during phase 1
> of the schema change process when the program is loading table definitions.
> I truncated the bi file after I restored my 409C database to it thinking
> that was the problem, but I still can't get beyond the loading of table
> definitions. So far tech support hasn't been much help. Has anyone in the
> group had this problem before?
>
> Any help would be greatly appreciated.
>
> Thanks,
> David Pfiester
> NuStep, Inc.
> 734-418-1850
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
4
I agree here, how much time have you given it? Its still running even though it doesn't look like it. Running a schema change took me about 6 hours and most of the time you cant see what its doing, it appears to be frozen when in fact its not.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Waffqle
Sent: Wednesday, June 08, 2011 3:07 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 904 Schema Change Freezing

Are you sure it's locking up and not just taking forever? How much time have
you given it? That one does take a while.

On Wed, Jun 8, 2011 at 4:58 PM, nustepvantage <dpfiester@...> wrote:

>
>
>
> Hi All,
>
> I have a test VMWare virtual machine running Windows 2008 Server 64 bit
> that has Epicor 904.507A running Progress. I am trying to load a backup copy
> of a Progress Vantage 803.409C database and convert it to 904. When I
> attempt to run the change schema program it always locks up during phase 1
> of the schema change process when the program is loading table definitions.
> I truncated the bi file after I restored my 409C database to it thinking
> that was the problem, but I still can't get beyond the loading of table
> definitions. So far tech support hasn't been much help. Has anyone in the
> group had this problem before?
>
> Any help would be greatly appreciated.
>
> Thanks,
> David Pfiester
> NuStep, Inc.
> 734-418-1850
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[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
5
It may look locked up, but chances are it is not.

Open up the Task Manager, and look for the ProWin32.exe, if there is
processor activity on it then it has not actually locked up on you and you
just need to wait it out.

It will vary in total time from an hour to up to 6 or so depending on how
many steps since last update to the schema and the size of your database.

Prowin32 will stop processor usage once in awhile for a few seconds but it
should normally bounce between 3 and 6% on a regular basis during the
process if it is working.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
nustepvantage
Sent: Wednesday, June 08, 2011 4:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 904 Schema Change Freezing


Hi All,

I have a test VMWare virtual machine running Windows 2008 Server 64 bit that
has Epicor 904.507A running Progress. I am trying to load a backup copy of a
Progress Vantage 803.409C database and convert it to 904. When I attempt to
run the change schema program it always locks up during phase 1 of the
schema change process when the program is loading table definitions. I
truncated the bi file after I restored my 409C database to it thinking that
was the problem, but I still can't get beyond the loading of table
definitions. So far tech support hasn't been much help. Has anyone in the
group had this problem before?

Any help would be greatly appreciated.

Thanks,
David Pfiester
NuStep, Inc.
734-418-1850




------------------------------------

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
6
Thanks for the responses.

In the task manager ProWin32.exe is running and says it is not responding. Memory usage steadily increases and CPU usage gets close to 100%. The database bi file also grows. Once I just let the schema change application go and it eventually stopped on its own. When I did this the bi file grew to over 2 GB in size. I think it may have stopped when it ran out of memory.

Also, during phase 1 of the process when the schema change program scrolls through the database tables and fields loading the table definitions it always gets hung up early in the process usually stopping with tables beginning with the letter A.

David

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> Are you sure it's locking up and not just taking forever? How much time have
> you given it? That one does take a while.
>
> On Wed, Jun 8, 2011 at 4:58 PM, nustepvantage <dpfiester@...> wrote:
>
> >
> >
> >
> > Hi All,
> >
> > I have a test VMWare virtual machine running Windows 2008 Server 64 bit
> > that has Epicor 904.507A running Progress. I am trying to load a backup copy
> > of a Progress Vantage 803.409C database and convert it to 904. When I
> > attempt to run the change schema program it always locks up during phase 1
> > of the schema change process when the program is loading table definitions.
> > I truncated the bi file after I restored my 409C database to it thinking
> > that was the problem, but I still can't get beyond the loading of table
> > definitions. So far tech support hasn't been much help. Has anyone in the
> > group had this problem before?
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> > David Pfiester
> > NuStep, Inc.
> > 734-418-1850
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
7
There's a good chance it's just taking a long time. I ran though this
process several times developing my cutover plan. It took just over 11
hours to change my schema from 9.04 (32 bit) to 9.05 (64 bit).



Gerry Loranger

Systems Administrator

Preformed Line Products

1711 Bishop St. East

Cambridge, ON N1T 1N5

519-740-6666 Ext. 224

Email: gloranger@... <mailto:gloranger@...>

Visit our website at www.preformed.on.ca <http://www.preformed.on.ca>







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