[chrisplough]

Stefano,

What version of OTM are you running? I ask because the architecture was significantly different before OTM/GC3 v5.0. I'll assume OTM v5.0/v5.5 based on your previous posts, but let me know if otherwise.

Try the following next time you experience this problem:

1. Restart just rptapache
   1. Test to see if that fixes the issue
2. Restart just the Oracle Reports server
   1. Test to see if that fixes the issue
3. Restart just the OTM Web Tier (Apache/Tomcat)
   1. Test to see if that fixes the issue

That will help isolate the cause of the issue. Let me know how this goes and I can help you moving forward.

A few quick best-practices for reports:

1. Prior to OTM v5.0, Win32 was the best (most stable) Oracle Reports platform
2. For v5.0 and later, Linux appears to be the best platform
3. Whenever possible, keep your OTM Oracle Reports instance separate from any other reporting instances -- i.e. don't combine with an existing Oracle Reports Server
4. Use the separate Forms/Reports installer that Oracle provides, not the full Oracle Application Server installation - this uses far less resources and is much more stable.
5. Ensure that you clear out your Oracle Reports cache directories regularly, otherwise you can end up with directories that have thousands of files, causing performance and stability issues.
6. As with all OTM tiers, restart on a regular basis: weekly or bi-weekly. Some clients can get away with monthly, but shorter intervals are more common.

The integration between OTM and Oracle Reports has definitely been one of the most difficult parts of OTM - so you're not alone in your frustration. With some work, though we may be able to stabilize your environment.

I hope this helps!

--Chris