Forms :: Assertion Failed Error On Oracle Forms 10g?
May 4, 2011
I have several forms developed in Oracle forms builder 10g version 9.0.4.0.19. It contains Hierarchical Tree items. when i run this form on this version of oracle, it's running properly. but when i compile and run it on oracle forms 10 version 10.1.2.0.2, it shows an error message stating Assertion Failed!, if I click on the Tree item. I cant find out what and where the problem is. If I build a new form with tree item, it is working properly.
I have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.
(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)
Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.
I am getting error while installing Oracle 11g on windows xp. Ora --12638: Credential Retrieval failed error. I understand that some people have got that error after the installation( Changing SQL.Net file).
i tried to run the report via oracle froms 10g in BUTTON CLICK. But i got the error like "FRM-41219 : CANNONT FIND REPORT:INVALID ID". I did the Following code.
I am using windows Xp environment. Downloaded the software from Oracle website. Database is Oracle Express on windows. Have installed Oracle Forms 10.1.2.0.2 and OC4J also on windows xp Installation is fine and i am able to run forms same day. THe next day i am not able to run Oracle forms, i get error frm-92101 error.
I have tried posting this in various oracle forums and have not got a solution yet. I tried reinstalling. Every time i reinstall, it works for a day (the day i install, i have been able to create forms, compile and run them) but it does not work the next day. THis has happened thrice (reinstalled thrice).
Oracle JInitiator: Version 1.3.1.22 Using JRE version 1.3.1.22-internal Java HotSpot(TM) Client VM User home directory = C:Documents and SettingsuserProxy Configuration: no proxyJAR cache enabled Location: C:Documents and SettingsuserOracle Jar Cache Maximum size: 50 MB
I am getting following error when we submit request through button in forms.but backend it is created.
ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XXPL_PO_REQ_INTER_MAIN' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
We have recently migrated from IAS 9.0 to IAS 10.1.2 in one of our development Server hosted in UNIX B.11.11. We are using Oracle forms as front end. We have re-compiled all the existing forms and libraries using IAS 10. There were no changes in the forms and libraries. We deployed the forms in our development box and configured it, since we are using our own environment specific copy of default.env file. With few of forms we are facing the FRM-92100 error mentioning the "Connection to Server was interrupted". Most of the forms are running fine but with few forms we are facing this error. Some of details are:-
Oracle 10.1.0.4 UNIX B.11.11 IAS 10.1.2
NLS_LANG parameter in default.env is set to "american_america.WE8ISO8859P1"..We have even tried copying the libraries in our local system and then opening and saving them and ftp'ng them back in to UNIX server and then recompiling there with full permissions but still unable to resolve this error.
When i trying to install oracle Forms on Windows XP i am getting following error message . When i click on Setup , Dos windows Opens with following error message .
Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 5.1 Passed Checking monitor: must be configured to display at least 256 colors . Actual 4294967296 Passed Checking swap space: 0 MB available, 1535 MB required. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before continuing with the installation, at which time they will be rechecked.
I have a client who is facing the above error. Everything used to work perfectly but since a week, he gets this error message on a specific FORM. No updates have been made to the FORM.
The FMXs are stored on the database server(10G R3, Windows 2003 R2) and the Client terminals access them through a network drive.When executing the conflicting FORM on the server, no error.
I call the DBMS_ERROR_CODE routine from a FORM-LEVEL ON-ERROR trigger :
DECLARE ERR NUMBER; BEGIN IF DBMS_ERROR_CODE=-1 THEN MSG('Client existant',ERR,'E'); ELSE
[code]....
Code for procedure MSG :
PROCEDURE MSG(TXT_MSG IN VARCHAR2 , RET_REP OUT NUMBER , TYPE_MSG IN CHAR DEFAULT 'I' , LABEL_BUT1 IN VARCHAR2 DEFAULT 'OK' , LABEL_BUT2 IN VARCHAR2 DEFAULT NULL , LABEL_BUT3 IN VARCHAR2 DEFAULT NULL) IS VL_ALERT ALERT; BEGIN
While installing Dev Suite 10g i got the following error:[URL] What should i do? I specified another oracle home name, i have oracle database 11g installed too, and i'm installing dev suite 10g on another location.
SQL > conn ashish/pass@conn_string ERROR: ORA-28002: the password will expire within 1 days ---------------------------------------------------------- I want to catch this eror in forms: catch the error code ORA-28002 in ON-ERROR trigger and ON-Message trigger, however its not getting caught in the trigger. how to catch the warning/error ORA-28002 in oracle forms?
When I try to install "Oracle Developer Suite 10g 10.1.2.0.2" on Windows 7, I'm getting error , " Install has encountered an error while attempting to verify your virtual memory settings. verify that the sum of the initial sizes of the paging files is atleast 256 MB."
Error - FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes.
When I try to open Oracle form builder I am receiving 'FRM-18103:Failed to initialize the Development Environment' error.
1.display_item (primary key) 2-list_item (foreign key) / / dynamic list :this is the cause of the error 3-lis_item (foreign key) / / dynamic list 4-text_item 5-button (insert commit)
when I click the button, an error is displayed:
FRM-40508: ORACLE error: unable to INSERT record.in detail: ora-02291 integrity constraint Violated - parent key not found
Note:
-the elements of two lists already exist in the parent table!!
We have recently shifted our database from 10G to 11G and after the intial hickups most of the thinghs have stablised. We had changed system by Alter System command so that database does not have case sensevity problem and with that all the reports from the forams have also stabilied However some of the forms are failing with the above error ORACLE ERROR Unable to read list of values
These form are running fine with users having DBA privelege. However other users this is failing.
We have also checked that with users not having DBA privelege we are able to read the data in the table within the form also. The query in the record group is very simple
"SELECT CODE,SHORTDESC FROM GENCODES WHERE CODETYPE='BS' AND CODE <> '00'"
All these forms were fine previously when database was on 10g.
Moreover there are many other fields where list of values are there and allthose are ruing fine.
I have also checked datatype and length in query as well as fields on the form
I am trying to setup oracle look and feel project on my local machine. For that i upgraded forms to 10.1.2.3 then i also applied path no 9593176 (But not yet performed steps related to jacob and webutil).
Problem : When i run Oracle look and feel template form it comes up with following error.
Forms Applet version is : 10.1.2.3 Exception in thread "thread applet-oracle.forms.engine.Main-1" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet; at oracle.forms.fd.DrawLAF.init(DrawLAF.java:285) at oracle.forms.handler.UICommon.instantiate(Unknown Source) at oracle.forms.handler.UICommon.onCreate(Unknown Source) at oracle.forms.handler.JavaContainer.onCreate(Unknown Source) [code]..........
I have the search screen in my form so after searching if i select the row by using the button it will navigate the first tab page that is "gas" screen here if i tried to change the value like update and save the form it is not allowing me to update the value raising the error message "oracle unable to insert the record". if i see the "display error" in menu it is having the select statement with error "unique key violation error ora-00001".
i have a form based on tab canvas. for some values(on form) i am hiding some fileds or a complete frame on the form using stack canvas. it works fine but if a user enters a wrong value in some field i.e enters character in number field the stack canvas hides(showing the hidden fields).
I tried to use on error trigger at form level and when validate item trigger to show the canvas but it first hides the canvas once right value is entered it just shows canvas again. following is the code i wrote
IF MESSAGE_TYPE = 'FRM' AND MESSAGE_CODE IN ('40209','50016') AND :SYSTEM.TRIGGER_ITEM IN (some field) THEN IF other_item_value = 'E' THEN SHOW_VIEW('STK_CAN_ARL_INFO'); END IF;
I need not to hide the canvas in any case whether any other field on the form is validated or not.
Running a Dell x86_64 machine using CentOS 6.4 Install using the command: rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpmOracle XE installs without any errors.
However: When during database configuration we get the Database Configuration failed error The logs all show similar errors, here's a snippet: Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 BEGIN dbms_backup_restore.zerodbid(0); END; *ERROR at line
1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=1q6xlf1.bcohome.bco.com)(PORT=1521))'Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 alter system enable restricted session*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 alter database "XE" open resetlogs*ERROR at line 1:ORA-01034: ORACLE not available
I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column COL2 -->list value of database column COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
