Solved

Forms Compilation Errors

Posted on 2004-09-22
6
5,287 Views
Last Modified: 2007-12-19
Hello,

I have checked in my datatabase to confirm that the tables not compiling do exist in my database. For example the table ASDETAIL and TAXENTITY do exists in my database but at compile time generate warning and error messages.

I was told that I did an import as the system/manager from user ALCIE to user ALCIE and I checked that user ALCIE does exists in the database.

When I try to connect as the alcie user as:

connect alcie/alcie@oracleln or
connect alcie/alcie

I get a message that I am not connected and I get a message like:
SP2-0460.

I also tried to give the alcie user create session priviledges such as:

grant create session to alcie

but I get an error message, indicating that I am not connected. I also tried to create a SYNONYM on those tables giving me compile errors:

create public synonym alcie_syn on ardetail

I also get error message indicating I am not connected.
I get the feelling that I am turning in circles.
=====
Also, from what you tell me, I should maybe try to compile le *.OBJ files before compiling the *.FRM and *.RDF files.
1) Would the order of compilation make any difference ?
2) Where can i find the *.OBJ files your are refering to?
(I did not find them in the source directory)

THe applicaiton was recompiled under Oracle 9i iDS under WIndows XP Pro and is now being deployed under Linux Red Hat Enterprise 3 (ES).

YOur toughts ?

PT

0
Comment
Question by:ptreves
  • 4
  • 2
6 Comments
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 500 total points
Comment Utility
First in SQL*Plus, if you are not connected, you will not be able to: create synonyms; issue grants; or do anything else.  You have to find out why you are not able to connect.

Forms compilation errors may (or may not be) caused by the same problem.  Is your Forms Designer session connected to the database?  

The problem may be your SQL*Net configuration, and this may need to be configured in two different Oracle_homes, depending on whether SQL*Plus and Oracle Forms are in the same Oracle_home or not.  Often they are in separate Oracle_homes, and fixing the SQL*Net configuration in one will not fix the other.

Are you using a Linux client for SQL*Plus and when you try to compile the forms?  Is this directly on the Linux server, or on a separate client machine?
0
 

Author Comment

by:ptreves
Comment Utility
Hello,

I installed Oracle 9i Database in one ORACLE_HOME and then Oracle Forms/Reports Services 10g in a seperate ORACLE_HOME. Both are on my Linux Red Hat Enterprise 3 (ES) server.

I originally compiled the forms/reports on a Client Windows XP Pro machine where I had installed Oracle 9i iDS.
I recompiled the forms/reports under Linux using the f90genm.sh and the rwconverter.sh GUI utilities.

I encountered PB with the forms compilation, saying that some IDENTIFIERS and such were missing. By creating SYNONYMs of the missing TABLES, I was able to compile my forms, at least the majority of them.

I am still not able to connect when logging in as the ALCIE user. I can only connect as the SYSTEM user. I connected as

connect alcie/alcie as sysdba

(that worked).

======

Your toughts ?

PT
0
 

Author Comment

by:ptreves
Comment Utility
Hello,

After recompilation of my Forms/Reports, here is a list of issues still outstanding:
-----
FRM-30064: Unable to parse statement select am.customer, am.name1, am.phone from armaster am where 0 < (select sum(nvl(balance,0)) from arsumbal as2 where as2.customer = am.customer) order by name1.
ORA-00942: table or view does not exist
Record Group REC_CUST_GROUP
Form: ACC_REC
 
FRM-30085: Unable to adjust form for output.
 
 
Form not created
========
========Tbdoctrk / Tbemp
FRM-18108: Failed to load the following objects.
 
Source Module:TOOLBAR
  Source Object: ICONES
Source Module:TOOLBAR
  Source Object: H_TOOLBAR
Source Module:TOOLBAR
  Source Object: CLA_TITREBUTTON
Source Module:TOOLBAR
  Source Object: CLA_EDITABLE
Source Module:TOOLBAR
  Source Object: CLA_TEXTEDIT
