JBO-30003: The application pool failed ...

Lately I've been troubleshooting "JBO-30003: The application pool failed to checkout an application module" error with Oracle Application Server 10g. The person which reported the error, said that this is definitely server side issue. So I started to debug this problematic java application.

Oracle Metalink and Oracle forums claims that this is DB connection related error. So after dealing with some OC4J different configurations I started to debug this application on OS level.

First thing I've done, I've checked with tcpdump where this application is trying to connect, and found out that it's trying to connect to wrong DB server. Somebody hardcoded wrong connection in the application. Is that server side error? I don't think so.

To be 100% sure that it's gonna work with proper connection, I've redirected traffic addressed to wrong DB server to proper one and application started to work flawlessly.

So when you see this error you should really check DB connections.

Comments

Hi
Can you tell me where the hard coded value was found. We have the same problem and can't seem to find where this could be hard coded.

DB connect string was hardcoded into application, which is just a bad practice. That shouldn't happen. But if you got noobie programmers that could happen to you too. Of course wrong connect string can be found in forms config files. Sometimes it looks ok, but could work wrong. For example when your host resolve dns names to outdated IPs (then check /etc/hosts, or hosts file in windows or dns server/client configuration). Try tnsping to check if db connection works ok.

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Main menu

Article | by Dr. Radut