March 5th, 2007, 15:39
|
 | Site Moderator | | Join Date: Jun 2006 Location: West Chester, PA
Posts: 849
Thanks: 53
Thanked 205 Times in 124 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10 | |
Ian,
Can you post the full error that you encountered, including a stacktrace - if one exists? I've seen these types of errors in 3 cases: - When the OTM-defined connection pool doesn't have enough DB connections to support the current requests. This most likely isn't there case here - as this usually happens on app-server intensive processes like bulk-plans, integration, etc. This is more closely related to a previous post: http://www.otmfaq.com/forums/f14/exc...r-release-129/
- When there aren't enough connections defined in the DB itself to support all of the connections from both OTM and Oracle Reports. The minimum recommended value is 200 (per the Admin guide), though I usually use 300.
- When there aren't enough Oracle Reports engines to satisfy the current requests. From you config, you can run up to 30 at one time, which should be enough - though I'd need to know more about how many reports you usually run.
Hope this helps!
--Chris
Last edited by chrisplough : March 5th, 2007 at 15:44.
|