I just upgraded my APEX 4.0 application to 4.2, and ran the utility to upgrade my charts to HTML5. After completing the upgrade, I noticed my charts no longer displayed in the region.
I am currently using IE9 to view the application, since that's the browser over 90% of my users have. Is there something more I need to install?
I just upgraded from APEX 4.1.1 to APEX 4.2.2All is good, but I can't create pie charts. Pie Charts never worked for me, but I waited until 4.2.2 to try again. Still will not work. I imported the workspace from my previous APEX version,so something must not be set correct in my workspace. I can create the pie chart on apex.oracle.com
Here's my info:- Application Express Version: 4.2.2- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production- OS Red Hat Enterprise Linux Server release 5.9- WebLogic 10.3.5- Apex Listener 1.1.3.243.11.40
APEX 4.2 Theme 25 Oracle DB 11gr2 - I need to conditionally display Html5/Flash chart regions depending on browser compatibility, how to achieve this.
View 8 Replies View RelatedI need to create a Radar Chart, this kind of chart isn't avaible on APEX then, I should buid it, I have found some models of this chart, but I'm not getting sucefull when I try to use the data from my database.
I'm using APEX 4.1.
using APEX can we develop Charts and dashboards.
View 1 Replies View RelatedI am using "Function Returning SQL Query" (as query is dynamic) to draw the bar chart (flash).
I am facing some issues while trying creating a BI report for this chart.
Issue is : In Shared Components -> Report Queries : Its only expecting an SQL Query.
Do we have any ways to define a "Function Returning SQL Query" over here ? Note that, If using a static SQL both charts / BI reports are working fine with out any issues.
I have a requirement create graphs, charts and maps based on data from a data warehouse (dw).
As I see things, there are two possibilities: Graphs, charts and maps based on an XML fileGraphs, charts and maps based on Oracle tables Both would contain small data sets that will allow for quick response.
The intent of these graphs, charts and maps is to generate a dashboard that would allow the user to quickly drill down to the desired warehouse data. The proof of concept has already been validated using the Oracle table scenario.
My question is whether or not this could be accomplished reading xml files for generating the same set of dashboard items? My Oracle database and APEX environments configuration are as follows:
NLSRTL 11.2.0.1.0 Production Oracle Database 11g Enterprise Edition 11.2.0.1.0 64bit Production PL/SQL 11.2.0.1.0 Production TNS for Solaris: 11.2.0.1.0
ProductionApplication Express 4.2.2.00.11APEX Listener Release 2.0.2. / Tomcat
An Oracle database directory has been setup and is accessible to our APEX application.
whether the overlapping Multiple series charts are possible in Oracle APEX or not .
I am trying to create two graphs for two data sets , one as marker and another as line , but its giving me issues such as
1) X axis is taking all the points of the first series suppose(
1,5,10,180) itsplotting these first . and its then starting labeling
the x-axis for another one which has values like
(20,50,100,1000,15000)
so my X-axis is now ---> 1,5,10,180, 20,50,100,10000,150000
In case i make my marker chart series as the 2nd sequence , then its drawing all the markers on the right side of the chart .
[URL].........
Workspace:- NR_WORKSPACE
Username:-user1
password:- H123$
whether this thing is achievable in oracle apex or not , is there any work around ?
Is there a way to prevent Apex from combining labels into an "other" category in the charts?
View 4 Replies View RelatedI receive this error. In my opinion the problem could be related to the presence of one personalized authentication schemas, based on a DB function, taken from a Packaged application, some years ago, called "menu_framework".
This is the error report:
........
-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
begin
*
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x26962168], [0x1A1042F4], [], [], [], [], [], [], [], [], []
1) after the error trap, I copied the Image folder and tried to launch APEX. It was possible to lunch the development pages, but impossible to execute any application with the error: Authentication Schema not Supported
2) then decided to downgrade to APEX 4.0, following the proper instructions: received a similar error:
.......
SQL> exec apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000
');
BEGIN apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000');
END;
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x16D5D9E4], [0x27F2074C], [], [], [], [], [], [], [], [], []
The execution of application reported the same problem.Then decided to restore the entirre DB.
Where is my problem?Are my suspects real or the Authentication schema malfunctiong is a conseguence of the upgrade error?
I installed APEX 4.2 over XE 11.2
The Installation process succeeded.I Used the Installation Guide -> and followed the steps from chapter 3...My problem after the Apex-Upgrade ->
The page URL.... is blank, or say it better, ... there is nothing visible on that page (no Login-Form)The original GetStarted page from XE Database -> URL.... shows an Error Error Error processing request.ORA-01403: no data found
I can post the sourcecode from the "blank" HTML-Page...
I have some problems with displaying images in my application. I have read the same topic but unfortunately didn't find the solution.
So.. I have the interactive report
table test (
NAME NOT NULL VARCHAR2(4000)
ID NUMBER
BLOB_CONTENT BLOB
MIME_TYPE VARCHAR2(4000))
I need to display the column blob_content.
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 a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .
View 1 Replies View RelatedI am using custom authentication with APEX 4.1.1 and I want to display custom error messages on the login page if authentication fails. In my authentication function I'm using apex_util.set_authenication_result to set a result code (code below).
I've tried to use the apex_util.get_authentication_result on the login page to hide and show custom messages but it's not working. I don't believe the apex_util.get_authentication_result is actually obtaining the result?
FUNCTION verify_user(
p_username VARCHAR2,
p_password VARCHAR2
) RETURN BOOLEAN
IS
v_ctr NUMBER;
[code].........
After setting up a data entry page,The logic in my page requires that all the records in my tabular form should be displayed .The tabular form is based on a collection, and the user selects rows through a checkbox.Any reload of the page due to pagination will break the logic, as some calculation and display events occur during page load, based on the previous page.
I need to display about 25 rows.I have changed the report attribute to display 50 rows, but it displays rows only up to the bottom of the screen, i.e. 11 rows.
Unfortunately I only just added some new rows and saw this behaviour else I would not have gone that way, as I expected APEX to display all rows if required.
APEX 4.1 / 11g
Theme 21
I have a page with about 8 Classic reports. 4 of them percentage values, 4 totals. I have one RG with a Percentage or total option. When I select the percentage radio, it should hide all the total regions. When I select the totals radio it should hide all the percentage regions. Simple? So I thought. This is what I did.
1. Created a RG(P2_RG) -> Page value is redirect and set value.
2. STATIC:Percentage;P,Total;T
In the RG, I have created a normal DA which has the true and false events as follows.
Event -> Change
Items -> P2_RG
equal to -> P
In the true actions, I have hidden the 4 totals regions.
shown the 4 Percent regions.
In the false action, I have shown
hidden the 4 percent region
shown the 4 totals region.
The event specification for one these true actions is
Action -> Hide (If I am hiding)
Fire when event is ->True
Selection type -> region
Region -> The region I want to hide/show.
But it does not work! I tried to replicate the issue on apex, by using a small example but could not. Works fine in apex following the same process.
[URL]
I tried to debug by having a display item to show the value when I change the radio button. The values are changing properly. I tried actually, adding a condition filter in the region itself by using the "Value of item/column in expression1 = expression 2" where expression one I tried :P2_RG and expression 2 as P but that just hides the whole region.
I am creating multiple entries for auto populate item as shown in this jquery plugin link below but i am trying to change this so values come from table query. how can i achieve this even using web services in apex 4.1.1 but i am trying NOT to use remote url or external file?
[URL]......
I am doing a upgrade from 10g2 standalone (with out ASM) to 11g2 2 node cluster (on ASM) and the database is some what 1TB of the size. My problem is if I do a export and import the live system need to be down for over an a day. is there a better way of doing this and how ?
View 6 Replies View RelatedWhat could be the reasons that some queries execute fast when executed on sqlplus on server, whereas the same queries run slower with same input values fed from application screen?
One issue I guess would be bind variable peeking while using application whereas executing from sqlplus is causing hard parsing and thus getting rid of "peeking"
If displaying the data on application screen is taking time after data has been fetched, where I can see this delay?
I understand the elapsed time under 'Fetch' in tkprof will show time taken to fetch from database and not the time taken to be displayed in the application GUI
finally how to set arraysize in jdbc to improve performance by reducing roundtrips?
XML report for particular period completing in warning, throwing error:
Beginning post-processing of request 60011540 on node TSGSD4901 at 03-JUL-2012 10:55:56.
Post-processing of request 60011540 failed at 03-JUL-2012 10:55:57 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
Checked OPP logs:
Language: en
Territory: US
Output type: EXCEL
[6/20/12 3:07:01 PM] [UNEXPECTED] [1657868:RT60695905] java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor716.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
[code]........
But i am unable to trace .
im still trying to create workcharts into an Excel sheet (see thread "How to create pie chart in Excel sheet"). I could not be able to create pie chart, but I got to create a histogram chart. Now, I wish to customize labels and legend.
The issue is that the data range is made by non-contigouous cells, and some of them are merged. So, I tried to create by hand a pie chart, and this is the code behind:
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets("SUMMARY COSTS 2011-2012-2026").Select
[code]....
how can I implement this code in Forms 10g using OLE2? In details, how does SeriesCollection work?
i am getting error when iam starting enterprise manager GUI dbcosole,its not displaying the graphs of HOST CPU and active session graphs instaed its giving me error such as java.lang error and null point error below the graphs.
i stop and start the dbconsole from services and from command prompt and rebooted the server,but still showing the same error..did open in other kernals such as mozilla and google still the same issue..
We have downloaded the 11.1.0.7.0 version from the below link
[URL]
The downloaded dump name is win64_11gR1_database_111070.zip.This dump is intended for Windows 2008.
we have installed this dump on Windows 2003 and upgraded from 10.2.0.4 to 11.1.0.7 .
In the process we have not encountered any issues. Whether the steps we followed would suffice for an upgrade from 10.2.0.4 to 11.1.0.7 or Should i go for 11.1.0.6 base version installation and apply 11.1.0.7 patch set.
We have several applications hosted on a server using ODP.NET 10, but we are the first to decide to upgrade to ODP.NET 11 which means we need a method where only our application uses ODP.NET 11 without affecting any other existing applications.
I've read about the policy files which automatically redirects application to use latest version installed on the machine. Is there a method available which can avoid this situation as the owners of other application may not allow this to happen.
How can I ensure that my application is using ODP.NET 11 or ODP.NET 10 if both are installed? I created two sample app one with Oracle.DataAccess.dll 10.2.0.100 and other one with Oracle.DataAccess.dll 2.112.3.0. With below line of code, I found both applications are showing Oracle.DataAccess 2.112.3.0 at runtime.
System.Data.Common.DbProviderFactories.GetFactoryClasses();
Last thing, I may be wrong saying latest ODP.NET wouldn't work with NHibernate 1.0.3.0. please validate.
I am upgrading oracle database from 9.2.0.7 to 11.1.0 (clients need 11.1. andnot 11.2).
Metalink tells me that I can do a direct upgrade and don't have to go to 9.2.0.8. so that's good news. Since time is of essence here : )
I ran the utlu111i.sql.
And made the following changes, per its recommendation.
Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "log_archive_start"
--> "max_enabled_roles"
--> "parallel_automatic_tuning"
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"
ISSUE 1:I already have a sysaux tablespace in my db, but the log still says, SYSAUX Tablespace:
[Create tablespace in the Oracle Database 11.1 environment]
**********************************************************************
--> New "SYSAUX" tablespace
.... minimum required size for database upgrade: 500 MB
ISSUE 2:I copied the 9i orapw file to the 11g $ORACLE_HOME/dbs location but when I try to login, using the same login (after I source the new profile) it still asks me for username/password. Doesn't allow remote sysdba login ? DO I NEED TO DO SOMETHING SPECIAL WITH THE PASSWORD FILE ?
ISSUE 3:Here are the steps I took before I get the next error:
I copied the init file from 9i location to the 11g location made the above changes in the init file.
I set the compatible to 10.1.0.
Added diagnostic_dest and got rid of bdump, udump and cdump
Then I shutdown the db (9i) I sourced the 9i profile (IS THIS TRUE OR SHOULD I SOURCE THE 11G PROFILE ?), and tried to start the db using startup upgrade (my changes have been made to the 9i init file and that is the one I am using to start the db with in the upgrade mode, is that ok ? ) I GET THE FOLLOWING ERROR SP2-0714: invalid combination of STARTUP options
Need to clarify upgrade procedures from Oracle 9i R1 (9.0.1.0.0) to Oracle 9i R2 (9.2.0.3.0). Do we need to first upgrade to 9.2.0.1.0 (as base) before proceeding to patch it by version 9.2.0.3? Or could we patch it directly from 9.0.1.0 to 9.2.0.3?
View 3 Replies View RelatedI am upgrading my server from 10.2.0.1 to 10.2.0.4. in DST check the timezone values returned is 2 and not 4. I have checked using utltzpv4.sql and the jobs returned are as below.
Owner table_name Column_Name.
SYS SCHEDULER$_JOB LAST_ENABLED_TIME
SYS SCHEDULER$_JOB START_DATE
SYS SCHEDULER$_WINDOW LAST_START_DATE
I dont have any userdata using TSTZ or TSLTZ.
So I have an extremely weird error that I just found after several month of being upgraded to 10g from 6i. Right now I have several data blocks where users input data. The field that they input into is fairly long, so we give them the option to double-click which opens up the editor.
Now, if they do this when entering the field for the first time, everything works great. However, if they save, then decide to go back into the data block and edit the field, they can edit it in the text just fine. However, if they double-click and bring up the text editor, after they click ok (or cancel) it jumps back to the first data block.
What is more weird is I can't get it to happen on my own machine, only when it is running on the unix server. On top of that, I was able to avoid the issue by simply showing a message saying "field is about to be edited" and making them click ok. Of course, it's a work-around
I just upgraded my oracle DB version from 9 to 11.2g with the assistance of a DBA. The upgrade went fine, and all the data transfered as it should.
The only problem that I got is that almost every query that I try to run via my PL/SQL developer throws the ORA-01843 error. I checked the NLS-lang property from the previus DB and it is the same as the new one. The DBA says that the problem is in the PLSQL properties (althogh I didn't change them).