View Single Post
  #4 (permalink)  
Old March 23rd, 2007, 02:44
ianlo ianlo is offline
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 149
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 1 Time in 1 Post
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Quote:
Originally Posted by Stefano View Post
Hello All,
We are using ORACLE report server to implement report for our customers, but we have a lot of problem, printing large report...
  • Problem of engine crash, where in reports log (extendend one) you can't understand why happens. Otherwise usually if you re-print same report after a while or after have printed another one small report , report works without problem.
  • Problem of internal server error on OTM page, but report continues to work and if you control on report server control console you can see that report finish later without problem...we change our timeout parameter..but seems don't use it.
  • problem of presentation in HTML format where sometimes you have rows overlapped
Looking at this situation we are asking if someone use a different rugged solution for implementing report to connect to OTM, for example Jasper??

Thanks in advance for your answer.
Hi Stefano,

Which OS is your reports server on? I am using Windows 2003 Server and what I do is that I created a CMD script to be executed every 3 days (Wed and Sunday) that restarts OTM Reports Server and Oracle Reports Server. This might help resolve #1 and #2. However #3 is also what I am experiencing when my result set is very large.

Let me know if you want the CMD scripts.