🚀 go-pugleaf

Thom,

thank you for this advise. I'm trying to find places where I leave
an open query. But isn't it the duty of IntraBuilder to close
all database components when a connection ends ?

I know last year I had a problem with IB 1.01 when I reloaded
a form that left an open database - IB crashed - until I found 
out that I had to close the database by myself immediately after
performing a query. 

If IB gets into a state when the browser shows an too many simultaneous
users error, there seems to be no automatically reset by IntraBuilder
itself, even after several hours, unless I do the restart manually.

Regards,
Joachim

Previously, Joachim Pimiskern <J.Pimiskern@realgarant.de> taught us all that:

>Thom,
>
>thank you for this advise. I'm trying to find places where I leave
>an open query. But isn't it the duty of IntraBuilder to close
>all database components when a connection ends ?
>
Well, yes, it is IntraBuilder's responsibility to do that. On
the other hand, it's my kid's responsibility to clean up after
themselves also; but, they rarely do.

>I know last year I had a problem with IB 1.01 when I reloaded
>a form that left an open database - IB crashed - until I found 
>out that I had to close the database by myself immediately after
>performing a query. 
>
>If IB gets into a state when the browser shows an too many simultaneous
>users error, there seems to be no automatically reset by IntraBuilder
>itself, even after several hours, unless I do the restart manually.
>
Yup. That's what I've seen too. And since it seems the database
connections are handled through the broker (not the agents), I've
had to restart the web server AND the intrabuilder server to clear
the problem. So I would advise being VERY sure to close all your
database connections yourself. Once I found the last of mine, my
system's been running non-stop for about two months now with no
restarts necessary, and moderate load.

>Regards,
>Joachim

And regards to you.

Thom

