Try the Knowledge Base on the Open Edge site.
progress.com > support > openedge
On Mon, Jun 13, 2011 at 4:33 PM, Brian W. Spolarich <
bspolarich@...> wrote:
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*
*
*
[Non-text portions of this message have been removed]
progress.com > support > openedge
On Mon, Jun 13, 2011 at 4:33 PM, Brian W. Spolarich <
bspolarich@...> wrote:
>--
>
> Where can I read up on that?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Waffqle
> Sent: Monday, June 13, 2011 1:28 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Progress Seek Errors and MSSQL Locks
>
>
> There's a 2gb limit on the Sort File for progress. If you're going over
> that
> limit you'll get errors like that. Read up on the -SS option. (I believe
> it
> goes in your mfgsys file) That'll break up the file and should take care
> of
> your issue.
>
> Forgive me for not having more details. It's been a while since we were
> running 8 and I haven't seen that issue come up in newer versions.
>
> On Mon, Jun 13, 2011 at 4:12 PM, Brian W. Spolarich <
> bspolarich@...> wrote:
>
> >
> >
> > We're having an increasingly frequent problem where folks come in in
> > the morning and Vantage is unresponsive. We're running 8.03.408B on
> > MSSQL.
> >
> > The symptoms are:
> >
> > - Nothing interesting is reported in the log, except Vantage
> > starts to launch new appservers when users come in in the morning,
> > because (presumably) the existing appservers are busy.
> >
> > - Existing appservers are busy waiting for MSSQL transactions
> > that never finish.
> >
> > - In MSSQL we will see blocked SPIDs in the Activity Monitor,
> > with a single root blocking task that is always a FETCH_APICURSOR
> call.
> >
> > - This seems related to MRP, as it started up again after we
> > started running MRP again at night (for various reasons we stopped
> > running MRP for a few days).
> >
> > - MRP periodically takes a very long time to run (3-4x its
> > normal speed). But the server isn't otherwise busy.
> >
> > I've recently discovered sp_whoisactive (a very useful MSSQL tool),
> > and I've set it up to run and log to a table every 15 minutes, so
> maybe
> > we'll get some better visibility into what's going on.
> >
> > Also we saw this this morning, although this was logged after things
> > went south:
> >
> > EVENT #
> >
> > 11660431
> >
> > EVENT LOG
> >
> > Application
> >
> > EVENT TYPE
> >
> > Error
> >
> > SOURCE
> >
> > PROGRESS
> >
> > CATEGORY
> >
> > USER
> >
> > EVENT ID
> >
> > 163
> >
> > COMPUTERNAME
> >
> > VULCAN
> >
> > DATE / TIME
> >
> > 6/13/2011 8:59:01 AM
> >
> > MESSAGE
> >
> > Usr SYSTEM ERROR: Seek error 22, file 9, addr -2147453952. (163)
> >
> > Any of this sound familiar to folks? Our environment has gone from
> > pretty stable to quite unstable rather quickly, and we've not made any
> > obvious changes that should cause problems.
> >
> > -bws
> >
> > --
> >
> > Brian W. Spolarich ~ IT Consultant ~ Advanced Photonix / Picometrix
> >
> > bspolarich@...
> <mailto:bspolarich@...>
> > ~ 734-358-0033 ~ www.advancedphotonix.com
> > <http://www.advancedphotonix.com>
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> --
> *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
>
>
>
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*
*
*
[Non-text portions of this message have been removed]