Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread CallBackResponse error in server
Thu, Sep 16 2021 6:54 AMPermanent Link

David

Hi.  I have noticed that my DB has become slower recently due to the number of people/data and in order to stop some of the not responding errors I have bunged in some QueryProgress events to show the progress and possibly reduce this error somewhat, or at least stop people from ending the task because 5-10 seconds is too slow!!

Anyway since doing this I have noticed a few REQUST_CALLBACKRESPONSE errors in the server and I wondered is this related in anyway to the Query Progress event?

Thanks
David.
Tue, Sep 21 2021 6:37 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

Sorry about the delay in getting you a response.

<< Hi.  I have noticed that my DB has become slower recently due to the number of people/data and in order to stop some of the not responding errors I have bunged in some QueryProgress events to show the progress and possibly reduce this error somewhat, or at least stop people from ending the task because 5-10 seconds is too slow!!

Anyway since doing this I have noticed a few REQUST_CALLBACKRESPONSE errors in the server and I wondered is this related in anyway to the Query Progress event? >>

I would have to see the log entry itself to be sure, but typically those types of errors are caused when the server tries to send a progress, status, or log event and the send fails due to the client disconnecting, etc.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Sep 21 2021 11:22 AMPermanent Link

David

Hi Tim.

I went back to a prior executable without the onProgress event and this seems to have calmed down now.  I haven't tried yet with an updated version yet but as far as I know, this was the only change I had made so it looks like it was the cause.

I had an application.processmessage in the onProgress event though and I see from other posts that this can have an adverse effect on some operations?

Regards
David.

Tim Young [Elevate Software] wrote:


I would have to see the log entry itself to be sure, but typically those types of errors are caused when the server tries to send a progress, status, or log event and the send fails due to the client disconnecting, etc.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Sep 21 2021 11:22 AMPermanent Link

David

Hi Tim.

I went back to a prior executable without the onProgress event and this seems to have calmed down now.  I haven't tried yet with an updated version yet but as far as I know, this was the only change I had made so it looks like it was the cause.

I had an application.processmessage in the onProgress event though and I see from other posts that this can have an adverse effect on some operations?

Regards
David.

Tim Young [Elevate Software] wrote:


I would have to see the log entry itself to be sure, but typically those types of errors are caused when the server tries to send a progress, status, or log event and the send fails due to the client disconnecting, etc.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Sep 21 2021 2:30 PMPermanent Link

Raul

Team Elevate Team Elevate

On 9/21/2021 11:22 AM, David wrote:

> I went back to a prior executable without the onProgress event and this seems to have calmed down now.  I haven't tried yet with an updated version yet but as far as I know, this was the only change I had made so it looks like it was the cause.

Sounds like clients are either terminating the app during query
execution or device goes to sleep or off Wifi or such causing connection
to dbsrvr to drop.


> I had an application.processmessage in the onProgress event though and I see from other posts that this can have an adverse effect on some operations?

Generally bad idea yes - inb most cases due to this pumping the window
message queue so you can get things like mouse clicks or keyboard input
if your controls are enabled possibly leading to reentrancy issues and such

Raul
Tue, Sep 21 2021 2:56 PMPermanent Link

David

Yes that was what I thought as well but could not see any re-connections in the server but logic was simply, "what did I change"  Seemed like a good idea at the time and worked locally fine but not when multiple users on the server.


Raul wrote:

On 9/21/2021 11:22 AM, David wrote:


Generally bad idea yes - inb most cases due to this pumping the window
message queue so you can get things like mouse clicks or keyboard input
if your controls are enabled possibly leading to reentrancy issues and such

Raul
Wed, Sep 22 2021 8:29 AMPermanent Link

Raul

Team Elevate Team Elevate

On 9/21/2021 2:56 PM, David wrote:
> Yes that was what I thought as well but could not see any re-connections in the server but logic was simply, "what did I change"  Seemed like a good idea at the time and worked locally fine but not when multiple users on the server.

Still curious - if all you added was query onprogress events then
without those clients should still be timing out and disconnections
should still be happening occur (you just have less info in logs -
probably just session disconnecting now).

What are you DSSRVR session settings and remote session timeouts in general

Raul
Wed, Sep 22 2021 2:33 PMPermanent Link

David

Hi Raul.

TimeOut 300s, Dead Session Clean up 30s, Dead Session Exp 7200s.

I have only changed the Exp from default 12 hours to 2 hours as it allows user to unplug from network, move to new location and re-connect.

David


Raul wrote:

On 9/21/2021 2:56 PM, David wrote:
> Yes that was what I thought as well but could not see any re-connections in the server but logic was simply, "what did I change"  Seemed like a good idea at the time and worked locally fine but not when multiple users on the server.

Still curious - if all you added was query onprogress events then
without those clients should still be timing out and disconnections
should still be happening occur (you just have less info in logs -
probably just session disconnecting now).

What are you DSSRVR session settings and remote session timeouts in general

Raul
Image