This content has been marked as final. Show 4 replies
hi, are you opening up the .fmb with a later version of forms? if you are, it automatically tries to 'upgrade'.
are you sure that it does not actually open up? if you click Ok on error, you should see that the form is in fact opened.
The Form gets opened but I am unable to see code in any of the rtriggers or program units.
hi, from METALINK
FRM-10043 Cannot Open File [ID 32968.1]
Modified 11-DEC-2009 Type BULLETIN Status PUBLISHED
Oracle Forms - Version: 6.0.8 to 10.1.2
Information in this document applies to any platform.
Checked for relevance 2-DEC-2009
Troubleshooting FRM-10043 Cannot Open File
Scope and Application
Troubleshooting FRM-10043 Cannot Open File
General Error Description
FRM 10043 Cannot Open File
A.) Migration & Upgrade Problems
1.) Upgrading SQL*Menu 5.0 menus to Oracle Forms 4.5 menus and am receiving FRM-10043 "Cannot Open File" using f45gen.
Make sure Version to Upgrade = 50 is specified in addition to "Upgrade 3.0 Form, 5.0 Menu ..." when using f45gen.
2.) FRM-10043 Cannot Open File when upgrading Designer generated Files
The upgrade process does not correctly handle recursive procedures or stacked canvases with right justified fields residing in libraries. The procedure which was appearing twice was mutually recursive with a second procedure.This was not supported / allowed in Forms 3.0 but it worked and isn't supported and allowed in higher formsversions.
The solution was to strip out all the procedures from libraries, upgrade, and copy the procedures back over a block at a time, padding any right justified fields on stacked canvases.
3.) FRM-10043: Cannot open file when upgrading SQL*Forms 2.3 to Oracle Forms 4.5 using f45gen .
Make sure the 'Upgrade 3.0 Form, 5.0 Menu, or 4.0 Module to 4.5 Module?' Forms 4.5 Generator option is checked. This corresponds to the 'Upgrade' keyword used on the f45gen command line.
Use the following Oracle Forms 4.5 Generator Options to upgrade the 2.3 Form: FILE: < Name of Forms 2.3 .INP File > USERID: < Database User Name > PASSWORD: < Database Password for User Name > DATABASE: < Database Connect String > MODULE TYPE: FORM MODULE ACCESS: FILE UPGRADE 3.0 FORM: [X] CHECKED VERSION TO UPGRADE 23 From the command line, use: f45gen form23name.INP scott/tiger upgrade=yes version=23 module_type=form module_access=file
4.) FRM-10043: CANNOT OPEN FILE when upgrading a Sql*forms 3.0 to Forms 5.0 or 6.0
This feature is not supported in Oracle Forms 5.0 and 6.0. The Forms 5.0 online help says: ""Note: To upgrade a version 3.0 or 4.0 form, you must first convert the form to version 4.5, and then convert the version 4.5 form to version 5.0."
5.) FRM-10043 Cannot Open File when upgrading Menus within Forms 4.5 to Forms 5.0.
By setting the flag: Upgrade to PL/SQL from V1 to V2, it caused the upgrade to fail and get the 'FRM-10043 Cannot open file' error.
When you are upgrading from the command line or using Forms Compiler, you should have the menu name in all lower case, and if you do this, make sure you have the extension in the same case.
cl_info_menu.mmb NOT.... CL_INFO_MENU.mmb 6.) FRM-10043 Cannot open file ORA-00600: internal error code, arguments: , , [0x402F44C0], ORA-00600: internal error code, arguments: , , [0x402F44C0], ORA-21779: duration not active when compiling a menu
Usage of PLSQL deprecated feature in menu trigger or you are upgrading a 5.0 SQL*Menu menu module to Forms9i/10g created this error.
While compilling use UPGRADE_PLSQL=YES
f90genm.sh module=mymenu.mmb module_type=Menu userid=scott/tiger@cs upgrade_plsql=Yes
B.) Problems Opening Modules
1.) ORA-12203 TNS: unable to connect to destination and/or FRM-10043: Cannot open file and/or ORA-1005: null password given; logon denied by double clicking (opening) the file.
Windows File associations if created automatically by the OS do not enclose a command correctly in quotes. This means that any spaces that are included in your filename or path are interpreted by the OS when passed as parameters. Remove any spaces from the path or filename.
c:/Dependency Analysis/mylib.pll change to c:/DependencyAnalysis/mylib.pll
2.) FRM-10044 Cannot create file, FRM-10043 Cannot Open File on opening file in Forms Builder 6i or 9i if directory name contains Umlauts (vowels)
Don't use umlauts/vowels in the directory name
3.) FRM-10043 : Cannot open file in formbuilder an fmx,mmx,.. (You tried to open a file that is not a valid Oracle Forms design module file)
This error occurs when you attempt to open an Oracle Forms form, menu "executable file"
You must open the Binary ( Design ) format of the module. You can open the Form .FMB, Menu .MMB and Library .PLL binary files using the Oracle Forms Designer. If you have a text version of the module, you must first convert the text format back to binary format to open the module using the Oracle Forms Designer. The following shows the file extensions for each type of module and storage format.
Text: FMT,MMT, PLD
Designtime: FMB, PLL, MMB
Runtime: FMX, PLL or PLX, MMX
4.) FRM-10043 : Cannot open file in formbuilder if binary file may be corrupt
Solution Description 1
Transfer the .FMB, .MMB or .PLL file again in BINARY mode, and you will be able to open the file using the Oracle Forms Designer.
Solution Description 2
A module which has been worked on before, but suddenly cannot be opened in the Oracle Forms Designer may indicate that the file is corrupt.
1. Revert to a backup copy of the Oracle Forms file
2. Open the module from the database, if the module had been saved to the database. You can then use FILE->SAVE AS to save the form to the filesystem.
3. Convert from Binary format to Text Format, and then back to binary format.
A form can get corrupted due to a number of reasons, including: A series of changes made to the module in the Oracle Forms Designer could have corrupted the form as a result of some bug The file system might not have had enough disk space to save the module The module could have been transferred over a network, and corruption occurred
5.) FRM-10043 : Cannot open file in formbuilder for upgrade .pld files
Upgrading .PLD files is not supported. When upgrading PL/SQL libraries created in Developer/2000 release 1.X, you must convert all .PLD files to .PLL format before you attempt to open them in Developer/2000 Release 2.0.
6.) FRM-10101 : Cannot generate module or FRM-10043 : Cannot open file for modules saved in the database.
FRM-10101 occurs when you try to generate a module that is saved in the database and specify extract=yes, or select "Extract module from database into file?" in the Generate Options dialog window. FRM-10043 occurs when you try to generate a module that is saved in the database, but do not specify extract=yes.
The module name is case-sensitive. When modules are saved to the database, the module name is saved in uppercase.
You have saved a form with module name "mm" to the database.
Using Generate from the command line:
f45gen module=MM userid=scott/tiger extract=yes not f45gen module=mm userid=scott/tiger extract=yes
Using the "Generate Options" dialog window:
File: MM Userid: scott/tiger Module type is FORM,MENU or LIBRARY? Select FORM from poplist Module Access is FILE or DATABASE? Select DATABASE from poplist not File: mm Userid: scott/tiger Module type is FORM,MENU or LIBRARY? Select FORM from poplist Module Access is FILE or DATABASE? Select DATABASE from poplist
This error occurs when you attempt to open a form from the database. Access to the form was granted to the user by the form's creator through: FILE->GRANT->MODULE ( Oracle Forms 4.0.x ) or FILE->ADMINISTRATION->MODULE ACCESS ( Oracle Forms 4.5.x ) and the user name given was public.
Run the grant script to grant access to the Oracle Forms 4.x base tables. Grant access to either the user who is unable to open the form, or to PUBLIC. PUBLIC will allow all users access to the Oracle Forms 4.x base tables.
Forms 4.5.x (run the script frm45grt.sql as SYSTEM and Forms 4.0.x (run the script frm4grnt.sql as SYSTEM).
7.) FRM-10043 CANNOT OPEN FILE for modules attached libraries or subclassed objects from other modules
- Remove the hard coded path. (For libraries: reattache libraries without path, delete the non portable path). - Check if the library or the other modules are in FORMSNN_PATH. - Check if the env variable for FORMSNN_PATH contains more than 255/512 characters. If yes you can use ORACLE_PATH additional for searching files. (NN could be 40,45,50,60,90)
Bug:1317608 WEBFORMS FORMS60_PATH LONGER 512 BYTES DOESN'T RETRIEVE THE FMX
8.) FRM-10043 : Could not open ...olb
Form refers to OLB library with full path. Forms Builder stores full path of opened Object Library in preferences file and will ignore FORMS60_PATH
1. Open Developer preferences file file in any text editor. On Windows preferences file name is CAUPREFS.ORA and is located direcly in ORACLE_HOME folder. On Unix, preferences file is prefs.ora and is in unix user's home folder. 2. Find "Forms.obj_lib_file" entries and remove path info from library file names. 3. Next time Forms Builder starts, it will search for OLB files using FORMS60_PATH.
9.) FRM-10083 : Cannot find/open module for referenced objects. FRM-10043 : Cannot open file.
You receive this error trying to open a form in the Oracle Forms designer. The form you are trying to open has referenced objects. The Oracle Forms designer cannot find the source module in the filesystem that contains the definitions of the referenced objects.
Solution Description 1
FRM-10083/FRM-10043 occur because Oracle Forms cannot find the source module in the filesystem that contains the definitions of the referenced objects. If the source module is saved in the filesystem, Oracle Forms uses the following default search path to find the source .fmb file:
1. If the Full Pathname is specified, use that and no other. If you chose Keep Path when you created the referenced object, the complete directory path of the source module would be in the Reference Source Information in the target module. Thus, you must ensure that the source .fmb file can be found in that directory.
2. If Remove Path was chosen, no directory path is specified in the Reference Source Information in the target module. When Oracle Forms needs to locate the source module to read the definition of a referenced object, it looks for the module in the default search path. Oracle Forms will search for the source .fmb file in the following order: a. The Working/Current Directory ( In the icon property for the application on Microsoft Windows ). b. Sequentially in each of the directories named by the value of the environment variable FORMS45_PATH c. Sequentially in each of the directories named by the value of the environment variable ORACLE_PATH
When you create the referenced object, Oracle Forms informs you "It is recommended that the fully qualified path be removed."
Solution Description 2
If you have upgraded from a previous version of Oracle Forms, make sure the Reference source form has also been upgraded, before trying to open the referencing form.
All applications that are used as the source for references must be upgraded first, followed by upgrading any applications that make references to these source forms.
10.) ROS Error : -200 FRM-10043 : Cannot open file. FRM-11009 : Failed to load color palette.
Make sure that the directory path for the color palette file name is specified, and the file extension is .pal. Also make sure that this file still exists in the file system, and is readable. To check the color palette name and mode that the designer/builder is using: EDIT->PREFERENCES menu or TOOLS->OPTIONS menu The Color Palette field specifies the name of the Oracle Forms color palette that is automatically loaded when you create a new form. If there is any information typed in this field, Oracle Forms will interpret this as a .pal color palette file that must exist in the file system. If this field is blank, the Oracle Forms default color palette is loaded. Thus, if you are not using a custom color palette, this field should be blank.
The Oracle Forms designer/builder uses the color palette as specified in the designer preferences or options field to set the visual attributes for the form you are trying to open. If this color palette file is not found or cannot be read, then the ROS and FRM-10043 errors will occur when you try to open form.
11.) Using f60genm to regenerate a form, you get frm-10043: Cannot open file in the .err file and: X Error of failed request: BadPixmap (invalid Pixmap parameter) Major opcode of failed request:54 (invalid Pixmap parameter)
You are using AIX 4.3.1 or higher, and the libXt.a file from that OS version is not compatible with Oracle Forms 6.0.
Copy the library file libXt.a (generally in /usr/lpp/X11/lib/R5) from a pre-AIX 4.3.1 O/S (such as 4.3.0) to a directory that won't overwrite your current OS libXt.a file. The $ORACLE_HOME/lib directory is a good place. Set environment variable $LIBPATH to point to that directory. If the customer does not want to copy single file, have them install the following file set from their IBM vendor: X11.compat.lib.X11R5 18.104.22.168 COMMITTED AIXwindows X11R5 Compatibility Library, and set $LIBPATH to include /usr/lpp/X11/lib/R5 instead of the default OS motif libraries.
12.) FRM-10043 : Cannot open file on Apple
13) FRM-10043 : Cannot open file and Form not created If you try to compile a .pll in frmcmp.exe or frmcmp and use the default moduletype=FORM you receive the error.
You have to use Module Type = LIBRARY for .pll or MENU for .mmb or FORM for .fmb
hi and another from METALINK
Codebase: ROS ERROR: -200 FRM-10044: Cannot create file. [ID 562247.1]
Modified 09-APR-2008 Type HOWTO Status PUBLISHED
In this Document
Oracle Configuration Controls Governor
Codebase: ROS ERROR: -200 FRM-10044: Cannot create file.
If you receive the following error when generating a file in Automated Generation:
ROS ERROR: -200 FRM-10044: Cannot create file.
and the file is not generated, generate the file manually:
-uncheck the ?Compile ALL PL/SQL? box on the Automated Generation configuration screen
Doc #17639 March 9, 2001
RDBMS ? 7.3.4, 8i
CMS version 3.3 and 3.4