HTTP 500 and IE "Excessive amount of time"

cdawes

VIP Member
HTTP 500 and IE \"Excessive amount of time\"

I have one JDE application where in Internet Explorer users sometimes get the error "The server is taking an excessive time to process your request". The App is Job Status Inquiry (P512000)
Wondering in general if you've seen this IE issue before.

I also have an issue on a few Apps where users get an "HTTP 500" issue. If the user closes the browser and logs out and back in things are fine.

For either issue pretty much nothing in the Enterprise Server or JDE logs.

Anyone seen either of these issues before?

System config is 812/8.98.0.4,Oracle 64 bit 2 node 10.0.2.4 RAC on Windows 2003 64 bit, WAS ND 6.1.0.15 on Windows 2003 32 bit, 2 Intel Enterprise Servers on Windows 2003 32 bit.

WAS Servers are balanced via a Cisco ACE with 6 JVM's for Production spread across 2 servers.

Colin
 
Re: HTTP 500 and IE \"Excessive amount of time\"

Colin,

We have seen that before. Mainly with poorly defined inquiries which do not use an index on a large table or return a large amount of data. Another possible cause is a busy network or server - if this is the cause, the error won't appear with exactly same inquirey at another time.

It can indicate that another index may be required - expecially with custom applications.
 
Re: HTTP 500 and IE \"Excessive amount of time\"

Take a look in your http_plugin.log to see if you are getting this error:

[Fri May 22 03:41:50 2009] 00000624 00000a5c - ERROR: ws_common: websphereWriteRequestReadResponse: Failed to find an app server to handle this request


It likely is this issue:


http://www-01.ibm.com/support/docview.wss?uid=swg24019451

Abstract
Client side errors are incorrectly marking application servers down. Allow this maintenance to be installed additionally on 6.1.0.17 and copy the 32/64-BIT executable.


ERROR DESCRIPTION:
An IBM® WebSphere® Application Server plug-in is marking servers down when a read from the client fails. This causes excessive errors for users of the plug-in.


From the Oracle website:

Note: The iFix PK67161 is required for fix pack 15 (6.1.0.15) only if you experience a 500 error code and backend servers will be marked down. Please refer to IBM reference doc ID:4019451 to more details.



[ QUOTE ]
I have one JDE application where in Internet Explorer users sometimes get the error "The server is taking an excessive time to process your request". The App is Job Status Inquiry (P512000)
Wondering in general if you've seen this IE issue before.

I also have an issue on a few Apps where users get an "HTTP 500" issue. If the user closes the browser and logs out and back in things are fine.

For either issue pretty much nothing in the Enterprise Server or JDE logs.

Anyone seen either of these issues before?

System config is 812/8.98.0.4,Oracle 64 bit 2 node 10.0.2.4 RAC on Windows 2003 64 bit, WAS ND 6.1.0.15 on Windows 2003 32 bit, 2 Intel Enterprise Servers on Windows 2003 32 bit.

WAS Servers are balanced via a Cisco ACE with 6 JVM's for Production spread across 2 servers.

Colin

[/ QUOTE ]
 
Re: HTTP 500 and IE \"Excessive amount of time\"

P512000 is a Job Cost program with user defined columns, generally each column is a different ledger type (AA/AU, JA/JU, PA/PU, plus additional calculated amounts using other ledgers) from the Account Balances table (F0902). The account ranges are also user defined. It is very easy to create a query selecting millions of records out of the F0902 if the user is not careful in the definition of the (1) date ranges, (2) account ranges, and (3) the ledger types selected for the columns. Also a variable will be the size of the F0902 table along with all of the usual suspects in performance.
Try defining a new column layout using just the AA ledger and a limited range of accounts and dates and gradually build up to something more similar to the column definitions that cause the excessive wait times. Via a little trial and error you should be able to find what is the real culprit(s). Good luck.
 
Re: HTTP 500 and IE \"Excessive amount of time\"

@#!&# people changing the MTR's without updating the "What's New page". Really, who could have seen the fine print?

Thanks - may as well just go to 6.1.0.21 on any or all of the components since this is supported and if it fails well - easy to roll back.

Recommended Fixes:
http://www-01.ibm.com/support/docview.wss?rs=180&uid=swg27006921

Update Strategy:
http://www-01.ibm.com/support/docview.wss?rs=180&uid=swg27009276

Java SDK Update Policy:
http://www-01.ibm.com/support/docview.wss?rs=180&uid=swg21138332

Plug In Update Policy:
http://www-01.ibm.com/support/docview.wss?rs=180&context=SSEQTP&uid=swg21160581

Maintenance Download Wizard:
http://www-01.ibm.com/support/docview.wss?rs=180&uid=swg27009393
 
Re: HTTP 500 and IE \"Excessive amount of time\"

Here's what's helped for our HTTP 500 errors:
1) Make sure the user is only logging into JDE once on the machine.
2) Reduce the size of the IE cache file (we use 100 megs), and set IE to empty temp files when browser is closed.

IE will set cache size to 10% of disk by default. On the current HD's that's over 1 gig. IE does a poor job of managing cache that big. The 500 response looks like a server issue, but is more a case of bad requests.
 
Back
Top