View Single Post
  #5 (permalink)  
Old July 3rd, 2007, 12:36
sknmail@rediffmail.com sknmail@rediffmail.com is offline
Member
 
Join Date: May 2007
Location: India
Posts: 69
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 2 Times in 2 Posts
Rep Power: 2
sknmail@rediffmail.com is on a distinguished road
Send a message via Yahoo to sknmail@rediffmail.com
Re: Error configuring Oracle Reports with OTM

Hi Chris,

Sorry for the delay in response, as my report server got crashed :-) due to memory issue....

The Tnsnames entry on my app/web server is as below -

OTMv55 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.143.104)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =otmv55)
)
)

The value I specified for "p_reports_server" on app/web server's glog.properties file was based on the information I got from "SERVER" parameter found in "rwservlet.properties" file on the Report Server.

However with this existing configuration, the current status before my report server server got crashed was; those reports which were developed and deployed without parameters are working perfectly, however if there is a report parameter to be configured, then those are take a hell lot of time and finally the browser shows the error page as mentioned in the issue. I do have taken proper care while configuring the report parameters in OTM from Business Process Auto. -> Powerdata -> Doc. Gen. -> Reports. Do you feel its an issue of Request timeout.. well for that matter do have increased the timeout period for all the apache config file on servers involved.

Thanks very much Chris for the additional checks which were asked to perform.

Please let me know if anybody thinks I am missing any configuration...

Thanks very much in Advance.

Regards,
Suresh
Reply With Quote