[sknmail@rediffmail.com]

Hi Chris,

Thanks very much for the information.

Let me give some more info on how the setup is configured. Quite possible that I am doing a major mistake in the configuration.

System 1 - App and Web is configured.
System 2 - Where Oracle Reports and OTM Report installation is done.

Please find the details configured when installing Oracle Report installation

Instance name = rep_otmrpt with a valid Password configured.

Now when you look from Oracle AS control using url http://<oraclereportserverFQDN>:1810, I see the application server name as
"Application Server: rep_otmrpt.<oraclereportserverFQDN>" and in the System Components list on same page, you would find the Report server named as "Reports_server: rep_<oraclereportserverhostname>".

Now I have performed the OTM Reports installation using OTM Installer on System 2 where I pointed all the respective servers properly. After installation of OTM Reports, I got a windows service named "otmrptweb55" which is listening http on port 81 on Reports server. So all the standard parameters required for reports in glog.properties of AppWeb Server on System 1 is configured which has a reportserver @ 81 port as value for report_server_url parameter.

And as per the OTM Administration Guide I have done all the copy and modification of required files.

Now on System 1 where App and Web is configured for OTM, there in the glog.properties if I configure the value for P_reports_server as "rep_otmrpt" or "rep_otmrpt.<oraclereportserverFQDN>", after proper startup of all respective servers, on running a report from OTM UI, "Bad Bind Variable rep_otmrpt...." is displayed.

However if I am setting the value for P_reports_server as "rep_<oraclereportserverhostname>" in same glog.properties, I don't get this error message as soon as I run the reports from OTM UI. However after around 5 - 8 minutes I get the error page in OTM UI as
"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request"

And the respective log files of Apache on Oracle Report Server gets logged with description mention as below -

On Oracle Reports Server, the "Access.log" file details from Apache logs as below -

"172.16.143.113 - - [13/Jun/2007:14:20:18 +0530] "GET /reports/rwservlet?hide_pas
s_key&report=bill_of_lading&destype=CACHE&desforma t=PDF&P_FORMAT=View%20PDF&PARA
MFORM=NO&TOLERANCE=0&SERVER=rep_hcs-wst004&P_REPORTS_SERVER=rep_hcs-wst004&P_REP
_USERID=hide_pass_key&P_GL_USER=SKN.ADMIN&P_DOMAIN =SKN&P_REPORT_GID=BILL_OF_LADI
NG&P_DATABASE_CONN_STRING=OTMv55&P_REPORTS_OUT_DI R =d:/OTMv55_CU2_Report/rptapach
e/htdocs&P_REPORT_CALL=/GC3/glog.webserver.oracle.rw.RWServletProxy&P=T&P_L_SH IP
MENT_ID=\"SAME%20AS~'SKN.01010'\"& HTTP/1.1" 500 630"

The "Error.log" file from Apache on Oracle Reports server logs the error as below -

"[Thu Jun 14 16:45:51 2007] [error] [client 172.16.143.113] [ecid: 1181817350:172
.16.143.119:5904:3012:1,0] MOD_OC4J_0145: There is no oc4j process (for destinat
ion: OC4J_BI_Forms) available to service request.
[Thu Jun 14 16:45:51 2007] [error] [client 172.16.143.113] [ecid: 1181817350:172
.16.143.119:5904:3012:1,0] MOD_OC4J_0119: Failed to get an oc4j process for dest
ination: OC4J_BI_Forms
[Thu Jun 14 16:45:51 2007] [error] [client 172.16.143.113] [ecid: 1181817350:172
.16.143.119:5904:3012:1,0] MOD_OC4J_0013: Failed to call destination: OC4J_BI_Fo
rms's service() to service the request."

Do you think I am missing any major configuration item in this process? or Do you feel there is a request time out happening, as for more than 5 - 8 minutes my OTM UI is displayed properly, however after around 10 minutes I see the error page displayed.

Please let me know you view. Thanks very much in advance.

Regards,
Suresh