My configuration is GlassFish 4 (the same thing with Glass Fish 3.2) + win7 + Apex Listener 2.2 (the same thing with Apex Listener 2.1) + Apex 4.2.2 I get blank page when trying to connect to APEX. But after loggin into GlassFish admin page (exactly login with username+password; just open admin page is not enough) in another browser tab I get proper Apex page with all images.
View 1 RepliesWe had several unexplained lock-ups of APEX in our environment in the last months. This all happened after we moved to GlassFish with the APEX Listener. The symptoms were always that all connections in the JDBC connection pool were in use and we had to restart the GlassFish server instance to free them up.
The culprit is the caching folder that the APEX Listener uses for file caching. We use this to cache image downloads from the database through a procedure, and the caching folder was set to /tmp/apex/cache. I believe this is the default setting. All went well, when the procedure was called the images were downloaded from the database and cached under /tmp/apex/cache. However, for some (as yet unexplained) reason, Linux sometimes removes this folder from the /tmp file system. This seems to happen from time to time after an unknown period of inactivity. We didn't reboot the server. After the folder is gone, the APEX Listener is unable to recreate it, keeps on creating new database connections until the maximum configured is reached, and we need to restart the GlassFish instance to free them up. This also recreates the caching folder.
Our environment: GlassFish 3.1.1+3.1.2, APEX Listener 1.1.3, Oracle Linux 6.2. I didn't try out the new APEX Listener 1.1.4 yet so I'm not sure if this has been fixed in the last version.(kind of reminds me of the problem where the APEX config file is by default placed under /tmp and also disappears from time to time)
Problem is that page is blank and freezed. After another enter in URL page is shown normally.What I find out is that "freeze" happened only in Apex design time ... never in runtime of any of mine app.
Mine conf:
Apex 4.2.1 on
Apex Listener standalone 2.0.0.354.17.06
Oracle 11.2.03 x64
Windows 2008 SE R2 x64
C:UsersDamirV>java -version
java version "1.6.0_34"
Java(TM) SE Runtime Environment (build 1.6.0_34-b04)
Java HotSpot(TM) 64-Bit Server VM (build 20.9-b04, mixed mode)error log:
D:UsersdamirvDesktopApexApex-Misc>set ORACLE_HOME=c:oracleproduct11.2.0dbhome_1
[code].....
My configuration is
APEX 4.2 on Windows XP with APEX Listnere on Glassfish 3.1.2 Open Source Server Edition.
The database is 11G XE
Let me explain the scenario which is not working.A Modal region which is having a file browse item based on WWV_FLOW_FILES and a button called add file.
When I click on add file it display a blank page and in the URL I could see [URL]...But actually it inserted file in the table.
I have put wwv_flow* in Listener Configuration for allowed procedures.I have another page where I have a page item which is based on BLOB column specified in item source attribute. And that is inserting file and displaying the pages correctly.
Having an issue with logging into URL.... Just went through the install for APEX 4.2 for
Oracle 11.2.0.1 on Linux 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux.
Installed Apex with Embedded PL/SQL Gateway.Explicitly followed all the online instructions step-by-step, installation was success and config for EPG had no issues. Changed the ADMIN pw as instructed. Checked that EPG is running on port 8080. Ran this script to grant connect:
DECLARE ACL_PATH VARCHAR2(4000);BEGIN -- Look for the ACL currently assigned to '*' and give APEX_040200 -- the "connect" privilege if APEX_040200 does not have the privilege yet. SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;[code]....
that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');END;/COMMIT;
When I go to log in it says "Invalid Login Credentials". I tried changing the admin pw several times but keep getting the same message.
We have 2 apex schemas
APEX_030000
APEX_040200
Before executing the apxchpwd.sql, found the "alter session command" sets schema to APEX_030000. So we changed that to APEX_040200. Then we executed the sql script. It executed fine.
But now when we try to login to apex, and pressing enter after providing the username/pwd, it raises the following exception
Error Error in PLSQL code raised during plug-in processing.
ORA-06508: PL/SQL: could not find program unit being called
We are unable to connect our admin account for some unknown reason. We keep receiving the following message "Invalid Login Credentials". We tried to change the admin credentials with sqlplus. We tried the usual procedure "apxchpwd" successfully, but we still cannot log in.We then tried to create a new admin2 account with the following pl/sql block.
SQL> connect APEX_030200 as sysdba
Enter password:
Connected.
[code]....
We cannot connect with either admin & admin2.
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.
I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen
SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:
[code]...
warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection
i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.
Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.
In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.
With a button, its simple because its inbuilt there,but I do not want a button,just this: Register
I want also to have the text in color not black.
I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11
which is a simple report with the following query:
SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .
View 8 Replies View RelatedNeed to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.
Issue here is unable to find a way to set the page range item values based on the quarter field selection
how to reset the page item fields.
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies View RelatedI'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?
View 3 Replies View RelatedI've just instaledl APEX on Oracle 11g, with APEX listener 1.1, working fine at localhost. But I can't reach it from others computers on LAN. I searched several threads about this and thought I should run
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
But when I execute that, I got the message 'ORA-30952: illegal configuration of HTTP/HTTPS in xdbconfig.xml'.
we would like to generate pdf out of apex. as long as we have text (IRR) WITHOUT special characters (öäü), everything is working fine.when we have this characters in a text-columng (IRR), then we get a .pdf with the following content:
javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: An invalid XML character (Unicode: 0x3) was found in the element content of the document.
- we defined in ADMIN in 'report printing' / 'instance-settings': oracle-apex-listener
- we are working with apex-listener 2.0 (integrated in weblogic-server)
- we work with APEX 4.2.1.00.08
i m using apex 4.1 and the database is oracle *11g* i want to know how to use the java (servlet,jsp,all technologies of java in apex ) and what i have to do to use the java in apex
View 3 Replies View RelatedI am currently hosting a number of APEX applications, using OHS as the webserver and I looking into using the APEX Listener instead. However I have a lot of rewwriterules in my OHS configuration. Is this something that can be configured in the APEX Listener?
<VirtualHost *:80>
ServerAdmin webmaster@dummy-host.example.com
DocumentRoot "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/htdocs"
ServerName application-a.example.com
RewriteEngine On
RewriteRule ^/$ URL....
</VirtualHost>--Andy
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 RelatedI'm attempting to configure printing via the APEX listener and I'm struggling to understand it. I currently use Oracle HTTP server as the web server for APEX. I have installed the APEX listener and configured it. If I connect via the APEX listener, PDFs work correctly. If I connect via the Oracle HTTP server, I get an error with PDFs. Am I required to connect with the APEX listener for PDF printing? I thought I could configure APEX listener for PDF printing on the backend and still connect via Oracle HTTP server. I'm use APEX 4.2.3, APEX Listener 2.0.5, and Oracle DB 11.1.0.7.
View 5 Replies View Relatedi am running the following configuration:
Oracle Database 11.2.0.3
Application Express 4.2.1
apex_listener.2.0.1.64.14.25 on Glassfish 3.01
Everything works fine except the restful webservices. In SQL-WorkShop when i create a simple GET webservice and klick on "Test"" 404 not found" comes up in the browser.In the log i can see:
Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
Not processed as PL/SQL Gateway request
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
No Tenant Principal established yet, continuing processing
APEX_LISTENER pool exists, continuing processing
No matching tenant found for: ifc, cannot dispatch
No candidate found for: GET ifc/certification in context: URL....
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 use the "Media Resource" RESTful service type to generate custom JSON objects via CLOB-returning functions. This worked great in APEX Listener 1.1.3. However, on APEX Listener 2.0 I get status 500 on a RESTful service which works fine on 1.1.3 (which generates a clob > 4000 bytes), and the following in the server log:
SEVERE: ORA-22922: nonexistent LOB value
oracle.dbtools.common.UnrecoverableException: ORA-22922: nonexistent LOB valueThis seems to be the same issue as reported here:
APEX Listener EA2 Standalone CLOB error
As stated by thoechst in that thread:
>
It is as though the function is getting cast as a varchar2 somewhere. I verified that the function will correctly return a large result to other sources (dbms_output, for instance).
>
Versions:
APEX Listener 2.0
WebLogic 10.3.6 on Windows 2008 SE R2 x64
Oracle DB 11.2.0.3
I have, it would appear, successfully installed APEX 4.2 & APEX Listener 2.0 EA (in WebLogic). APEX works fine and it's reverse proxied using mod_weblogic through the OHS. I have configured APEX Printing to be via the APEX Listener.
However, creating a simple report, enabling printing, running the report (e.g. PDF or Word) produces the following few-byte content (only) inside the actual PDF file (obviously not in PDF format):
String index out of range: -1
Furthermore, it throws the exception below on the WebLogic console.
Any experience with the APEX Listener - and if so managed to rectify it?
SEVERE: String index out of range: -1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1931)
at oracle.dbtools.apex.hooks.postProcess.FOP2PDF.requestTOPDF(FOP2PDF.java:82)
at oracle.dbtools.apex.hooks.postProcess.FOP2PDF.postProcess(FOP2PDF.java:36)
[Code]...
I have "After header" process (with PL/SQL code) in "Page Rendering" section and want to navigate to some page after this process has been completed. I created a branch (On Submit: After Processing) with Target Type: URL. But this branch is executed only after "Page Processing", not after "Page Rendering". Maybe , there is any APEX API functions for pages navigating..
View 2 Replies View Related