I'm trying to migrate some reports from our 10.1.2.0.2 app server to an 188.8.131.52 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?
you can try the following options
1- Run the report passing RECURSIVE_LOAD=no as parameter and see behavior
2- To compile all the reports you can use rwconverter and a windows script.
REM WINDOWS COMPILE REPORT
Echo compiling Report .....
for %%f IN (*.rdf) do (
<YOUR ORACLE_HOME>\bin\RWCONVERTER.bat USERID=user/pass@db BATCH=yes STYPE=RDFFILE SOURCE=%%f DTYPE=REPFILE OVERWRITE=NO
ping 184.108.40.206 -n 1 -w 20000 > nul
ECHO FINISHED COMPILING
Hope this helps, Roberto