Application Express Listener :: Page Is Blank And Freezed
Jan 15, 2013
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.
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...
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.
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.
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.
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:
I have select list which has null and other values. I have created a blank HTML region with the following text
Report for the year &P2_YEAR. and for geography &P2_GEOG.
Now P2_YEAR works fine because, it is always populated with a year. However, &P2_GEOG has 'All' as null value since we can see the report for all geographies. However, if the all option is selected, the above &P2_GEOG. shows as null. Since its not a PL/SQL proc, I cannot put in a NVL. I am guessing one possible way is to write a PL/SQL code before region and then check if its null and then try to populate a new hidden field and show, something like that. Wondering if there is a way to do it directly in the HTML region?
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 .
I have developed a form which has webutil objects in it, and it is working fine on my local machine. When I deploy my form to my application server it opens up a blank page. I have configured the webutils in the app server as per the document and made entries into formsweb.cfg regarding frmwebutil.jar,jacob.jar. Does the dev suite need to be installed in the server for the webutils to run properly?
Also I watched my java console as I opened my form and I am pasting the contents below: ----------------- Loading frmwebutil.jar from JAR cache Loading jacob.jar from JAR cache proxyHost=null proxyPort=0 connectMode=HTTP, native. Forms Applet version is : 10.1.2.3 [code]...
Need 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
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'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?
I'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)
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
I 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?
I'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.
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)
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)
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..
I created a page with 2 tree regions. Both trees use different items and different queries. The first tree is displayed correctly. But the second one just contains the first item, if I don't display the first on via customizing the page or if I change the order of the trees the previoulsy invalid tree is shown correctly, but I didn't find a way to display both correct at the same time.
