HTTP 500 during AJAX call to wwv_flow.show
DanPApr 2 2012 — edited Apr 30 2012Hello everyone,
I'm new to a team who is using APEX and I'm also new to APEX. Powerful stuff and fun to learn but I'm hung up on something and I'm hoping someone out there can help. We're on 4.1.0.00.32 running on widows apache against an AIX hosted 11.2.0.2.0 db. All clients are IE7 and have an intermittent issue that shows up with a low percentage of our AJAX calls in APEX. I've searched but haven't spotted anything that seems to be related already poested.
The user is filling out a series of questions via where the options are populated iwth AJAX calls. This almost always works fine and shows up in the Apache logs as:
+<client IP> - <some user> [29/Mar/2012:10:50:35 -0400] "POST /apexp/wwv_flow.show HTTP/1.1" 200 5+
But sometimes, rarely it fails with an Internal Server Error:
+<client IP> - <some user> [29/Mar/2012:10:55:41 -0400] "POST /apexp/wwv_flow.show HTTP/1.1" *500* 0+
At this point the user's browser is hung. They could have up to 30 minutes worth of work in on that page already and their only alternative is to kill IE, log in again and start over.
Nobody on my team has been able to reproduce and they do have signifiicant APEX experience. We don't spend hours on that form as our users do. We tried hard coding a div by zero error in the db code and that results in an HTTP 200 with the error passed cleanly back as you'd expect. Has anyone else experienced this crash of wwv_flow.show? Anyone know a fix or workaround? Is this documented somewhere and I just missed it?
TIA,
Dan