REP-1437 Runtime error in the PL/SQL(Oracle 8i)

Posted on 2003-11-24
Medium Priority
Last Modified: 2013-12-11
Dear All,

I am using the following software and versions.
Report Builder
ORACLE Server Release
Oracle Procedure Builder
Oracle ORACLE PL/SQL V8. - Production.
I created functions in package (in oracle database) and refering in oracle reports. I complied all the report files and tested. It is working fine. I created the database script from the development server and executed it on the production server. Database created successfully with out any compilation errors. But reports are not running. Both the development and production servers versions are same and I configured all according to the development server configuration.

I am getting the following funtime error on my production server.
REP-1437 Runtime error in the PL/SQL development environment(DE).
PDE-PSD001 Could not resolve reference to <Unknown Program Unit> while loading <Unknown> <Unknown>

It is not possible for us to compile manually all the reports again on the production server as it is at the client side.

1. If we created a database with the same name and on same version is it need to compily all the oracle reports 6i files again. There is no problem with the oracle forms 6i.

2. If compilation is required, Is there any workaround to solve the problem other than compilation.

3. Is there any tool to compile all the report files(we have around 100 reports) at once.

Looking for your help/suggestions

Krishna Reddy M
Question by:mckreddy
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 22

Expert Comment

by:Helena Marková
ID: 9816768
If you use REF cursors then it is bug 1275333 - REF CURSOR BASED REPORT NEEDS TO BE RECOMPILED IF CONNECTING TO OTHER INSTANCE - Database Version 8.0.6 - Fixed in Product Version

Problem description:
Customer built some reports based on ref cursors, compiled them, obtained rep files, but he couldn't use the rep files with other oracle instances, he can connect only to instance which took part in his development (in compilation), so just if he has some other identical to development db instance he cannot connect and execute the report against the instance.

Possible workarounds:
1.  use the rdf file
2.  Put the stored package into the report itself.
3.  Put the package in a library and attach the lib to the report.

You can compile all reports by using RWCON60.exe - see reports on-line help.

I hope this will help you.



Author Comment

ID: 9864801
Hi Henka,

Thanks for your information. Previously we used the stored package and library concept to place in the RDF file. Due to complex calculations present in the stored package we moved them in database for performanance reasons. We downloaded the patch from metalink.oracle.com and installed. After updating the patch, while compling the reports itself the Report builder closed abnormally. We tested on more than one system. Even we are not able to compile the reports with the patch installed. Now we formated the system and installed the previous version.

As the two solutions failed we are planning to ask the clients to compile the reports. As the client is not a technical person and compiling 100 reports is tedios task to him. We tested using rwcon60.exe for compiling. It is not allowing selecting of multiple files at a time. we have to select single file each time. Another option of specifing comma separated list of file names with path, which is taking max of ten reports at a time. and all the remaning options we have to set each time (10  reports at a time X 10 times = 100 Reports)

Is there any other alternate to compile all the reports at command prompt so that we can build a batch file and give to the client, he just gives the folder name and path where the rdf files are placed with all the required options set in the batch file. It will help the client in compiling all reports in single click.

I have tested with different options all these days, to minimize the work for the client and not found the easy way. The client is a non-technical person and we does not have any control on the client location.

Please give me suggestion or any other possible ways to minimize the compilation at a time.
LVL 22

Accepted Solution

Helena Marková earned 400 total points
ID: 9864909
I think that Note:191529.1 from Metalink can help you:

This script code compiles all the Forms and Reports modules residing in a directory.

Execution Environment:
     Windows command prompt, UNIX shell

Access Privileges:
     Requires write privileges in the destination directory and read privileges in the source directory.

     When copying the script be aware to remove line feeds in the list of parameters for the executables.
     Please note that if you are FTPing this script from a Windows machine please do it in ASCII mode.

PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text editors, e-mail packages, and operatingsystems handle text formatting (spaces, tabs, and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.

For Windows

Forms/Reports 6i

Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp60 userid=scott/tiger@v817  module=%%f batch=yes
    module_type=form compile_all=yes window_state=minimize

Echo compiling Report .....
for %%f IN (*.rdf) do RWCON60 userid=scott/tiger@v817 batch=yes source=%%f
    stype=rdffile DTYPE=REPFILE  OVERWRITE=yes  logfile=log.txt


Forms/Reports 6i

#UNIX Forms Compile
for i in `ls *.fmb`
echo Compiling Form $i ....
f60genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
    compile_all=yes window_state=minimize
for i  in `ls  *.rdf`
echo Compiling Report $i  ...
rwcon60 userid=scott/tiger@bs817 batch=yes source=$i  stype=rdffile
    dtype=repfile overwrite=yes


Author Comment

ID: 9866165
Dear Henka,

Thanks for your help. It took me 2 hours for compiling all the files using Report Builder and 5 minutes using the script. Project is going live tomorrow. I am working from last 6 months on this and not found the ways. For testing from last 10 days we spent most of the time on compiling the reports.

Once again thanks for your quick and timely help. I doubled the points for you.

Krishna Reddy
LVL 22

Expert Comment

by:Helena Marková
ID: 9866247
Thank you.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question