Source Module:TOOLBAR
  Source Object: CLA_TEXTOBLIG
Source Module:TOOLBAR
  Source Object: CLA_TEXTDATE
Source Module:TOOLBAR
  Source Object: CLA_TEXTDATETIME
Source Module:TOOLBAR
  Source Object: CLA_TEXTMONTANT
Source Module:TOOLBAR
  Source Object: CLA_TEXTLOV
Source Module:TOOLBAR
  Source Object: CLA_TEXTPRIX
Source Module:TOOLBAR
  Source Object: CLA_TEXTNOMBRE
Source Module:TOOLBAR
  Source Object: CLA_TEXTTITRE
Source Module:TOOLBAR
  Source Object: CLA_MULTILINE
Source Module:TOOLBAR
  Source Object: CLA_DISPLAY
Source Module:TOOLBAR
  Source Object: CLA_DISPLAYDATE
Source Module:TOOLBAR
  Source Object: CLA_DISPLAYDATETIME
Source Module:TOOLBAR
  Source Object: CLA_DISPLAYMONTANT
Source Module:TOOLBAR
  Source Object: CLA_DISPLAYNOMBRE
Source Module:TOOLBAR
  Source Object: CLA_STATIC
Source Module:TOOLBAR
  Source Object: CLA_STATICTITRE
Source Module:TOOLBAR
  Source Object: CLA_STATICDROITE
Source Module:TOOLBAR
  Source Object: CLA_BOUTON
Source Module:TOOLBAR
  Source Object: CLA_LOVBUTTON
Source Module:TOOLBAR
  Source Object: CLA_FILTREBUTTON
Source Module:TOOLBAR
  Source Object: CLA_COMMANDBUTTON
Source Module:TOOLBAR
  Source Object: CLA_OKBUTTON
Source Module:TOOLBAR
  Source Object: CLA_CANCELBUTTON
Source Module:TOOLBAR
  Source Object: CLA_TOOLBUTTON
Source Module:TOOLBAR
  Source Object: CLA_BOUTONRADIO
Source Module:TOOLBAR
  Source Object: CLA_LISTE
Source Module:TOOLBAR
  Source Object: CLA_CHECKBOX
Source Module:TOOLBAR
  Source Object: CLA_SCROLLBAR
Source Module:TOOLBAR
  Source Object: CLA_VSCROLLBAR
Source Module:TOOLBAR
  Source Object: CLA_HSCROLLBAR
Source Module:TOOLBAR
  Source Object: CLA_FORM
Source Module:TOOLBAR
  Source Object: CLA_CANVAS
Source Module:TOOLBAR
  Source Object: CLA_BLOCK
Source Module:TOOLBAR
  Source Object: CLA_BDBLOCK
Source Module:TOOLBAR
  Source Object: CLA_RECORDSBLOCK
Source Module:TOOLBAR
  Source Object: CLA_MENU
Source Module:TOOLBAR
  Source Object: CLA_WINDOW
Source Module:TOOLBAR
  Source Object: CLA_MAINWINDOW
Source Module:TOOLBAR
  Source Object: CLA_DIALOGWINDOW
Source Module:TOOLBAR
  Source Object: CLA_DOCUMENTWINDOW
Source Module:TOOLBAR
  Source Object: CLA_LOVWINDOW
Source Module:TOOLBAR
  Source Object: CLA_EDITORWINDOW
Source Module:TOOLBAR
  Source Object: CLA_ALERTWINDOW
Source Module:TOOLBAR
  Source Object: CLA_INFOALERT
Source Module:TOOLBAR
  Source Object: CLA_ERRORALERT
Source Module:TOOLBAR
  Source Object: CLA_WARNINGALERT2
Source Module:TOOLBAR
  Source Object: CLA_WARNINGALERT3
Source Module:TOOLBAR
  Source Object: CLA_BUTTON
Source Module:TOOLBAR
  Source Object: VAT_POLICEDEFAUT
Source Module:TOOLBAR
  Source Object: VAT_POLICECOURANT
