7 Replies Latest reply on Nov 3, 2006 5:13 PM by Gustavo Bustos

    Error FRM:30312 when compiling webutil.pll

    Gustavo Bustos
      Error FRM:30312 when compiling webutil.pll

      I download the webutil_1_6.zip, and implementing the configuration instructions arrived to the point that states to compile the webtutil.pll file, the compiler generates the error: FRM-30312: Failed to compile the library. Any idea.

      The environment:
      OAS: 9.0.4
      OS: UNIX TRU 64 ver 1.5.b

      Considerations:
      I execute the create_webutil_db.sql in the required database.
      Other pll and fmb files of my application compile without problems.
      I configure the Webutil 1.6 in a Windows 2000 machine with Developer Suite 9.0.4 without problems.
        • 1. Re: Error FRM:30312 when compiling webutil.pll
          Michael Ferrante-Oracle
          Please provide more information:

          1. Complete Forms version (4 digits)
          2. Syntax used to compile.
          3. Can you successfully compile any pll?
          4. Are you attempting to compile from the local machine or a remote terminal?

          5. Is there any additional information associate with the error?
          • 2. Re: Error FRM:30312 when compiling webutil.pll
            Gustavo Bustos
            1. Complete Forms version (4 digits): 9.0.4.1
            2. Syntax used to compile:
            Line: f90genm.sh module=webutil.pll userid=comun/comun@chirripo module_type=LIBRARY batch=yes compile_all=yes window_state=minimize

            f90genm.sh code:
            # Set ORACLE_HOME if not set in the calling environment:
            ORACLE_HOME=${ORACLE_HOME:-/oracle10gr1/app/product/as10gr1}
            export ORACLE_HOME

            NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
            export NLS_LANG

            #
            # Search path for Forms applications (.fmb &.fmx files, PL/SQL libraries)
            # If you need to include more than one directory, they should be colon
            # separated (e.g. /private/dir1:/private/dir2)
            # Note: the current directory is always searched by default
            #
            # FORMS90_PATH=< your application directory 1>:<etc>
            # export FORMS90_PATH
            FORMS90_PATH=/datos4/sistemas/desa/sif/presupuesto/reportes/formulacion:/datos4/sistemas/desa/std/icons:/datos4/sistemas/desa/sif/librerias:/datos4/sistemas/desa/sif/formas:/datos4/sistemas/desa/sif/base:/datos4/sistemas/desa/sif/menu:/oracle10gr1/app/product/as10gr1/webutil
            export FORMS90_PATH

            #
            # You may need to set one or more of TNS_ADMIN, TWO_TASK or ORACLE_SID
            # to connect to database
            #
            TNS_ADMIN=$ORACLE_HOME/network/admin
            export TNS_ADMIN
            #TWO_TASK=<your database connect string>; export TWO_TASK
            #ORACLE_SID=< ORACLE SID >; export ORACLE_SID

            #
            # System settings
            # ---------------
            # You should not normally need to modify these settings.
            #
            if [ `uname -s` = 'HP-UX' ]; then
            SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/jdk/jre/lib/PA_RISC:$ORACLE_HOME/jdk/jre/lib/PA_RISC/server:$SHLIB_PATH
            export SHLIB_PATH
            elif [ `uname -s` = 'Linux' ]; then
            LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdk/jre/lib/i386/server:$ORACLE_HOME/jdk/jre/lib/i386/native_threads:$ORACLE_HOME/jdk/jre/lib/i386:$LD_LIBRARY_PATH
            export LD_LIBRARY_PATH
            elif [ `uname -s` = 'OSF1' ]; then
            LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdk/jre/lib/alpha:$ORACLE_HOME/jdk/jre/lib/alpha/fast:$ORACLE_HOME/jdk/jre/lib/alpha/native_threads:$LD_LIBRARY_PATH
            export LD_LIBRARY_PATH

            #Adding command uac p noprint to avoid unalligned messages
            /bin/uac p noprint

            #Set the following variable to use Motif 2.1 with JDK 142.
            JAVAAWT_USE_MOTIF_2_1=1; export JAVAAWT_USE_MOTIF_2_1
            else
            LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HOME/jdk/jre/lib/sparc/native_threads:$LD_LIBRARY_PATH
            export LD_LIBRARY_PATH
            fi

            $ORACLE_HOME/bin/f90genm $*

            4. Can you successfully compile any pll: By the time I have no trouble with other pll.
            5. Are you attempting to compile from the local machine or a remote terminal?:
            I compile via telnet
            6. Is there any additional information associate with the error?:
            Only the considerations I wrote in the last message:
            I execute the create_webutil_db.sql in the required database.
            Other pll and fmb files of my application compile without problems.
            I configure the Webutil 1.6 in a Windows 2000 machine with Developer Suite 9.0.4 without problems.

            Thanks.
            • 3. Re: Error FRM:30312 when compiling webutil.pll
              Michael Ferrante-Oracle
              You will not be able to compile via remote telnet session unless DISPLAY has been set and correctly points to an active and accessible X session. Additionally, we do not support doing this. It is recommended that when problems such as this arise, you attempt to compile from the local machine. See Metalink Doc ID 68047.1

              Also, after setting DISPLAY correctly, try removing unnecessary parameters from your command line. For example, do not use the WINDOW_STATE, or BATCH option.
              • 4. Re: Error FRM:30312 when compiling webutil.pll
                Gustavo Bustos
                Michael I follow your recommendations, make the compilation in the local machine, and change the command line, but the error still appear:

                I execute the following command line:
                f90genm.sh module=webutil.pll userid=comun/comun@chirripo
                module_type=library compile_all=yes

                It generate this:
                Forms 9.0 (Form Compiler) Version 9.0.4.1.0 (Production)

                Forms 9.0 (Form Compiler): Release - Production

                (c) Copyright 2001 Oracle Corporation. All rights reserved.

                Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
                With the Partitioning option
                JServer Release 9.0.1.4.0 - Production
                PL/SQL Version 9.0.1.5.0 (Production)
                Oracle Procedure Builder V9.0.3.5.0 Build #0 - Production
                Oracle Virtual Graphics System Version 9.0.1.11.0 (Production)
                Oracle Multimedia Version 9.0.4.1.0 (Production)
                Oracle Tools Integration Version 9.0.4.0.0 (Production)
                Oracle Tools Common Area Version 9.0.2.12.0
                Oracle CORE 9.0.1.2.0 Production
                Compiling library WEBUTIL...
                Invalidating Package Spec WEBUTIL_UTIL......
                Invalidating Package Spec WEBUTIL_SESSION......
                Invalidating Package Spec WEBUTIL_SEPARATEFRAME......
                Invalidating Package Spec WEBUTIL_HOST......
                Invalidating Package Spec WEBUTIL_FILE_TRANSFER......
                Invalidating Package Spec WEBUTIL_FILE......
                Invalidating Package Spec WEBUTIL_DB_LOCAL......
                Invalidating Package Spec WEBUTIL_C_API......
                Invalidating Package Spec WEBUTIL_CORE......
                Invalidating Package Spec WEBUTIL_CLIENTINFO......
                Invalidating Package Spec WEBUTIL_BROWSER......
                Invalidating Package Spec JAVA_SYSTEM......
                Invalidating Package Spec JAVA_FILE......
                Invalidating Package Spec JAVA_EXCEPTION......
                Invalidating Package Spec JAVA_APPSERV_WRITER......
                Invalidating Package Spec JAVA_APPSERV_READER......
                Invalidating Package Spec DELIMSTR......
                Invalidating Package Spec CLIENT_WIN_API_PRELOAD......
                Invalidating Package Spec CLIENT_WIN_API_ENVIRONMENT......
                Invalidating Package Spec CLIENT_WIN_API_DEBUG......
                Invalidating Package Spec CLIENT_WIN_API......
                Invalidating Package Spec CLIENT_TOOL_ENV......
                Invalidating Package Spec CLIENT_TEXT_IO......
                Invalidating Package Spec CLIENT_OLE2......
                Invalidating Package Spec CLIENT_IMAGE......
                Invalidating Package Body WEBUTIL_UTIL......
                Invalidating Package Body WEBUTIL_SESSION......
                Invalidating Package Body WEBUTIL_SEPARATEFRAME......
                Invalidating Package Body WEBUTIL_HOST......
                Invalidating Package Body WEBUTIL_FILE_TRANSFER......
                Invalidating Package Body WEBUTIL_FILE......
                Invalidating Package Body WEBUTIL_DB_LOCAL......
                Invalidating Package Body WEBUTIL_C_API......
                Invalidating Package Body WEBUTIL_CORE......
                Invalidating Package Body WEBUTIL_CLIENTINFO......
                Invalidating Package Body WEBUTIL_BROWSER......
                Invalidating Procedure Body SHOW_WEBUTIL_INFORMATION......
                Invalidating Package Body JAVA_SYSTEM......
                Invalidating Package Body JAVA_FILE......
                Invalidating Package Body JAVA_EXCEPTION......
                Invalidating Package Body JAVA_APPSERV_WRITER......
                Invalidating Package Body JAVA_APPSERV_READER......
                Invalidating Package Body DELIMSTR......
                Invalidating Package Body CLIENT_WIN_API_PRELOAD......
                Invalidating Package Body CLIENT_WIN_API_ENVIRONMENT......
                Invalidating Package Body CLIENT_WIN_API_DEBUG......
                Invalidating Package Body CLIENT_WIN_API......
                Invalidating Package Body CLIENT_TOOL_ENV......
                Invalidating Package Body CLIENT_TEXT_IO......
                Invalidating Package Body CLIENT_OLE2......
                Invalidating Package Body CLIENT_IMAGE......
                Invalidating Procedure Body CLIENT_HOST......
                Invalidating Function Body CLIENT_GET_FILE_NAME......
                Compiling Package Spec WEBUTIL_UTIL......
                Compiling Package Spec WEBUTIL_SESSION......
                Compiling Package Spec WEBUTIL_SEPARATEFRAME......
                Compiling Package Spec WEBUTIL_HOST......
                Compiling Package Spec WEBUTIL_FILE_TRANSFER......
                Compiling Package Spec WEBUTIL_FILE......
                Compiling Package Spec WEBUTIL_DB_LOCAL......
                Compiling Package Spec WEBUTIL_C_API......
                Compiling Package Spec WEBUTIL_CORE......
                Compiling Package Spec WEBUTIL_CLIENTINFO......
                Compiling Package Spec WEBUTIL_BROWSER......
                Compiling Package Spec JAVA_SYSTEM......
                Compiling Package Spec JAVA_FILE......
                Compiling Package Spec JAVA_EXCEPTION......
                Compiling Package Spec JAVA_APPSERV_WRITER......
                Compiling Package Spec JAVA_APPSERV_READER......
                Compiling Package Spec DELIMSTR......
                Compiling Package Spec CLIENT_WIN_API_PRELOAD......
                Compiling Package Spec CLIENT_WIN_API_ENVIRONMENT......
                Compiling Package Spec CLIENT_WIN_API_DEBUG......
                Compiling Package Spec CLIENT_WIN_API......
                Compiling Package Spec CLIENT_TOOL_ENV......
                Compiling Package Spec CLIENT_TEXT_IO......
                Compiling Package Spec CLIENT_OLE2......
                Compiling Package Spec CLIENT_IMAGE......
                Compiling Package Body WEBUTIL_UTIL......
                Compiling Package Body WEBUTIL_SESSION......
                Compiling Package Body WEBUTIL_SEPARATEFRAME......
                Compiling Package Body WEBUTIL_HOST......
                Compiling Package Body WEBUTIL_FILE_TRANSFER......
                Compiling Package Body WEBUTIL_FILE......
                Compiling Package Body WEBUTIL_DB_LOCAL......
                Compiling Package Body WEBUTIL_C_API......
                Compiling Package Body WEBUTIL_CORE......
                Compiling Package Body WEBUTIL_CLIENTINFO......
                Compiling Package Body WEBUTIL_BROWSER......
                Compiling Procedure Body SHOW_WEBUTIL_INFORMATION......
                Compiling Package Body JAVA_SYSTEM......
                Compiling Package Body JAVA_FILE......
                Compiling Package Body JAVA_EXCEPTION......
                Compiling Package Body JAVA_APPSERV_WRITER......
                Compiling Package Body JAVA_APPSERV_READER......
                Compiling Package Body DELIMSTR......
                Compiling Package Body CLIENT_WIN_API_PRELOAD......
                Compiling Package Body CLIENT_WIN_API_ENVIRONMENT......
                Compiling Package Body CLIENT_WIN_API_DEBUG......
                Compiling Package Body CLIENT_WIN_API......
                Compiling Package Body CLIENT_TOOL_ENV......
                Compiling Package Body CLIENT_TEXT_IO......
                Compiling Package Body CLIENT_OLE2......
                Compiling Package Body CLIENT_IMAGE......
                Compiling Procedure Body CLIENT_HOST......
                Compiling Function Body CLIENT_GET_FILE_NAME......
                FRM-30312: Failed to compile the library.


                Thanks.
                • 5. Re: Error FRM:30312 when compiling webutil.pll
                  Michael Ferrante-Oracle
                  Very strange....

                  Assuming that you have NOT modified the pll in any way, consider the following:

                  - Try increasing the space available for tmp and swap
                  - Be sure your system meets or exceeds the settings outlined in the iAS Installation Guide

                  http://download-east.oracle.com/docs/cd/B12428_15/quickinstall.904/quickinstalltr/toc.htm#1009916
                  • 6. Re: Error FRM:30312 when compiling webutil.pll
                    530135
                    I am not sure if this is applicable to you. but no harm in checking it out.

                    Did you checked for the pll previlege. DO you have read/write /modify OS level previlege.Is there any read only plx already present in the same directory.
                    • 7. Re: Error FRM:30312 when compiling webutil.pll
                      Gustavo Bustos
                      Really I don't know what happened, today in the morning I try again an it finally works, maybe it was because I connected to UNIX with an incorrect user the other times, but is really strange that I had connected several times with an incorrect user.

                      Well, thanks a lot, Michael.

                      Maybe you see me soon in the forum, cause I'm having a problem running a report, but I will try to solve the problem by myself before go back the forum.

                      Thanks.