I'm trying to migrate some reports from our 10.1.2.0.2 app server to an 220.127.116.11 one. The report I am currently working with compiles and runs fine in 10g Reports Builder, but when I copy it to the new 11g middleware server and try to run it, it gives me the following error:
REP-1247: Uncompiled program units exist.
REP-1247: The report contains uncompiled PL/SQL.
There is no uncompiled PL/SQL in the report (that I can find), however googling this error it appears there could be something else wrong. I have been unable to get Developer 11g working on my workstation and I can't find a script to compile the report on the 11g middleware server. I am using a .RDF report and not a .REP one. Can someone help me troubleshoot this problem?
I have the same issue but at the same time it is hard to recompile each and every report manually(since there are hundreds of reports which are to be migrated). So, is there any other way I can compile all of the reports against the 11g report server, at once?