This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Apr 9, 2013 7:34 AM by CraigB RSS

forms not working after upgrade to 11g

AbdurRahman Newbie
Currently Being Moderated
hello all,

when i did an upgrade from forms 10g R2 to forms 11g, the first page was able to come up easily but i could not navigate from the front page to any other page on my application. no error was dispalyed.
Please what do you think the issue could be?

AbdurRahman
  • 1. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    Have you checked the Java Console to see if there is an error listed there? Java errors do not typically display through your Forms application. Also, have you checked the WLS Logs to see what errors are listed there?

    Craig...
  • 2. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    Hi Craig Thanks for the response, there is no log in the WLS logs. if i may ask how can i locate the java logs please. i am new to forms upgrade.
    thanks
  • 3. Re: forms not working after upgrade to 11g
    Paul M. Oracle ACE
    Currently Being Moderated
    i did an upgrade from forms 10g R2 to forms 11g
    Did you recompile forms ? We recently did the same, and had no problems, just recompiling.
  • 4. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    yes i do.
  • 5. Re: forms not working after upgrade to 11g
    Christian Erlinger Guru
    Currently Being Moderated
    The WLS logs are somewhat useless when searching for forms errors, as most certainly there is an exception thrown in the java applet which does not concern WLS at al, or there is something wrong within your forms which again WLS doesn't care about. There might be a small possibility that the forms servlets are throwing up on something which should be logged in the WLS logs, but this is rarely the case.

    If there is nothing logged in the java console on the client you might have a problem in your PL/SQL code. You can reveal problems by debugging, or if you like tracing your forms module:

    http://docs.oracle.com/cd/E16340_01/web.1111/e10240/tracing.htm

    hint: in 11.1.2.0 32bit windows the forms runtime crashed when enabling tracing in full (event 0-199) after hogging up the CPU for some minutes, this might be different in your version. If it isn't just trace all the defined events and omit all the ones which are reserved for future use (4-31 for example are not used).

    cheers
  • 6. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    thanks all,
    i tried recompiling the forms all over again and i got this error message

    frmcmp: error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory .
    I have check the internet for this error but i could not recieve any valuable answer for it.
    kindly help out.
    thanks.
  • 7. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    if i may ask how can i locate the java logs please.
    To enable the Java Console, go to the Window Control Panel and run the Java control panel applet. Then click on the "Advanced" tab and open the Java Console node. Now click the "Show Console" radio button and click OK. The next time you run your Forms Application - the Java Console will be displayed.
    frmcmp: error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory .
    This error indicates your UNIX session is not configured correctly to find all of the dependent libraries. At a minimum, your compile script should set the following environment variables:
    LD_LIBRARY_PATH - points to source libraries (like the .so files)
    ORACLE_HOME - directory of your Fusion Middleware 11g (FMw) installation
    DISPLAY - must point to an active X Windows sessions
    TNS_ADMIN - points to your tnsnames.ora

    It is also helpful to define a FORMS_PATH variable so the Forms Compiler can find any attached PL/SQL Libriaries (.pll) or Menu (.mmb), etc., files used in your forms.

    Craig...
  • 8. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    Thanks Craig,
    All the mentioned variables are been set correctly as you said. how can i rectify my unix session that is not configured properly,please what am i suppose to do at this stage.
    AbdurRahman
  • 9. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    All the mentioned variables are been set correctly as you said.
    If the environment variables are set and they point to valid directories, then you may not have privileges read and execute privileges on these directories and their files.
    how can i rectify my unix session that is not configured properly,please what am i suppose to do at this stage.
    I suggest working with your UNIX Administrator to ensure you have the necessary privileges to run the Oracle Forms Compiler.

    Craig...
  • 10. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    Dear Craig,

    i have been able to compile the forms,menu and library files but the issue still persist.

    Please i need help from you guys out there.

    AbdurRahman Ajani
  • 11. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    Dear Craig,

    i have been able to compile the forms,menu and library files but the issue still persist.

    Please i need help from you guys out there.

    AbdurRahman
  • 12. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    i did check the log file of my compilation and i found this message

    Compiling library CENTERWINDOW...
    Invalidating Procedure Body SHOWWINDOW......
    Invalidating Procedure Body CENTERWINDOW......
    Compiling Procedure Body SHOWWINDOW......
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 103 at line 9, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.
    ERROR 49 at line 10, column 20
    bad bind variable ''
    ERROR 103 at line 10, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.
    ERROR 0 at line 0, column 0
    Automatic recompile of Procedure Body CENTERWINDOW failed
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 103 at line 9, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.
    ERROR 49 at line 10, column 20
    bad bind variable ''
    ERROR 103 at line 10, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.
    ERROR 0 at line 0, column 0
    Automatic recompile of Procedure Body CENTERWINDOW failed
    ERROR 0 at line 3, column 3
    Statement ignored
    Compiling Procedure Body CENTERWINDOW......
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 103 at line 9, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.
    ERROR 49 at line 10, column 20
    bad bind variable ''
    ERROR 103 at line 10, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.
    Closing library CENTERWINDOW...
    Compilation errors on SHOWWINDOW:
    PL/SQL ERROR 0 at line 3, column 3
    Statement ignored


    Compilation errors on CENTERWINDOW:
    PL/SQL ERROR 49 at line 9, column 20
    bad bind variable ''
    PL/SQL ERROR 49 at line 9, column 20
    bad bind variable ''
    PL/SQL ERROR 103 at line 9, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.

    PL/SQL ERROR 49 at line 10, column 20
    bad bind variable ''
    PL/SQL ERROR 103 at line 10, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:

    . ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec as between from using || indicator multiset
    member submultiset
    The symbol "." was substituted for "GLOBAL" to continue.


    Failed to generate library.

    FRM-30312: Failed to compile the library.


    kindly assist please
    AbdurRahman
  • 13. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    Compiling Procedure Body SHOWWINDOW......
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 49 at line 9, column 20
    bad bind variable ''
    ERROR 103 at line 9, column 21
    Encountered the symbol "GLOBAL" when expecting one of the following:
    ...
    Well, this tells me that you have an error in your library code or your library references a second library and the Forms Compiler can't find all the dependent objects. What happens when you open the PL/SQL Library file in the Forms Builder and you compile?

    If this error only occurs when compiling on the application server - then I still maintain that you have a Configuration/PATH issue and the Forms Compiler is not finding dependent objects when opening your PL/SQL Library file to compile it.

    Have you confirmed your Application Server compile script is setting all of the necessary variables (ORACLE_HOME, FORMS_PATH, etc)?

    You really need to get your System Administrator involved if you have not already done so.

    Craig...
  • 14. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    I got the same error message when i tried to compile the library file in plsql editor. It points to variable :GLOBAL as a bad bind variable.

    Please i have another question to ask if i am allowed.

    after running my forms in  fusion middleware 11g, i cannot logon to the application from the logon screen but when i clicked the cancel button the screen disappear.

    what do you think could be the issue.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points