We have upgraded our environment to Apex 4.2.1. We have an older application that makes use of Apex Lib. We cannot remove Apex Lib from the application without a lot of work.
Apex Lib is now throwing an error:
in package apexlib_error procedure addApexValidationErrors WWV_Flow.g_validation_ids_in_error does not exist.
I have a page process that calls back end PL/SQL. I have a page item that is populated by said PL/SQL procedure, P35_PROCESSING_MSG. As you know the Process allows me to specify a message for Success and another for Failure. My desire is that, if there is a back end failure, the error will display in the dialog area, using the built-in "Process Error Message" functionality. Instead, after execution, the page item still has its default value and the following, ugly, error displays in the tabular report region.
report error:
ORA-20001: Error fetching column value: ORA-01403: no data found
ORA-06510: PL/SQL: unhandled user-defined exception
I just don't get why it displays here instead of in the usual failure area. Moreover, I don't understand why the error is "*+unhandled+* user-defined exception" when, as you will see, I have handled it.
I have a page process to perform custom MRD for a tabular form. (I don't think this is really germane to the more generic issue but, I bring it up as an explanation for the following code sample). I am deliberately causing a DIVIDE BY ZERO error to test the error handling form the back end.
PROCEDURE PROCESS_MARGIN_CALL_DELETES( as_StatusMsg OUT VARCHAR2 )
IS
lb_InnerErrorOccured BOOLEAN := FALSE;
ln_DeleteTargetCnt NUMBER := 0;
ln_DeleteTargetRow NUMBER := 0;
BEGIN
[code].......
I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:
Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
[Code].....
I have downloaded Oracle 11g XE and installed it on my laptop, Win 7 Enterprise Everything works great, DB admin page comes up, APEX comes up (4.0.2.x). I download the Apex_4.2.3_en.zip. I extract the zip file and then follow the instructions in, Downloading from Oracle Technology Network essentially the apexins.sql, apxldimg.sql with the admin password changes and anonymous user unlock.
This is the install command, @apexins SYSAUX SYSAUX TEMP /i/
I get the Error processing request ORA-010403: no data found.
how to upgrade Oracle apex listener from 1.1.4 to 2.We are using Oracle apex listener with Glassfish 3.1.2.
View 0 Replies View RelatedWe have upgraded our apex installation from APEX 4.0.2 to 4.2.2 and APEX listener to 2.0.2
Below is our configuration
Host 1 : Oracle databaseOracle database - 10.2.0.5APEX - 1.1.3
Host 2 : Apex listener on Weblogic serverWeblogic server - 10.3.5 APEX listener - 2.0.2
Post the upgrade , applications that were existing before the upgrade are not working properly.
Errors faced:1.When we edit any page in application - we get no data found error2.
When we run any application - We get no data found error We are able to create new applications without any issues.Luckily , we had the export backup of one application taken before upgrade. We imported that back( only one application ) and that application is working fine. We imported the application in apex.oracle.com as well and get the same error[URL]... occurs during page 'Edit' as well.
O/S: Windows 2003
DB: 11gR1
Email no longer working for users after upgrading from 4.0 to 4.1. New 'principal' APEX_040100 added to same ACL as previous version's principal APEX_040000. In fact, both still exist in ACL.
Error code in APEX Admin Mail Queue: ORA-24247: network access denied by access control list (ACL)
What could be causing the email facility within APEX to no longer work?
When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.
What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.
I am in the middle of upgrading my application to Apex 4.1 from 3.2.1. I have been using the default delete message and now it won't work.
<script langues="javascript" type ="text/javascript"
<!--
htmldb_delete_message='"DELETE_CONFRIM_MSG"';
//-->
</script>
button action
redirect to url ----> javascript:confirmDelete(htmldb_delete_message,'DELETE_RATING');
now all I receive is a message from the webpage, instead of the message.
I have been given the task to modify our company's Apex from 4.1 to 4.2. The upgrade has been completed; in addition, the current UI, blue and tan has been updated to BlueJay. I have noticed the structure of the page gets shuffled as well as contents within modules. What would be the best way to "re-organize" my pages.
- Would it be easy for me modify the page, if so how do I do this. The settings look identical, so what would I change ?
- Do I recreate the entire page from scratch ?
I have enabled SSO for my application. It was working in 4.1 version. I have upgraded to 4.2 now and the same code doesn't work now.I have created an authentication scheme where i check if a particular person is an employee based on a flag. If he is, then I return 1 to the authorization scheme i have created. This always returns 0 even if the flag is set to 'Y'. I have tried hard coding the user_id as well. It doesn't work.
I tried printing the :APP_USER but it does not give any output.
Apex has been upgraded from 4.1 to 4.2.2. I don't know if the upgrade was done correct or not by the administrator, but I don't have the page edit link anymore,
and anytime I run a individual page from the Edit Application, I have to Log in. Did something went wrong during the upgrade or is this the behavior of Apex now, which I don't think so.
We just upgraded to APEX 4.2.2.00.11 and we are getting ORA-24247: network access denied by access control list (ACL) errors form apex_mail. This had been working correctly prior to the upgrade.
View 4 Replies View RelatedAfter upgrading to Apex 4.2 I'm now unable to test Report Queries. Each time I click on the Test Report button via Shared Components|Report Queries I recieve the following error message:
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.
I still have Apex version 4.1 installed on a different server and it appears to be working fine.
O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============
Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.
It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.
is it currently possible to install the supporting objects using sqlplus?
When I export an APEX application which contains supporting objects (scripts to install images, css files, tables and seed data) I can run this script on the command line using sqlplus to install the application into the target environment.
After installing the application (which works fine), I cannot invoke the installation of the supporting objects nor the upgrade of the the supporting objects.
Am I overlooking the obvious, have checked APEX_APPLICATION_INSTALL but there is no function available for that purpose?
I got a bug related to update information in APEX.
the situation occurs when I go to update a record the button Apply changes disappeared, it shows me only the button create, so when the user click on it, it creates a duplicate.. so how can i have the button "apply changes" back?
After Upgrading to Apex 4.2
When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.
I'm running a mobile application on a hosted Apex environment which uses lots of jQuery mobile. The environment has been updated to 4.2 recently, and since that happened pages that I had setup to use the content grid, to show content in 3 columns no longer works, there only appears to be 1 column now.
Code as below: -
<div class="ui-grid-b">
<div class="ui-block-a">Block A</div>
<div class="ui-block-b">Block B</div>
<div class="ui-block-c">Block C</div>
[code]........
I have recently upgraded our test APEX environment from 3.2.1 to 4.1.1.00.23. Everything went smoothly - I have only one small but annoying problem. In both administration and administration services some background graphics are not displayed. This issue occurs only under Mozilla Firefox (in MS IE it OK). The application frontend is OK in both browsers.
Under Firefox, I inspected the sourcecode in Firebug and the relative links to images. e.g.
background: url("../apex/builder/bg-region-darkblue-r.gif") no-repeat scroll
show message "Failed to load the given URL".
somehow related to the fact that our application is accessed via apache proxy. Because when I open the administration and/or administration services page in FF directly on the server, it displays correctly (incl. images).
But the network (Apache proxy) configuration is exactly the same as in the previous version of APEX where we had no problem. Something must have changed in the sourcecode of the new version.
We have to upgrade our existing 11g R-1standalone DB to Cluster & ASM. Upgrade DB from 11.1.0.7 to 11.2.0.3 & Enable RAC.
View 7 Replies View RelatedI'm planning to upgrade a small database (~150GB) from 10.2.0.3 on windows 2003 23bit to 11.2.0.3 RAC on Linux 5.8.The database contains oracle spatial too. A suitable method and link to document to be followed.
View 2 Replies View RelatedI recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).
I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.
But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:
SQL> conn scott/tiger
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .But I want my auditing to be enabled as per y requirements.
is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?
View 5 Replies View Relatedfind reference note IDs for DB upgrade from 11.2.0.2 to 11.2.0.3.2, as I am finding only Exadata which I don't want but I want to find for Ebiz database, on OS - Solaris 10 9/10 s10s_u9wos_14a SPARC.
View 1 Replies View RelatedAlong with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory
Select * from dba_directories; (there are other commands to get this info as well).
I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?
Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.
All my sys tables are very slow after my database upgrade from 10.2.0.4 to 11.2.0.3 on AIX 6.1
For example
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 11.2.0.3 and few millisec in 10.2.0.4
I have deleted and updated fixed and dictionary table statistics , till I facing this issue
Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?
View 1 Replies View RelatedI am going to upgrade database from 11.1.0.7 to 11.2.0.3
1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?
We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1
No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.
can we upgrade the oracle database from enterprise edition to latest standard edition?