Re: Extending the “No Instance Available” timeout
Re: Extending the “No Instance Available” timeout
- Subject: Re: Extending the “No Instance Available” timeout
- From: Dev WO <email@hidden>
- Date: Tue, 05 Apr 2016 11:22:19 +0200
Hi Ben,
Your ping time isn’t the issue for sure, as far as I remember the time out is something like a minute…
I think the issue is more on the “application” side.
Try to see if you have anyway to get some log. Eventually output the SQL for your app to see if you forget to do some batch when accessing the database (if you see a row by row select, that is probably the primary issue to fix)
If it’s a Wonder app: log4j.logger.er.transaction.adaptor.EOAdaptorDebugEnabled=INFO either on your Property file or as a launch argument.
Xavier
> On 05 Apr 2016, at 11:02, Benjamin Chew <email@hidden> wrote:
>
> Hi Everyone,
>
> I’m wondering if any of you kind souls can help me. :)
>
> I’m in Singapore working off a VPN connection to the States, and while waiting for some database-intensive components to display, I keep getting “No Instance Available” because it’s taking so long to complete all the queries (ping times ~ 200ms).
>
> I’ve tried going to WOMonitor on my local machine (localhost:56789) and modified the Send, Receive and Connect timeouts, but that didn’t seem to help. I’ve also tried changing WOMaxSocketIdleTime and WOLifebeatInterval in my Eclipse debugging profile, but that didn’t help either.
>
> Does anyone have any ideas?
>
> Thanks,
> Ben
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden