This may not be related but we had trouble like this that caused a shut down every day. 40 of 40 servers in use. After weeks of digging we found the epicor data folder had files that were spawning with #of seconds from midnight in the file name. I believe they were work files that should have been deleted after use but they were not. We had 86400 of these files. We setup a process to delete these and our sever count dropped from 40 to an average of 5. We still have had no respone from epicor on this problem.
We are on E9.04.506b
Mark D
We are on E9.04.506b
Mark D
--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> It's starting to look like our accountant might be causing it when he runs the "COS" report, but he says it's only for 2-days and should not cause the App Servers to max out, but it is.
>
> --sf
>
> --- In vantage@yahoogroups.com, "mattcald_73" <matt@> wrote:
> >
> > Is this happening at various times of the day, or is it at a certain time? We had this happen a while back, and found that our "online" backup that was scheduled at noon each day caused this to happen. We eventually had to turn it off.
> >
> > --Matt
> >
> >
> > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > >
> > > Your code looks good other than that it doesn't look like you're disposing
> > > the adaptors when you're done. Epicor can't really be relied on to do this
> > > automatically. I don't know if it's the root of all your issues, but it's a
> > > quick addition to the code and should be there either way.
> > >
> > > On Sat, Feb 12, 2011 at 12:03 PM, Ned <TechnoBabbly@> wrote:
> > >
> > > >
> > > >
> > > > It's not just opening the dashboard that's causing the problem most likely,
> > > > it's something that is done on that screen actively, not necessarily the
> > > > dashboard itself.
> > > >
> > > > Based on the error that was posted before, you have some dashboard for a
> > > > salesman I am guessing that is the problem based on the accessing of the
> > > > Authorized Territories.
> > > >
> > > > I am also not sure how many of your users might have dashboard developer
> > > > privileges, in which case possibly even one of them may have done something
> > > > drastic in a personalization.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > > Of
> > > > sanfranc415
> > > > Sent: Friday, February 11, 2011 4:44 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: App servers running out.
> > > >
> > > > I did that, and nothing happened. I posted earlier that the maximum numbers
> > > > of "App Servers" generated at one time was no more than 3.
> > > >
> > > > --sf
> > > > --- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > Open up each dashboard one at a time and see which one triggers the
> > > > > crash.
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > > Behalf Of sanfranc415
> > > > > Sent: Friday, February 11, 2011 4:05 PM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: [Vantage] Re: App servers running out.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Looks like a "Dashboard," but which one? Just crashed and here is the
> > > > > log entry:
> > > > >
> > > > > [11/02/11@12:51:17.613-0800] P-006916 T-005196 1 AS -- ** Starting
> > > > > position for SUBSTRING, OVERLAY, etc. must be 1 or greater. (82)
> > > > > [11/02/11@12:51:17.613-0800] P-006916 T-005196 1 AS -- ** 4GL
> > > > > Debug-Alert Stack Trace ** [11/02/11@12:51:17.613-0800] P-006916
> > > > > T-005196 1 AS -- --> lib/authorizedterritories.p
> > > > > (c:\epicor\mfgsys803\Server\lib\authorizedterritories.r) at line 590
> > > > > [11/02/11@12:51:17.613-0800] P-006916 T-005196 1 AS -- getQueryData1
> > > > > bo/DynamicQuery.p (c:\epicor\mfgsys803\Server\bo\DynamicQuery.r) at
> > > > > line
> > > > > 32995
> > > > > [11/02/11@12:51:17.613-0800] P-006916 T-005196 1 AS -- runQuery
> > > > > bo/DynamicQuery.p (c:\epicor\mfgsys803\Server\bo\DynamicQuery.r) at
> > > > > line
> > > > > 44511
> > > > > [11/02/11@12:51:17.613-0800] P-006916 T-005196 1 AS --
> > > > > ExecuteDashBoardQueryPaged bo/DynamicQuery.p
> > > > > (c:\epicor\mfgsys803\Server\bo\DynamicQuery.r) at line 28222
> > > > > [11/02/11@12:51:17.613-0800] P-006916 T-005196 1 AS --
> > > > > ExecuteDashBoardQuery bo/DynamicQuery.p
> > > > > (c:\epicor\mfgsys803\Server\bo\DynamicQuery.r) at line 27877
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > > > "sanfranc415" <sanfranc415@> wrote:
> > > > > >
> > > > > > PO Entry customization code:
> > > > > >
> > > > > > '//**************************************************
> > > > > > '// Custom VB.NET code for POEntryForm '// Created: 5/10/2007
> > > > > > 12:59:36 PM
> > > > > > '//**************************************************
> > > > > > Imports System
> > > > > > Imports System.Data
> > > > > > Imports System.Diagnostics
> > > > > > Imports System.Windows.Forms
> > > > > > Imports System.ComponentModel
> > > > > > Imports Microsoft.VisualBasic
> > > > > > Imports Epicor.Mfg.UI
> > > > > > Imports Epicor.Mfg.UI.FrameWork
> > > > > > Imports Epicor.Mfg.UI.ExtendedProps
> > > > > > Imports Epicor.Mfg.UI.FormFunctions
> > > > > > Imports Epicor.Mfg.UI.Customization
> > > > > > Imports Epicor.Mfg.UI.Adapters
> > > > > > Imports Epicor.Mfg.UI.Searches
> > > > > > Imports Epicor.Mfg.BO
> > > > > >
> > > > > >
> > > > > > Module Script
> > > > > >
> > > > > >
> > > > > > '// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > > > Added
> > > > > Module Level Variables' Comments! **
> > > > > > '// Begin Wizard Added Module Level Variables **
> > > > > >
> > > > > > '// End Wizard Added Module Level Variables **
> > > > > >
> > > > > >
> > > > > > '// Add Custom Module Level Variables Here **
> > > > > >
> > > > > >
> > > > > >
> > > > > > Sub InitializeCustomCode()
> > > > > >
> > > > > >
> > > > > > '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > > Added
> > > > > Variable Intialization' lines **
> > > > > > '// Begin Wizard Added Variable Intialization
> > > > > >
> > > > > > '// End Wizard Added Variable Intialization '// Begin Custom Method
> > > > > > Calls
> > > > > >
> > > > > > '// End Custom Method Calls
> > > > > > End Sub
> > > > > >
> > > > > >
> > > > > >
> > > > > > Sub DestroyCustomCode()
> > > > > >
> > > > > >
> > > > > > '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > > Added
> > > > > Object Disposal' lines **
> > > > > > '// Begin Wizard Added Object Disposal
> > > > > >
> > > > > > '// End Wizard Added Object Disposal '// Begin Custom Code Disposal
> > > > > >
> > > > > > '// End Custom Code Disposal
> > > > > > End Sub
> > > > > > Private WithEvents btnLaunchTracker As EpiButton
> > > > > >
> > > > > > Private Sub POEntryForm_Load(ByVal sender As object, ByVal args As
> > > > > EventArgs) Handles POEntryForm.Load
> > > > > > '//
> > > > > > '// Add Event Handler Code
> > > > > > '//
> > > > > >
> > > > > > btnLaunchTracker =
> > > > > CType(csm.GetNativeControlReference("24c340c5-851a-4929-8890-e4f8d2ae1
> > > > > 48
> > > > > c"), EpiButton)
> > > > > >
> > > > > > btnLaunchTracker.Enabled = True
> > > > > > End Sub
> > > > > >
> > > > > > Private Sub btnLaunchTracker_Click(ByVal Sender As Object, ByVal
> > > > > > args
> > > > > As EventArgs ) Handles btnLaunchTracker.Click
> > > > > > ProcessCaller.LaunchForm(POEntryForm, "UD001") End Sub
> > > > > >
> > > > > > Private Sub txtEpiCustom1_Leave(ByVal Sender As Object, ByVal Args
> > > > > > As
> > > > > System.EventArgs) Handles txtEpiCustom1.Leave
> > > > > > '// ** Place Event Handling Code Here **
> > > > > >
> > > > > > Dim ordhedAdapter as OpMasterADapter = New
> > > > > OpMasterAdapter(POEntryForm)
> > > > > > Dim ohaConnected As Boolean = ordhedAdapter.BOConnect()
> > > > > >
> > > > > > Dim Success As Boolean = ordhedAdapter.GetByID(txtEpiCustom1.Text)
> > > > > >
> > > > > > If(Success) Then
> > > > > > Dim edvOrderHed As EpiDataView = CType
> > > > > (oTrans.EpiDataViews("OpMaster"), EpiDataView)
> > > > > >
> > > > > > txtepicustom2.text =
> > > > > (ordhedAdapter.OpMasterData.Tables("OpMaster").Rows(0)("opdesc") _
> > > > > > + " " +
> > > > > ordhedAdapter.OpMasterData.Tables("OpMaster").Rows(0)("commenttext"))
> > > > > >
> > > > > >
> > > > > >
> > > > > > End If
> > > > > > End Sub
> > > > > > Private Sub txtEpiCustom3_Leave(ByVal Sender As Object, ByVal Args
> > > > > > As
> > > > > System.EventArgs) Handles txtEpiCustom3.Leave
> > > > > > '// ** Place Event Handling Code Here **
> > > > > >
> > > > > > Dim ordhedAdapter as OpMasterADapter = New
> > > > > OpMasterAdapter(POEntryForm)
> > > > > > Dim ohaConnected As Boolean = ordhedAdapter.BOConnect()
> > > > > >
> > > > > > Dim Success As Boolean = ordhedAdapter.GetByID(txtEpiCustom3.Text)
> > > > > >
> > > > > > If(Success) Then
> > > > > > Dim edvOrderHed As EpiDataView = CType
> > > > > (oTrans.EpiDataViews("OpMaster"), EpiDataView)
> > > > > >
> > > > > > txtepicustom4.text =
> > > > > (ordhedAdapter.OpMasterData.Tables("OpMaster").Rows(0)("opdesc") _
> > > > > > + " " +
> > > > > ordhedAdapter.OpMasterData.Tables("OpMaster").Rows(0)("commenttext"))
> > > > > >
> > > > > >
> > > > > >
> > > > > > End If
> > > > > > End Sub
> > > > > > Private Sub txtEpiCustom5_Leave(ByVal Sender As Object, ByVal Args
> > > > > > As
> > > > > System.EventArgs) Handles txtEpiCustom5.Leave
> > > > > > '// ** Place Event Handling Code Here **
> > > > > >
> > > > > > Dim ordhedAdapter as OpMasterADapter = New
> > > > > OpMasterAdapter(POEntryForm)
> > > > > > Dim ohaConnected As Boolean = ordhedAdapter.BOConnect()
> > > > > >
> > > > > > Dim Success As Boolean = ordhedAdapter.GetByID(txtEpiCustom5.Text)
> > > > > >
> > > > > > If(Success) Then
> > > > > > Dim edvOrderHed As EpiDataView = CType
> > > > > (oTrans.EpiDataViews("OpMaster"), EpiDataView)
> > > > > >
> > > > > > txtepicustom6.text =
> > > > > (ordhedAdapter.OpMasterData.Tables("OpMaster").Rows(0)("opdesc") _
> > > > > > + " " +
> > > > > ordhedAdapter.OpMasterData.Tables("OpMaster").Rows(0)("commenttext"))
> > > > > >
> > > > > >
> > > > > >
> > > > > > End If
> > > > > > End Sub
> > > > > >
> > > > > >
> > > > > >
> > > > > > End Module
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > > > Waffqle <waffqle@> wrote:
> > > > > > >
> > > > > > > Got any custom code that uses the BO adapters?
> > > > > > >
> > > > > > > On Fri, Feb 11, 2011 at 3:04 PM, sanfranc415 <sanfranc415@> wrote:
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > I manually went through and ran all custom dashboards, and not
> > > > > once did the
> > > > > > > > app servers reach more than 3.
> > > > > > > >
> > > > > > > > I don't think the db could have been hit harder!
> > > > > > > >
> > > > > > > >
> > > > > > > > --sf
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com
> > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > , Waffqle <waffqle@> wrote:
> > > > > > > > >
> > > > > > > > > Custom reports or dashboards?
> > > > > > > > > Maybe you have a REALLY bad query somewhere?
> > > > > > > > > "FOR EACH Customer, EACH Order" or something like that?
> > > > > > > > >
> > > > > > > > > Is the server under heavy load when it gets ugly? It would
> > > > > probably be
> > > > > > > > > useful to know whether the machine is actively doing something
> > > > > or if some
> > > > > > > > > process is just wantonly tying up the App Servers for no reason.
> > > > > > > > >
> > > > > > > > > What does your CPU usage / disk queue look like when people
> > > > > can't
> > > > > > > > connect?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > On Fri, Feb 11, 2011 at 2:28 PM, sanfranc415 <sanfranc415@>
> > > > > wrote:
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > The clients come to a stand still. There are no tasks
> > > > > > > > > > running
> > > > > in the
> > > > > > > > > > background when the App Servers max out.
> > > > > > > > > >
> > > > > > > > > > The only curious this is that it only happens during
> > > > > > > > > > business
> > > > > hours and
> > > > > > > > > > while "Office users" are running.
> > > > > > > > > >
> > > > > > > > > > --sf
> > > > > > > > > >
> > > > > > > > > > --- In vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> , Waffqle <waffqle@> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Have you looked at your System Agent? Do you have anything
> > > > > running on
> > > > > > > > a
> > > > > > > > > > > schedule? Incorrectly scheduled jobs can cause this
> > > > > situation.
> > > > > > > > > > >
> > > > > > > > > > > On Fri, Feb 11, 2011 at 2:11 PM, Blake Clemens
> > > > > <blake.clemens@
> > > > > > > > >wrote:
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > What happens if you disable the script? Will the Vantage
> > > > > DB
> > > > > > > > eventually
> > > > > > > > > > > > crash? Or will the client PCs come to a stand still when
> > > > > the DB
> > > > > > > > reaches
> > > > > > > > > > > > a "dangerous level"?
> > > > > > > > > > > >
> > > > > > > > > > > > Thanks,
> > > > > > > > > > > >
> > > > > > > > > > > > Blake Clemens
> > > > > > > > > > > >
> > > > > > > > > > > > IT Systems Engineer
> > > > > > > > > > > >
> > > > > > > > > > > > Delmarva Millwork Corporation
> > > > > > > > > > > >
> > > > > > > > > > > > (800) 360-2364 x132
> > > > > > > > > > > >
> > > > > > > > > > > > From: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> ] On
> > > > > > > > > > Behalf
> > > > > > > > > > > > Of sanfranc415
> > > > > > > > > > > > Sent: Friday, February 11, 2011 2:07 PM
> > > > > > > > > > > > To: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > Subject: [Vantage] Re: App servers running out.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Right now, I have a Powershell script that monitors the
> > > > > App
> > > > > > > > Servers,
> > > > > > > > > > > > when they reach a dangerous level, I have the script
> > > > > > > > > > > > stop
> > > > > the DB,
> > > > > > > > app
> > > > > > > > > > > > servers, etc., and restart the App Servers and database.
> > > > > Then I get
> > > > > > > > a
> > > > > > > > > > > > txt message that it has failed, but restarted.
> > > > > > > > > > > >
> > > > > > > > > > > > Once it runs out, it always fails to release and just
> > > > > hangs.
> > > > > > > > > > > >
> > > > > > > > > > > > --tj
> > > > > > > > > > > >
> > > > > > > > > > > > --- In vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > > > ,
> > > > > > > > > > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > > > > > > > > > >
> > > > > > > > > > > > > I've been through he!! and back with our Vantage
> > > > > > > > > > > > > Server
> > > > > and would
> > > > > > > > > > love
> > > > > > > > > > > > > to be able to get my hands on this server.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Thanks,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Blake Clemens
> > > > > > > > > > > > >
> > > > > > > > > > > > > IT Systems Engineer
> > > > > > > > > > > > >
> > > > > > > > > > > > > Delmarva Millwork Corporation
> > > > > > > > > > > > >
> > > > > > > > > > > > > (800) 360-2364 x132
> > > > > > > > > > > > >
> > > > > > > > > > > > > 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 Brian W. Spolarich
> > > > > > > > > > > > > Sent: Friday, February 11, 2011 1:11 PM
> > > > > > > > > > > > > To: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > Subject: RE: [Vantage] Re: App servers running out.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > I'd be curious to see via the admin tool how many
> > > > > sessions are
> > > > > > > > open
> > > > > > > > > > > > > and for what users when you run out.
> > > > > > > > > > > > >
> > > > > > > > > > > > > -bws
> > > > > > > > > > > > >
> > > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > > From: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > [mailto:vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:
> > > > > > > > vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com> ] On
> > > > > > > > > > > > > Behalf
> > > > > > > > > > > > > Of sanfranc415
> > > > > > > > > > > > > Sent: Friday, February 11, 2011 12:09 PM
> > > > > > > > > > > > > To: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > Subject: [Vantage] Re: App servers running out.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Yes, and the App Servers Max range has been well above
> > > > > the
> > > > > > > > > > recommended
> > > > > > > > > > > > > with no success. At the moment we have a max range of
> > > > > > > > > > > > > 30
> > > > > App
> > > > > > > > Servers,
> > > > > > > > > > > > > and this is with only 30 office clients and 20 MES
> > > > > users.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Epicor is continue to work with us on this problem,
> > > > > > > > > > > > > but
> > > > > have had
> > > > > > > > > > > > little
> > > > > > > > > > > > > to no success.
> > > > > > > > > > > > >
> > > > > > > > > > > > > --tj
> > > > > > > > > > > > >
> > > > > > > > > > > > > --- In vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com
> > > > > > > > >
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > > > > > > > > > "Blake Clemens" <blake.clemens@>
> > > > > > > > > > > > > wrote:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > What Brian says below should fix the problem.
> > > > > > > > > > > > > > However,
> > > > > one
> > > > > > > > would
> > > > > > > > > > > > think
> > > > > > > > > > > > > > that support would have had you try this already.
> > > > > > > > > > > > > > But
> > > > > we all
> > > > > > > > know
> > > > > > > > > > > > how
> > > > > > > > > > > > > > support can be. I'm curious to see if this fixes the
> > > > > problem.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Thanks,
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Blake Clemens
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > IT Systems Engineer
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Delmarva Millwork Corporation
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > (800) 360-2364 x132
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > From: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:
> > > > > > > > vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > [mailto:vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:
> > > > > > > > vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com> ] On
> > > > > > > > > > > > > Behalf
> > > > > > > > > > > > > > Of Brian Roberts
> > > > > > > > > > > > > > Sent: Friday, February 11, 2011 10:39 AM
> > > > > > > > > > > > > > To: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > > Subject: RE: [Vantage] Re: App servers running out.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Try this: in Progress Explorer Tool, find the app
> > > > > server and
> > > > > > > > check
> > > > > > > > > > > > the
> > > > > > > > > > > > > > Status to see how many app servers are running now
> > > > > (there also
> > > > > > > > some
> > > > > > > > > > > > > > stats on the max servers, clients, etc). Then, under
> > > > > Properties
> > > > > > > > for
> > > > > > > > > > > > > > that server, Pool Range, see what the maximum number
> > > > > of app
> > > > > > > > servers
> > > > > > > > > > > > is
> > > > > > > > > > > > > > set to, and increase it if you're hitting the maximum.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > (Based on 9.05, but I think it's the same in 8)
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Brian.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > ________________________________
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > From: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:
> > > > > > > > vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > > [mailto:vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:
> > > > > > > > vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > <mailto:vantage%40yahoogroups.com> ] On
> > > > > > > > > > > > > > Behalf
> > > > > > > > > > > > > > Of sanfranc415
> > > > > > > > > > > > > > Sent: Thursday, February 10, 2011 3:47 PM
> > > > > > > > > > > > > > To: vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > > Subject: [Vantage] Re: App servers running out.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > "No More Available App Servers" on all client
> > > > > machines.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > --- In vantage@yahoogroups.com
> > > > > <mailto:vantage%40yahoogroups.com> <mailto:
> > > > > > > > vantage%40yahoogroups.com>
> > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > > > > > <mailto:vantage%40yahoogroups.com> , Waffqle
> > > > > > > > > > > > > > <waffqle@> wrote:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > What do you mean by 'maxing out'?
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > On Thu, Feb 10, 2011 at 2:03 PM, sanfranc415
> > > > > <sanfranc415@>
> > > > > > > > > > wrote:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > A problem that continues with our app servers
> > > > > maxing out.
> > > > > > > > Here
> > > > > > > > > > > > is
> > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > > latest error message that is generated after
> > > > > maxing out:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Cannot find or open file
> > > > > > > > > > > > > > > > C:\epicor\mfgwrk803\?.db
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Our database is located in
> > > > > c:\epicor\mfgsys803\db\mfgsys.db
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > I cannot find any reference the the about ?.db,
> > > > > and I'm
> > > > > > > > pretty
> > > > > > > > > > > > > sure
> > > > > > > > > > > > > > that's
> > > > > > > > > > > > > > > > not even a valid file-name.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Epicor suggested it was a DNS issue, so
> > > > > > > > > > > > > > > > rebooting
> > > > > would
> > > > > > > > solve,
> > > > > > > > > > > > and
> > > > > > > > > > > > > > it did
> > > > > > > > > > > > > > > > not solve. I've even change the DNS server on
> > > > > > > > > > > > > > > > this
> > > > > > > > particular
> > > > > > > > > > > > > > machine, and
> > > > > > > > > > > > > > > > still it crashes.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Hopefully somebody can help?
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Regards,
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > --tj
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > [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]
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > ------------------------------------
> > > > > > > > > > > > >
> > > > > > > > > > > > > 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/.
> > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > > > > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > > > > > > > > <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]
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > [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]
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [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]
> > >
> >
>