Source Module:TOOLBAR
  Source Object: VAT_POLICETITRE
Source Module:TOOLBAR
  Source Object: VAT_POLICESTATIC
Source Module:TOOLBAR
  Source Object: VAT_POLICEDISPLAY
Source Module:TOOLBAR
  Source Object: VAT_POLICELOV
Source Module:TOOLBAR
  Source Object: VAT_POLICEOBLIG
Source Module:TOOLBAR
  Source Object: VAT_POLICETEXT
Source Module:TOOLBAR
  Source Object: VAT_POLICECOMPANY
....
....
FRM-30436: Parent window not specified for canvas.View Canvas H_TOOLBAR
FRM-30041: Position of item places it off of canvas.
Item: BUTTON_HELP
Block: VARIABLE
Form: TBDOCTRK
 
FRM-30085: Unable to adjust form for output.
 
=======
FRM-30436: Parent window not specified for canvas.View Canvas H_TOOLBAR
FRM-30041: Position of item places it off of canvas.
Item: BUTTON_RENOV_EMP_CODE
Block: VARIABLE
Form: TBEMP
 
FRM-30085: Unable to adjust form for output

======
======Tbprjclt
Compiling WHEN-VALIDATE-ITEM trigger on CUSTOMER item in CLIENT_INFO data block...
Compilation error on WHEN-VALIDATE-ITEM trigger on CUSTOMER item in CLIENT_INFO data block:
PL/SQL ERROR 201 at line 3, column 24
identifier 'SEQ_CUST.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 3, column 17
SQL Statement ignored

=====
=====Tbprjcp
Compiling KEY-NEXT-ITEM trigger on CUSTOMER item in CLIENT_INFO data block...
Compilation error on KEY-NEXT-ITEM trigger on CUSTOMER item in CLIENT_INFO data block:
PL/SQL ERROR 201 at line 2, column 24
identifier 'SEQ_CUST.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 2, column 17
SQL Statement ignored
 
Compiling KEY-LISTVAL trigger on CUSTOMER item in CLIENT_INFO data block...
   No compilation errors.
 
Compiling WHEN-VALIDATE-ITEM trigger on CUSTOMER item in CLIENT_INFO data block...
Compilation error on WHEN-VALIDATE-ITEM trigger on CUSTOMER item in CLIENT_INFO data block:
PL/SQL ERROR 201 at line 3, column 24
identifier 'SEQ_CUST.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 3, column 17
SQL Statement ignored
 
=====
=====
Compiling PRE-INSERT trigger on FIELD_LOG data block...
Compilation error on PRE-INSERT trigger on FIELD_LOG data block:
PL/SQL ERROR 201 at line 4, column 9
identifier 'TBFIELD_SEQ.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 4, column 2
SQL Statement ignored

=====
=====cltinv
Compilation error on function CHECK_ID:
PL/SQL ERROR 201 at line 2, column 35
identifier 'TED.SECURITY2' must be declared
PL/SQL ERROR 0 at line 2, column 14
SQL Statement ignored
 
=====
=====
 FRM-30436: Parent window not specified for canvas.View Canvas H_TOOLBAR
FRM-30041: Position of item places it off of canvas.
Item: CO
Block: VARIABLE
Form: TBCADAST
 
FRM-30085: Unable to adjust form for output.
 
=====
=====
FRM-30436: Parent window not specified for canvas.View Canvas H_TOOLBAR
FRM-30041: Position of item places it off of canvas.
Item: CO
Block: VARIABLE
Form: TBSHPVIA
 
FRM-30085: Unable to adjust form for output.
 
======
======
FRM-30436: Parent window not specified for canvas.View Canvas H_TOOLBAR
FRM-30041: Position of item places it off of canvas.
Item: CO
Block: VARIABLE
Form: TBSURVEY
 
FRM-30085: Unable to adjust form for output.
 
=====
=====TOOLBAR3.FMB
Compiling SYSDATE trigger on form...
Compilation error on SYSDATE trigger on form:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'icones.sysdate'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'icones.sysdate'
 