Thom,
what event or procedure do you use to close the database connection and also
how do you open them (I mean where's the best place to open them)? Forms
require that they remain open for the session so is there a way of closing
the db connection on session close?


>Previously, Joachim Pimiskern <J.Pimiskern@realgarant.de> taught us all
that:
>
>>Thom,
>>
>>thank you for this advise. I'm trying to find places where I leave
>>an open query. But isn't it the duty of IntraBuilder to close
>>all database components when a connection ends ?
>>
>Well, yes, it is IntraBuilder's responsibility to do that. On
>the other hand, it's my kid's responsibility to clean up after
>themselves also; but, they rarely do.
>
>>I know last year I had a problem with IB 1.01 when I reloaded
>>a form that left an open database - IB crashed - until I found
>>out that I had to close the database by myself immediately after
>>performing a query.
>>
>>If IB gets into a state when the browser shows an too many simultaneous
>>users error, there seems to be no automatically reset by IntraBuilder
>>itself, even after several hours, unless I do the restart manually.
>>
>Yup. That's what I've seen too. And since it seems the database
>connections are handled through the broker (not the agents), I've
>had to restart the web server AND the intrabuilder server to clear
>the problem. So I would advise being VERY sure to close all your
>database connections yourself. Once I found the last of mine, my
>system's been running non-stop for about two months now with no
>restarts necessary, and moderate load.
>
>>Regards,
>>Joachim
>
>And regards to you.
>
>Thom
>
>
>

I was reading some threads on this issue. I saw one also from A.A. Katz
on this back in November 1997 from a problem seen by
vaahtera@infotools.fi and he had seen where bunch of sessions have blank
forms and no session IDs, and it finally loads up the server and they
have to reboot. I have the same thing happen myself.

Did any of you ever find the reason for this? Does it simply have to do
with not closing sessions or database or queries down by setting the
active property to false? Or is there something else happening? I know
this only happens on occasion, and it seems like it has to do with
interrupting a form midstream while doing a query. And it seems to
happen more often too with reports. Once you get one in there that never
loses the BUSY status, they start to pile up, until u get too many
simult users. WHats the recommendation here to avoid this all?

On another note, any idea why my intrabuilder server monitor would
return "Document contains no data" ? 

Thanks
Dwight Furleigh
Cat Ag Products
Furleigh_Dwight_D@cat.com



Joachim Pimiskern wrote:
> 
> Hello,
> 
> about three times a week I get the message >>Alert. Too many simltaneous
> users<<
> when I'm entering my IntraBuilder 1.5 page, and I've to reboot my IIS
> server
> (or what is more precise, have to restart IntraBuilder).
> 
> What can I do to increase the number of possible simulateneous users ?
> 
> TIA
> Joachim



Alan McDonald wrote:
> 
> Thom,
> what event or procedure do you use to close the database connection and also
> how do you open them (I mean where's the best place to open them)? Forms
> require that they remain open for the session so is there a way of closing
> the db connection on session close?
> 
> >Previously, Joachim Pimiskern <J.Pimiskern@realgarant.de> taught us all
> that:
> >
> >>Thom,
> >>
> >>thank you for this advise. I'm trying to find places where I leave
> >>an open query. But isn't it the duty of IntraBuilder to close
> >>all database components when a connection ends ?
> >>
> >Well, yes, it is IntraBuilder's responsibility to do that. On
> >the other hand, it's my kid's responsibility to clean up after
> >themselves also; but, they rarely do.
> >
> >>I know last year I had a problem with IB 1.01 when I reloaded
> >>a form that left an open database - IB crashed - until I found
> >>out that I had to close the database by myself immediately after
> >>performing a query.
> >>
> >>If IB gets into a state when the browser shows an too many simultaneous
> >>users error, there seems to be no automatically reset by IntraBuilder
> >>itself, even after several hours, unless I do the restart manually.
> >>
> >Yup. That's what I've seen too. And since it seems the database
> >connections are handled through the broker (not the agents), I've
> >had to restart the web server AND the intrabuilder server to clear
> >the problem. So I would advise being VERY sure to close all your
> >database connections yourself. Once I found the last of mine, my
> >system's been running non-stop for about two months now with no
> >restarts necessary, and moderate load.
> >
> >>Regards,
> >>Joachim
> >
> >And regards to you.
> >
> >Thom
> >
> >
> >

I was reading some threads on this issue. I saw one also from A.A. Katz
on this back in November 1997 from a problem seen by
vaahtera@infotools.fi and he had seen where bunch of sessions have blank
forms and no session IDs, and it finally loads up the server and they
have to reboot. I have the same thing happen myself.

Did any of you ever find the reason for this? Does it simply have to do
with not closing sessions or database or queries down by setting the
active property to false? Or is there something else happening? I know
this only happens on occasion, and it seems like it has to do with
interrupting a form midstream while doing a query. And it seems to
happen more often too with reports. Once you get one in there that never
loses the BUSY status, they start to pile up, until u get too many
simult users. WHats the recommendation here to avoid this all?

On another note, any idea why my intrabuilder server monitor would
return "Document contains no data" ? 

Thanks
Dwight Furleigh
Cat Ag Products
Furleigh_Dwight_D@cat.com



Joachim Pimiskern wrote:
> 
> Hello,
> 
> about three times a week I get the message >>Alert. Too many simltaneous
> users<<
> when I'm entering my IntraBuilder 1.5 page, and I've to reboot my IIS
> server
> (or what is more precise, have to restart IntraBuilder).
> 
> What can I do to increase the number of possible simulateneous users ?
> 
> TIA
> Joachim

Alan McDonald wrote:
> 
> Thom,
> what event or procedure do you use to close the database connection and also
> how do you open them (I mean where's the best place to open them)? Forms
> require that they remain open for the session so is there a way of closing
> the db connection on session close?
> 
> >Previously, Joachim Pimiskern <J.Pimiskern@realgarant.de> taught us all
> that:
> >
> >>Thom,
> >>
> >>thank you for this advise. I'm trying to find places where I leave
> >>an open query. But isn't it the duty of IntraBuilder to close
> >>all database components when a connection ends ?
> >>
> >Well, yes, it is IntraBuilder's responsibility to do that. On
> >the other hand, it's my kid's responsibility to clean up after
> >themselves also; but, they rarely do.
> >
> >>I know last year I had a problem with IB 1.01 when I reloaded
> >>a form that left an open database - IB crashed - until I found
> >>out that I had to close the database by myself immediately after
> >>performing a query.
> >>
> >>If IB gets into a state when the browser shows an too many simultaneous
> >>users error, there seems to be no automatically reset by IntraBuilder
> >>itself, even after several hours, unless I do the restart manually.
> >>
> >Yup. That's what I've seen too. And since it seems the database
> >connections are handled through the broker (not the agents), I've
> >had to restart the web server AND the intrabuilder server to clear
> >the problem. So I would advise being VERY sure to close all your
> >database connections yourself. Once I found the last of mine, my
> >system's been running non-stop for about two months now with no
> >restarts necessary, and moderate load.
> >
> >>Regards,
> >>Joachim
> >
> >And regards to you.
> >
> >Thom
> >
> >
> >

Dwight, the document contains no data error comes from not seting up
registry properly for the monitor - have aloo in server.hlp file

>I was reading some threads on this issue. I saw one also from A.A. Katz
>on this back in November 1997 from a problem seen by
>vaahtera@infotools.fi and he had seen where bunch of sessions have blank
>forms and no session IDs, and it finally loads up the server and they
>have to reboot. I have the same thing happen myself.
>
>Did any of you ever find the reason for this? Does it simply have to do
>with not closing sessions or database or queries down by setting the
>active property to false? Or is there something else happening? I know
>this only happens on occasion, and it seems like it has to do with
>interrupting a form midstream while doing a query. And it seems to
>happen more often too with reports. Once you get one in there that never
>loses the BUSY status, they start to pile up, until u get too many
>simult users. WHats the recommendation here to avoid this all?
>
>On another note, any idea why my intrabuilder server monitor would
>return "Document contains no data" ?
>
>Thanks
>Dwight Furleigh
>Cat Ag Products
>Furleigh_Dwight_D@cat.com
>
>
>
>Joachim Pimiskern wrote:
>>
>> Hello,
>>
>> about three times a week I get the message >>Alert. Too many simltaneous
>> users<<
>> when I'm entering my IntraBuilder 1.5 page, and I've to reboot my IIS
>> server
>> (or what is more precise, have to restart IntraBuilder).
>>
>> What can I do to increase the number of possible simulateneous users ?
>>
>> TIA
>> Joachim
>
>
>
>Alan McDonald wrote:
>>
>> Thom,
>> what event or procedure do you use to close the database connection and
also
>> how do you open them (I mean where's the best place to open them)? Forms
>> require that they remain open for the session so is there a way of
closing
>> the db connection on session close?
>>
>> >Previously, Joachim Pimiskern <J.Pimiskern@realgarant.de> taught us all
>> that:
>> >
>> >>Thom,
>> >>
>> >>thank you for this advise. I'm trying to find places where I leave
>> >>an open query. But isn't it the duty of IntraBuilder to close
>> >>all database components when a connection ends ?
>> >>
>> >Well, yes, it is IntraBuilder's responsibility to do that. On
>> >the other hand, it's my kid's responsibility to clean up after
>> >themselves also; but, they rarely do.
>> >
>> >>I know last year I had a problem with IB 1.01 when I reloaded
>> >>a form that left an open database - IB crashed - until I found
>> >>out that I had to close the database by myself immediately after
>> >>performing a query.
>> >>
>> >>If IB gets into a state when the browser shows an too many simultaneous
>> >>users error, there seems to be no automatically reset by IntraBuilder
>> >>itself, even after several hours, unless I do the restart manually.
>> >>
>> >Yup. That's what I've seen too. And since it seems the database
>> >connections are handled through the broker (not the agents), I've
>> >had to restart the web server AND the intrabuilder server to clear
>> >the problem. So I would advise being VERY sure to close all your
>> >database connections yourself. Once I found the last of mine, my
>> >system's been running non-stop for about two months now with no
>> >restarts necessary, and moderate load.
>> >
>> >>Regards,
>> >>Joachim
>> >
>> >And regards to you.
>> >
>> >Thom
>> >
>> >
>> >

"Alan McDonald" <alan@pmasoft.com.au> wrote:

>Dwight, the document contains no data error comes from not seting up
>registry properly for the monitor - have aloo in server.hlp file

Alan (and others) -- please try to trim your quotes -- there was no
need to quote this whole long message ... thanks.

Ken

---
Ken Mayer [TeamB]

Please respond in the newsgroup unless explictly asked otherwise

Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

I reinstalled Intrabuilder and didnt reset setting in registry, it
dawned on me after i wrote this.

So what about the important question!!!-is there denial of a problem by
Inprise, or did everyone just give up on that one??? WHat is the correct
thing to do to avoid the "too many simultaneous users" problem that
stems from non expiring sessions?????



Alan McDonald wrote:
> 
> Dwight, the document contains no data error comes from not seting up
> registry properly for the monitor - have aloo in server.hlp file
> 
> >I was reading some threads on this issue. I saw one also from A.A. Katz
> >on this back in November 1997 from a problem seen by
> >vaahtera@infotools.fi and he had seen where bunch of sessions have blank
> >forms and no session IDs, and it finally loads up the server and they
> >have to reboot. I have the same thing happen myself.
> >
> >Did any of you ever find the reason for this? Does it simply have to do
> >with not closing sessions or database or queries down by setting the
> >active property to false? Or is there something else happening? I know
> >this only happens on occasion, and it seems like it has to do with
> >interrupting a form midstream while doing a query. And it seems to
> >happen more often too with reports. Once you get one in there that never
> >loses the BUSY status, they start to pile up, until u get too many
> >simult users. WHats the recommendation here to avoid this all?
> >
> >On another note, any idea why my intrabuilder server monitor would
> >return "Document contains no data" ?
> >
> >Thanks
> >Dwight Furleigh
> >Cat Ag Products
> >Furleigh_Dwight_D@cat.com
> >
> > >> >

Well, discussions with Thom Randolph has lead me to believe that you need a
lot of hand code cranking to avoid this prob. You need to open and close
queries and databases manually. It works for him he says but it may be that
it's too much work for me. It may be less work to migrate the functionality
to another tool.....

Alan

>So what about the important question!!!-is there denial of a problem by
>Inprise, or did everyone just give up on that one??? WHat is the correct
>thing to do to avoid the "too many simultaneous users" problem that
>stems from non expiring sessions?????
>

I can't beleive that.... :(  Talk about disillusionment here.
Does Ken Mayer, or anyone from Inprise, have anything to add? Have they
reproduced the problem? 

Dwight

Alan McDonald wrote:
> 
> Well, discussions with Thom Randolph has lead me to believe that you need a
> lot of hand code cranking to avoid this prob. You need to open and close
> queries and databases manually. It works for him he says but it may be that
> it's too much work for me. It may be less work to migrate the functionality
> to another tool.....
> 
> Alan
> 
> >So what about the important question!!!-is there denial of a problem by
> >Inprise, or did everyone just give up on that one??? WHat is the correct
> >thing to do to avoid the "too many simultaneous users" problem that
> >stems from non expiring sessions?????
> >

"Dwight D. Furleigh" <Furleigh_Dwight_D@cat.com> wrote:

>I can't beleive that.... :(  Talk about disillusionment here.
>Does Ken Mayer, or anyone from Inprise, have anything to add? Have they
>reproduced the problem? 

Unfortunately, I have no insight on this. Sorry ... 

Ken
---
Ken Mayer [TeamB]

Please respond in the newsgroup unless explictly asked otherwise

Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm