Bug of the Week: FRM-41214 – Unable to Run Reports 10g From Forms 11g

Now that I’ve been doing upgrades to 11g R2 for the last 6 months, I am starting to see all types of architectures and have been getting special requests. This week one of my customers asked me to migrate the forms to 11gR2 but to keep the reports on the 10.1.2.3 servers. While doing this, I found this week’s ‘bug of the week‘.  An annoying one to find but fortunately it already has a patch all ready to go.
Running the reports from the Forms from the outset was not a problem. The reports were able to run as long as the two servers shared a common IP subnet. You can check which Oracle Reports bridges are configured and running in the subnet using the rwdiag utility. For example, run the following command:
/bin/rwdiag -findall
You should get a list of all the reports servers that were discovered.
For example (from Oracle):
Broadcast mechanism used to locate servers 
------------------------   
Channel address = 228.5.6.7 Channel port = 14021 
(1) Name = bugupdate : Type = server : Host = strep15.idc.oracle.com 
(2) Name = rep_sup: Type = server : Host =sup-pc.idc.oracle.com 
(3) Name = rep_stre : Type = server : Host = stre.idc.oracle.com 
However, after the report was run without a problem and we could see the PDF in the browser, we got the following popup error message:  FRM-41214 – Unable to run Report . It was quite annoying but, fortunately, we quickly found the bug: Running Reports 10.1.2.3 with Forms 11g.
 
This interoperability scenario requires the Patch 7597820 to be installed on the Reports 10.1.2.3 ORACLE_HOME.You can download this patch from the following URL:
http://updates.oracle.com/download/7597820.htmlThis patch is required to address the CORBA IDL changes between the two releases for the Job Status information. If you want to use rwservlet of Reports 10g Release 2 (10.1.2.3) with the Reports 11g Release 1 (11.1.1) Server, ensure that you install this patch on your 10.1.2.3 installation.You can download this patch from http://metalink.oracle.com.
It is also well documented in the Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services:
http://download.oracle.com/docs/cd/E17904_01/bi.1111/b32121/pbr_verify006.htm
The patch takes only about 3 minutes to install since it requires a report server restart.
Have you encountered this bug? Let me know if my tip helped!
About these ads

One comment on “Bug of the Week: FRM-41214 – Unable to Run Reports 10g From Forms 11g

  1. I uninstalled the JRE 5 update 6 and installed JRE 6 update 39. We are having problems with Java 7 so we install Java 6 update 39. Update 45 also works but not fully tested with our apps. Printing now works.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s