AppServer's crashing when starting up

I guess you better since I got some of them from Epicor Support. Have no idea why the Stack Size (-s) needs such a larger number... they're probably setting it for worst case. But the # DB Buffers was definitely a problem when the AppServers needed to address their memory. We're using OpenEdge Studio on a SQL database so we mistakenly thought we needed more DB Buffers but that would just have the information in memory twice, once for OpenEdge and again in the SQL buffers.
----- Original Message -----
From: "clive.1972" <clive.1972@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, April 22, 2008 12:26 AM
Subject: [Vantage] Re: AppServer's crashing when starting up


Your Open Edge black magic seems to have done the trick !.

I've changed all the .pf files so that they have the text below and
they all start up first time. I doubt it does but I'll check out the
Progress website to see if it describes exactly what each switch
achieves so I have some sort of idea as to what I've actualy just
done ;)

Thank you so much for your help. Are you happy for me to pass this
onto Epicor when I close the support call I had on this problem ?.


--- In vantage@yahoogroups.com, "Chris Robisch" <bluewine@...> wrote:
>
> Try -Bt 1024 -s 8000 and for 10.1, replace the zpr...0 with
PRGRS_NATIVE_LOCKWAIT,60000.
>
> I've also seen too big a number in # DB Buffers preventing the
AppServers starting properly. Use 10,000 on an SQL database.
>
> ----- Original Message -----
> From: "clive.1972" <clive.1972@...>
> To: <vantage@yahoogroups.com>
> Sent: Monday, April 21, 2008 6:55 AM
> Subject: [Vantage] Re: AppServer's crashing when starting up
>
>
> Will do.
>
> When I reboot the physical server I can guarantee that the
MfgSys803
> AppServer does not becoem active, the .pf contains the following...
>
> -Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
> tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5
>
> -T D:\epicor\mfgwrk803
>
> -db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh
>
> -db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
> PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0
>
> ... I'm not certain how to obtain the other info that you'd like ?.
>
> Our MfgTrain803 is a copy of our live data, as indeed are the other
> two, and they all have the same problem.
>
> For some more history this problem occured about a week after
> upgrading from v8.03.305 to .404. However, things went a bit wobbly
> with the upgrade so in the end a complete re-install of Open Edge
and
> Vantage occured so all that remains from .305 is our production
data
> (in SQL 2005).
>
> I've also got a VMware Server VM running v8.03.404 with our
> production data and this problem does not occur on it.
>
> Thanks.
>
> --- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@>
> wrote:
> >
> > If you provide
> >
> > .pf file for your appservers
> >
> > Other settings - from PET broker and agent
sections
> >
> > People may be able to help
> >
> >
> >
> > Do you get the same occur in the training environment?
> >
> > What parameters have been changed outside of a default vantage
> install,
> > has the issue always occurred?
> >
> > Why not install a default vantage installation on another machine
> > (virtual) then see if the issue remains?
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of clive.1972
> > Sent: 21 April 2008 13:15
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] AppServer's crashing when starting up
> >
> >
> >
> > I'm running the following...
> >
> > Vantage v8.03.404
> > OpenEdge 10.1B + sp3 + hotfix 9
> > SQL 2005 + SP2
> >
> > ... and I've somehow ended up with a problem where my AppServer's
> in
> > Progress Explorer allways crash when starting up.
> >
> > For example I startup the MfgSys803 appserver and it just hangs
> there
> > saying 'starting', and if I go to the details tab of the
appserver
> > out of the five threads/workers (?) at least one of them never
> > becomes active. I then have to stop the Open Edge admin service
and
> > then kill off all of the hung processes using Task Manager. Then
I
> > can finaly restart the service and load the appserver's for
> > MfgSys803, I can usual only successfully launch one instance of
> > Vantage after this so I can't run a live and a training db at the
> > same time :(
> >
> > I've logged a support call with Epicor UK, and after applying
> various
> > patches and waiting too long for a response from them they state
> that
> > this problem apparently resides with Open Edge and Progress are
> > working on a fix for it ? (and that this is happening to many
> Vantage
> > users).
> >
> > Has anyone else had a similar problem at all ?.
> >
> > Thanks.
> >
> >
> >
> >
> >
> > [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
>
>
>
> [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



[Non-text portions of this message have been removed]
I'm running the following...

Vantage v8.03.404
OpenEdge 10.1B + sp3 + hotfix 9
SQL 2005 + SP2

... and I've somehow ended up with a problem where my AppServer's in
Progress Explorer allways crash when starting up.

For example I startup the MfgSys803 appserver and it just hangs there
saying 'starting', and if I go to the details tab of the appserver
out of the five threads/workers (?) at least one of them never
becomes active. I then have to stop the Open Edge admin service and
then kill off all of the hung processes using Task Manager. Then I
can finaly restart the service and load the appserver's for
MfgSys803, I can usual only successfully launch one instance of
Vantage after this so I can't run a live and a training db at the
same time :(

I've logged a support call with Epicor UK, and after applying various
patches and waiting too long for a response from them they state that
this problem apparently resides with Open Edge and Progress are
working on a fix for it ? (and that this is happening to many Vantage
users).

Has anyone else had a similar problem at all ?.

Thanks.
If you provide

.pf file for your appservers

Other settings - from PET broker and agent sections

People may be able to help



Do you get the same occur in the training environment?

What parameters have been changed outside of a default vantage install,
has the issue always occurred?

Why not install a default vantage installation on another machine
(virtual) then see if the issue remains?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of clive.1972
Sent: 21 April 2008 13:15
To: vantage@yahoogroups.com
Subject: [Vantage] AppServer's crashing when starting up



I'm running the following...

Vantage v8.03.404
OpenEdge 10.1B + sp3 + hotfix 9
SQL 2005 + SP2

... and I've somehow ended up with a problem where my AppServer's in
Progress Explorer allways crash when starting up.

For example I startup the MfgSys803 appserver and it just hangs there
saying 'starting', and if I go to the details tab of the appserver
out of the five threads/workers (?) at least one of them never
becomes active. I then have to stop the Open Edge admin service and
then kill off all of the hung processes using Task Manager. Then I
can finaly restart the service and load the appserver's for
MfgSys803, I can usual only successfully launch one instance of
Vantage after this so I can't run a live and a training db at the
same time :(

I've logged a support call with Epicor UK, and after applying various
patches and waiting too long for a response from them they state that
this problem apparently resides with Open Edge and Progress are
working on a fix for it ? (and that this is happening to many Vantage
users).

Has anyone else had a similar problem at all ?.

Thanks.





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

When I reboot the physical server I can guarantee that the MfgSys803
AppServer does not becoem active, the .pf contains the following...

-Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5

-T D:\epicor\mfgwrk803

-db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh

-db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0

... I'm not certain how to obtain the other info that you'd like ?.

Our MfgTrain803 is a copy of our live data, as indeed are the other
two, and they all have the same problem.

For some more history this problem occured about a week after
upgrading from v8.03.305 to .404. However, things went a bit wobbly
with the upgrade so in the end a complete re-install of Open Edge and
Vantage occured so all that remains from .305 is our production data
(in SQL 2005).

I've also got a VMware Server VM running v8.03.404 with our
production data and this problem does not occur on it.

Thanks.

--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...>
wrote:
>
> If you provide
>
> .pf file for your appservers
>
> Other settings - from PET broker and agent sections
>
> People may be able to help
>
>
>
> Do you get the same occur in the training environment?
>
> What parameters have been changed outside of a default vantage
install,
> has the issue always occurred?
>
> Why not install a default vantage installation on another machine
> (virtual) then see if the issue remains?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of clive.1972
> Sent: 21 April 2008 13:15
> To: vantage@yahoogroups.com
> Subject: [Vantage] AppServer's crashing when starting up
>
>
>
> I'm running the following...
>
> Vantage v8.03.404
> OpenEdge 10.1B + sp3 + hotfix 9
> SQL 2005 + SP2
>
> ... and I've somehow ended up with a problem where my AppServer's
in
> Progress Explorer allways crash when starting up.
>
> For example I startup the MfgSys803 appserver and it just hangs
there
> saying 'starting', and if I go to the details tab of the appserver
> out of the five threads/workers (?) at least one of them never
> becomes active. I then have to stop the Open Edge admin service and
> then kill off all of the hung processes using Task Manager. Then I
> can finaly restart the service and load the appserver's for
> MfgSys803, I can usual only successfully launch one instance of
> Vantage after this so I can't run a live and a training db at the
> same time :(
>
> I've logged a support call with Epicor UK, and after applying
various
> patches and waiting too long for a response from them they state
that
> this problem apparently resides with Open Edge and Progress are
> working on a fix for it ? (and that this is happening to many
Vantage
> users).
>
> Has anyone else had a similar problem at all ?.
>
> Thanks.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Ok if you have a VM box with your data and you don't get the issue.

It is not a data issue. i.e. it is not system agent settings that are
incorrect.



I presume your vmware box is the same software level as your production
box (service packs and hot fixes)



Your PF file looks ok - although there are some tuning parameters that
you have not applied which you should.

Look on epic Web for SQL performance and you will find a guide on this.



Regarding the issue it is to do with the Open Edge configuration.



Download a windiff program such as WinMerge then compare (Open edge DIR)
\ Properties\ubroker.properties files

Between you vmware box and your production environment.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of clive.1972
Sent: 21 April 2008 14:56
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AppServer's crashing when starting up



Will do.

When I reboot the physical server I can guarantee that the MfgSys803
AppServer does not becoem active, the .pf contains the following...

-Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5

-T D:\epicor\mfgwrk803

-db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh

-db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0

... I'm not certain how to obtain the other info that you'd like ?.

Our MfgTrain803 is a copy of our live data, as indeed are the other
two, and they all have the same problem.

For some more history this problem occured about a week after
upgrading from v8.03.305 to .404. However, things went a bit wobbly
with the upgrade so in the end a complete re-install of Open Edge and
Vantage occured so all that remains from .305 is our production data
(in SQL 2005).

I've also got a VMware Server VM running v8.03.404 with our
production data and this problem does not occur on it.

Thanks.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Stephen Edginton" <stephene@...>
wrote:
>
> If you provide
>
> .pf file for your appservers
>
> Other settings - from PET broker and agent sections
>
> People may be able to help
>
>
>
> Do you get the same occur in the training environment?
>
> What parameters have been changed outside of a default vantage
install,
> has the issue always occurred?
>
> Why not install a default vantage installation on another machine
> (virtual) then see if the issue remains?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of clive.1972
> Sent: 21 April 2008 13:15
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] AppServer's crashing when starting up
>
>
>
> I'm running the following...
>
> Vantage v8.03.404
> OpenEdge 10.1B + sp3 + hotfix 9
> SQL 2005 + SP2
>
> ... and I've somehow ended up with a problem where my AppServer's
in
> Progress Explorer allways crash when starting up.
>
> For example I startup the MfgSys803 appserver and it just hangs
there
> saying 'starting', and if I go to the details tab of the appserver
> out of the five threads/workers (?) at least one of them never
> becomes active. I then have to stop the Open Edge admin service and
> then kill off all of the hung processes using Task Manager. Then I
> can finaly restart the service and load the appserver's for
> MfgSys803, I can usual only successfully launch one instance of
> Vantage after this so I can't run a live and a training db at the
> same time :(
>
> I've logged a support call with Epicor UK, and after applying
various
> patches and waiting too long for a response from them they state
that
> this problem apparently resides with Open Edge and Progress are
> working on a fix for it ? (and that this is happening to many
Vantage
> users).
>
> Has anyone else had a similar problem at all ?.
>
> Thanks.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
Try -Bt 1024 -s 8000 and for 10.1, replace the zpr...0 with PRGRS_NATIVE_LOCKWAIT,60000.

I've also seen too big a number in # DB Buffers preventing the AppServers starting properly. Use 10,000 on an SQL database.

----- Original Message -----
From: "clive.1972" <clive.1972@...>
To: <vantage@yahoogroups.com>
Sent: Monday, April 21, 2008 6:55 AM
Subject: [Vantage] Re: AppServer's crashing when starting up


Will do.

When I reboot the physical server I can guarantee that the MfgSys803
AppServer does not becoem active, the .pf contains the following...

-Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5

-T D:\epicor\mfgwrk803

-db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh

-db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0

... I'm not certain how to obtain the other info that you'd like ?.

Our MfgTrain803 is a copy of our live data, as indeed are the other
two, and they all have the same problem.

For some more history this problem occured about a week after
upgrading from v8.03.305 to .404. However, things went a bit wobbly
with the upgrade so in the end a complete re-install of Open Edge and
Vantage occured so all that remains from .305 is our production data
(in SQL 2005).

I've also got a VMware Server VM running v8.03.404 with our
production data and this problem does not occur on it.

Thanks.

--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...>
wrote:
>
> If you provide
>
> .pf file for your appservers
>
> Other settings - from PET broker and agent sections
>
> People may be able to help
>
>
>
> Do you get the same occur in the training environment?
>
> What parameters have been changed outside of a default vantage
install,
> has the issue always occurred?
>
> Why not install a default vantage installation on another machine
> (virtual) then see if the issue remains?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of clive.1972
> Sent: 21 April 2008 13:15
> To: vantage@yahoogroups.com
> Subject: [Vantage] AppServer's crashing when starting up
>
>
>
> I'm running the following...
>
> Vantage v8.03.404
> OpenEdge 10.1B + sp3 + hotfix 9
> SQL 2005 + SP2
>
> ... and I've somehow ended up with a problem where my AppServer's
in
> Progress Explorer allways crash when starting up.
>
> For example I startup the MfgSys803 appserver and it just hangs
there
> saying 'starting', and if I go to the details tab of the appserver
> out of the five threads/workers (?) at least one of them never
> becomes active. I then have to stop the Open Edge admin service and
> then kill off all of the hung processes using Task Manager. Then I
> can finaly restart the service and load the appserver's for
> MfgSys803, I can usual only successfully launch one instance of
> Vantage after this so I can't run a live and a training db at the
> same time :(
>
> I've logged a support call with Epicor UK, and after applying
various
> patches and waiting too long for a response from them they state
that
> this problem apparently resides with Open Edge and Progress are
> working on a fix for it ? (and that this is happening to many
Vantage
> users).
>
> Has anyone else had a similar problem at all ?.
>
> Thanks.
>
>
>
>
>
> [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



[Non-text portions of this message have been removed]
Thanks for the heads up on WinMerge, very usefull ! :)

The only difference between the two 'ubroker.properties' files are
file paths as the 'epicor' share is on a different drive on my test
VM.

Both servers are on the same service packs etc.

I'll go on EPICweb now and get the SQL performance tweaks and reboot
the server tonight, and then report back...

--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...>
wrote:
>
> Ok if you have a VM box with your data and you don't get the issue.
>
> It is not a data issue. i.e. it is not system agent settings that
are
> incorrect.
>
>
>
> I presume your vmware box is the same software level as your
production
> box (service packs and hot fixes)
>
>
>
> Your PF file looks ok - although there are some tuning parameters
that
> you have not applied which you should.
>
> Look on epic Web for SQL performance and you will find a guide on
this.
>
>
>
> Regarding the issue it is to do with the Open Edge configuration.
>
>
>
> Download a windiff program such as WinMerge then compare (Open edge
DIR)
> \ Properties\ubroker.properties files
>
> Between you vmware box and your production environment.
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of clive.1972
> Sent: 21 April 2008 14:56
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: AppServer's crashing when starting up
>
>
>
> Will do.
>
> When I reboot the physical server I can guarantee that the
MfgSys803
> AppServer does not becoem active, the .pf contains the following...
>
> -Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
> tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5
>
> -T D:\epicor\mfgwrk803
>
> -db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh
>
> -db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
> PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0
>
> ... I'm not certain how to obtain the other info that you'd like ?.
>
> Our MfgTrain803 is a copy of our live data, as indeed are the other
> two, and they all have the same problem.
>
> For some more history this problem occured about a week after
> upgrading from v8.03.305 to .404. However, things went a bit wobbly
> with the upgrade so in the end a complete re-install of Open Edge
and
> Vantage occured so all that remains from .305 is our production
data
> (in SQL 2005).
>
> I've also got a VMware Server VM running v8.03.404 with our
> production data and this problem does not occur on it.
>
> Thanks.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Stephen Edginton" <stephene@>
> wrote:
> >
> > If you provide
> >
> > .pf file for your appservers
> >
> > Other settings - from PET broker and agent sections
> >
> > People may be able to help
> >
> >
> >
> > Do you get the same occur in the training environment?
> >
> > What parameters have been changed outside of a default vantage
> install,
> > has the issue always occurred?
> >
> > Why not install a default vantage installation on another machine
> > (virtual) then see if the issue remains?
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of clive.1972
> > Sent: 21 April 2008 13:15
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] AppServer's crashing when starting up
> >
> >
> >
> > I'm running the following...
> >
> > Vantage v8.03.404
> > OpenEdge 10.1B + sp3 + hotfix 9
> > SQL 2005 + SP2
> >
> > ... and I've somehow ended up with a problem where my AppServer's
> in
> > Progress Explorer allways crash when starting up.
> >
> > For example I startup the MfgSys803 appserver and it just hangs
> there
> > saying 'starting', and if I go to the details tab of the
appserver
> > out of the five threads/workers (?) at least one of them never
> > becomes active. I then have to stop the Open Edge admin service
and
> > then kill off all of the hung processes using Task Manager. Then
I
> > can finaly restart the service and load the appserver's for
> > MfgSys803, I can usual only successfully launch one instance of
> > Vantage after this so I can't run a live and a training db at the
> > same time :(
> >
> > I've logged a support call with Epicor UK, and after applying
> various
> > patches and waiting too long for a response from them they state
> that
> > this problem apparently resides with Open Edge and Progress are
> > working on a fix for it ? (and that this is happening to many
> Vantage
> > users).
> >
> > Has anyone else had a similar problem at all ?.
> >
> > Thanks.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
Use win merge to also look at the open edge binaries between the two
systems, you may find the patch didn't patch correctly.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of clive.1972
Sent: 21 April 2008 15:58
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AppServer's crashing when starting up



Thanks for the heads up on WinMerge, very usefull ! :)

The only difference between the two 'ubroker.properties' files are
file paths as the 'epicor' share is on a different drive on my test
VM.

Both servers are on the same service packs etc.

I'll go on EPICweb now and get the SQL performance tweaks and reboot
the server tonight, and then report back...

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Stephen Edginton" <stephene@...>
wrote:
>
> Ok if you have a VM box with your data and you don't get the issue.
>
> It is not a data issue. i.e. it is not system agent settings that
are
> incorrect.
>
>
>
> I presume your vmware box is the same software level as your
production
> box (service packs and hot fixes)
>
>
>
> Your PF file looks ok - although there are some tuning parameters
that
> you have not applied which you should.
>
> Look on epic Web for SQL performance and you will find a guide on
this.
>
>
>
> Regarding the issue it is to do with the Open Edge configuration.
>
>
>
> Download a windiff program such as WinMerge then compare (Open edge
DIR)
> \ Properties\ubroker.properties files
>
> Between you vmware box and your production environment.
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of clive.1972
> Sent: 21 April 2008 14:56
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: AppServer's crashing when starting up
>
>
>
> Will do.
>
> When I reboot the physical server I can guarantee that the
MfgSys803
> AppServer does not becoem active, the .pf contains the following...
>
> -Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
> tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5
>
> -T D:\epicor\mfgwrk803
>
> -db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh
>
> -db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
> PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0
>
> ... I'm not certain how to obtain the other info that you'd like ?.
>
> Our MfgTrain803 is a copy of our live data, as indeed are the other
> two, and they all have the same problem.
>
> For some more history this problem occured about a week after
> upgrading from v8.03.305 to .404. However, things went a bit wobbly
> with the upgrade so in the end a complete re-install of Open Edge
and
> Vantage occured so all that remains from .305 is our production
data
> (in SQL 2005).
>
> I've also got a VMware Server VM running v8.03.404 with our
> production data and this problem does not occur on it.
>
> Thanks.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Stephen Edginton" <stephene@>
> wrote:
> >
> > If you provide
> >
> > .pf file for your appservers
> >
> > Other settings - from PET broker and agent sections
> >
> > People may be able to help
> >
> >
> >
> > Do you get the same occur in the training environment?
> >
> > What parameters have been changed outside of a default vantage
> install,
> > has the issue always occurred?
> >
> > Why not install a default vantage installation on another machine
> > (virtual) then see if the issue remains?
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of clive.1972
> > Sent: 21 April 2008 13:15
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] AppServer's crashing when starting up
> >
> >
> >
> > I'm running the following...
> >
> > Vantage v8.03.404
> > OpenEdge 10.1B + sp3 + hotfix 9
> > SQL 2005 + SP2
> >
> > ... and I've somehow ended up with a problem where my AppServer's
> in
> > Progress Explorer allways crash when starting up.
> >
> > For example I startup the MfgSys803 appserver and it just hangs
> there
> > saying 'starting', and if I go to the details tab of the
appserver
> > out of the five threads/workers (?) at least one of them never
> > becomes active. I then have to stop the Open Edge admin service
and
> > then kill off all of the hung processes using Task Manager. Then
I
> > can finaly restart the service and load the appserver's for
> > MfgSys803, I can usual only successfully launch one instance of
> > Vantage after this so I can't run a live and a training db at the
> > same time :(
> >
> > I've logged a support call with Epicor UK, and after applying
> various
> > patches and waiting too long for a response from them they state
> that
> > this problem apparently resides with Open Edge and Progress are
> > working on a fix for it ? (and that this is happening to many
> Vantage
> > users).
> >
> > Has anyone else had a similar problem at all ?.
> >
> > Thanks.
> >
> >
> >
> >
> >
> > [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]
Your Open Edge black magic seems to have done the trick !.

I've changed all the .pf files so that they have the text below and
they all start up first time. I doubt it does but I'll check out the
Progress website to see if it describes exactly what each switch
achieves so I have some sort of idea as to what I've actualy just
done ;)

Thank you so much for your help. Are you happy for me to pass this
onto Epicor when I close the support call I had on this problem ?.


--- In vantage@yahoogroups.com, "Chris Robisch" <bluewine@...> wrote:
>
> Try -Bt 1024 -s 8000 and for 10.1, replace the zpr...0 with
PRGRS_NATIVE_LOCKWAIT,60000.
>
> I've also seen too big a number in # DB Buffers preventing the
AppServers starting properly. Use 10,000 on an SQL database.
>
> ----- Original Message -----
> From: "clive.1972" <clive.1972@...>
> To: <vantage@yahoogroups.com>
> Sent: Monday, April 21, 2008 6:55 AM
> Subject: [Vantage] Re: AppServer's crashing when starting up
>
>
> Will do.
>
> When I reboot the physical server I can guarantee that the
MfgSys803
> AppServer does not becoem active, the .pf contains the following...
>
> -Mm 1024 -mmax 65534 -Bt 1024 -s 215 -yy 1970 -stsh 31 -inp 32000 -
> tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5
>
> -T D:\epicor\mfgwrk803
>
> -db D:\epicor\Pilot803\DB\mfgpilotsh -ld mfgsyssh
>
> -db MfgPilot803 -dt MSS -ld MfgSys -Dsrv
> PRGRS_CONNECT,DSN=MFGPILOT803,TXN_ISOLATION,1,ZPRGRS_UPDLOCK_HINT,0
>
> ... I'm not certain how to obtain the other info that you'd like ?.
>
> Our MfgTrain803 is a copy of our live data, as indeed are the other
> two, and they all have the same problem.
>
> For some more history this problem occured about a week after
> upgrading from v8.03.305 to .404. However, things went a bit wobbly
> with the upgrade so in the end a complete re-install of Open Edge
and
> Vantage occured so all that remains from .305 is our production
data
> (in SQL 2005).
>
> I've also got a VMware Server VM running v8.03.404 with our
> production data and this problem does not occur on it.
>
> Thanks.
>
> --- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@>
> wrote:
> >
> > If you provide
> >
> > .pf file for your appservers
> >
> > Other settings - from PET broker and agent
sections
> >
> > People may be able to help
> >
> >
> >
> > Do you get the same occur in the training environment?
> >
> > What parameters have been changed outside of a default vantage
> install,
> > has the issue always occurred?
> >
> > Why not install a default vantage installation on another machine
> > (virtual) then see if the issue remains?
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of clive.1972
> > Sent: 21 April 2008 13:15
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] AppServer's crashing when starting up
> >
> >
> >
> > I'm running the following...
> >
> > Vantage v8.03.404
> > OpenEdge 10.1B + sp3 + hotfix 9
> > SQL 2005 + SP2
> >
> > ... and I've somehow ended up with a problem where my AppServer's
> in
> > Progress Explorer allways crash when starting up.
> >
> > For example I startup the MfgSys803 appserver and it just hangs
> there
> > saying 'starting', and if I go to the details tab of the
appserver
> > out of the five threads/workers (?) at least one of them never
> > becomes active. I then have to stop the Open Edge admin service
and
> > then kill off all of the hung processes using Task Manager. Then
I
> > can finaly restart the service and load the appserver's for
> > MfgSys803, I can usual only successfully launch one instance of
> > Vantage after this so I can't run a live and a training db at the
> > same time :(
> >
> > I've logged a support call with Epicor UK, and after applying
> various
> > patches and waiting too long for a response from them they state
> that
> > this problem apparently resides with Open Edge and Progress are
> > working on a fix for it ? (and that this is happening to many
> Vantage
> > users).
> >
> > Has anyone else had a similar problem at all ?.
> >
> > Thanks.
> >
> >
> >
> >
> >
> > [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
>
>
>
> [Non-text portions of this message have been removed]
>