Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

calling report from forms in formsreports 11.1.2 ..Failure of Apache bridge

536090Jun 17 2012 — edited Jun 18 2012
Dear forum members,

*1. Intro*

I/m facing a problem which is making me crazy.
Objective: Upgrading a forms 6i application to a reliable, functionable Forms / Reports 11 application (without SSO), including database 11gr2.

I've read a few thousends of PDF pages (I guess) and came up so far as outlined below (in detail). I must have missed something..:-)

6 - > 10 without problems

10 -> 11 Questions / problems

*2. Installation summary*

2A. Development

Development Environment (single machine):
Windows 7 64 bit
Oracle FormsReports 11.1.2 (development install)
WebLogic 10.3.5
Java 1.6.29
Weblogic port 7001 (running Forms and Reports)
Loopback adapter: 192.168.137.1 hpfr11.mysite.nl

Everything OK, ie: forms are running smoothly.
When I'm calling a report by pressing a 'Form' button with a 'when-button-pressed trigger, a nice report shows up in my browser (PDF, htmlcss etc)).
I'm using this code (because only 1 machine has been used):
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1) || '?server='||v_repserver,'_blank' );

So far so good, no problems.

Next step...

2B. Deployment Environment
Clients: Windows 7 64 bit
Server Windows 2008 R2 (64 bit)
Oracle FormsReports 11.1.2 (server install)
WebLogic 10.3.5
Java 1.6.29
Loopback adapter: 192.168.137.1 hpfr11.mysite.nl

Weblogic port : 9001 and 9002 (9002 is 'reports inprocess server')
ohs port : 8888.

Settings W2008 r2 server:
- wireless adapter connected to a router (DHCP enabled), ICS to loopback adapter (192.168.137.1)
- loopback adapter installed. Hosts file (windows32) setting: 192.168.137.1 hpfr11.mysite.nl
- Ipv6 disabled in both adapters.
- Forms.conf and reports_ohs.conf altered in ip adress 192.168.137.1 (as susggested))
- Oracle FormsReports 11.1.2 (deployment install) on my loopback adapter. Installed succesfully (as it said)

Development files (fmb, mmb , rdf, pll and olb) installed on my w2008 r2 server (each form compiled again).

Results:
1. Forms can be seen on my server screen as well as on my client screens.
2. Oracle Enterprise manager works fine in server as well as client settings
3. Webutil configuration (wu_test_106.fmb and others) in my application works fine for server and clients

*3. Problems*

After I have started up ohs, weblogic admin, wls_forms and wls_reports (and checked if the inprocess server is running)) on my server, I faced serious problems in the folowing cases:


3.1 Report is displayed on the server screen but Forms hang / is dead after exiting the reports browser result.

The report is displayed in the (server and client) screen if:
I'm calling a report from a form with the Form 'when-button-pressed trigger' including the corresponding code WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1) || '?
server='||v_repserver,'_blank' ).
As soon as I close the report screen, the remaining Forms screen hangs / is dead. After exiting the form screen, the message appears: Failure of Apache bridge: no backend server available...

3.2 Report is displayed on the server screen but NOT on the client screen:

If I'm using WEB.SHOW_DOCUMENT('http://hpfr11:9002/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1) || '?server='||v_repserver,'_blank' );
Serverside is still in the air. No report screen is shown up on the client side.

*4. QUESTIONS:*

1. Can someone give me a solution for the problem i'm facing ?
2. If the clients can see Oracle Enterprise manager and can see the Forms screens, is it reasonable to assume they can see the Reports screen as well ?

Looking forward for any possible solutions.

Greetings Martin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2012
Added on Jun 17 2012
3 comments
731 views