Compiling WHEN-MOUSE-ENTER trigger on ICONES data block...
   No compilation errors.
 
Compiling WHEN-MOUSE-LEAVE trigger on ICONES data block...
Compilation error on WHEN-MOUSE-LEAVE trigger on ICONES data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
 
Compiling WHEN-MOUSE-ENTER trigger on MOVEFIRST item in ICONES data block...
Compilation error on WHEN-MOUSE-ENTER trigger on MOVEFIRST item in ICONES data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
 
Compiling WHEN-BUTTON-PRESSED trigger on MOVEFIRST item in ICONES data block...
   No compilation errors.
 
Compiling WHEN-MOUSE-ENTER trigger on DOWN item in ICONES data block...
Compilation error on WHEN-MOUSE-ENTER trigger on DOWN item in ICONES data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
 
Compiling WHEN-BUTTON-PRESSED trigger on DOWN item in ICONES data block...
   No compilation errors.
 
Compiling WHEN-MOUSE-ENTER trigger on UP item in ICONES data block...
Compilation error on WHEN-MOUSE-ENTER trigger on UP item in ICONES data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
 
Compiling WHEN-BUTTON-PRESSED trigger on UP item in ICONES data block...
   No compilation errors.
 
Compiling WHEN-MOUSE-ENTER trigger on MOVELAST item in ICONES data block...
Compilation error on WHEN-MOUSE-ENTER trigger on MOVELAST item in ICONES data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'TOOLBAR.BUTTONHELP'
 
=======
=======
=======

It appears that I have some issues with the compilation of the toolbars in my application.
This does not depend on the Oracle database ?

1) What can I do about these errors ?

Your toughts ....

PT


0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 34

Expert Comment

by:Mark Geerlings
Comment Utility
If you can connect as SYSTEM, but not as ALCIE, then your SQL*Net configuration is OK, but either the ALCIE account has not been created, or it does not have "create session" privilege, or the password is not what you expect it to be.  Which tool did you use to connect as SYSTEM, SQL*PLus or Oracle Forms?

I understand that you have two Oracle_homes, but which one is SQL*Plus in?  I would guess that it is in the same Oracle_home as the database software, but it could be in either or both.  It is possible that SQL*Net is configured correctly in the Oracle_home that the database is in, but not in the one for Forms and Reports.  If so, that would prevent Forms and Reports from connecting.

The missing Forms objects lead me to believe that some Forms objects that were part of this application on Windows have not been copied to the Linux box, or have not been put into the correct directory, or the FORMSxx_PATH environment variable is not set correctly, so the Forms compiler does not see/find these objects.

The missing database objects (tables, sequences, etc.) lead me to believe that either the objects are not in the database, or they are but are in a different schema than you log in as, and the schema you log in with does not have the security to use/see these objects.
0
 

Author Comment

by:ptreves
Comment Utility
Hello,

You are right.
As far as I know I can connect to my Oracle 9i Database from Forms/reports services 10g. That is not realy an issue now.

I use SQL*PLUS from Oracle 9i database at $ORACLE_HOME/bin.
Looking at the Forms compiler utility f90genm.sh, it does not give me any opetions to set envrionement variables such as FORM90_PATH.

1) Where do I specify that path ?

Going back to my Oracle 9i iDS, looking at the individual forms, I do not see any links to external libraries or objects so I don't understand why it is returning those kind of error messages.

2) What should I be looking for to include in my forms to make the compilation successfull ?

I have individual forms called TOOBAR.fmb and TOOLBAR2.fmb but as fas as I know they are not used or called any where.  In my forms I do find TOOLBAR and ICON objects defined, but they seem to be part of the form not a seperate entity.

Please advice ...

What should I be looking for to resolve this issue ?

PT
0
 

Author Comment

by:ptreves
Comment Utility
Hello again,

If the sequence seems to exists for the ALCIE user,

1) why I could not do this : desc alcie.tbfield_seq;      ????
SP2-0381: Describe sequence is not available

What is this strange error message ?

Your toughts ?..

PT
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now