Inside Oracle APEX by Patrick Wolf

Thursday, April 03, 2008

Oracle APEX: Got a 404 Not Found?

Maybe you also already got the 404 Not Found error message

The requested URL /pls/apex/wwv_flow.accept was not found on this server.

when you submit an Oracle APEX page, ...

There are a lot of reasons why this error can occur. But the above error message doesn't tell you a lot about the root cause of the problem. The real error message can be found on your Apache Web server in the Apache\Apache\logs\error_log.xxxxx file. There you will find and entry like
[Thu Apr  3 ...] mod_plsql: /pls/htmldb/wwv_flow.accept HTTP-404
wwv_flow.accept: SIGNATURE (parameter names) MISMATCH
VARIABLES IN FORM NOT IN PROCEDURE: P_T02XXX
NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM:
Without the above information, you have no chance to find out what's causing the 404 error. But the problem is, that most developers don't have access to the application server.

You don't have to!

Just put 
<Location /pls/apex>
 ...
 PlsqlErrorStyle  DebugStyle
 ...
into your dads.conf/marvel.conf and after restarting the Apache server you will get the error message directly in your browser.

For more details about PlsqlErrorStyle, have a look at the documentation.

Note: Only use this setting on developments systems, because on production systems a hacker might get more information as he should!

Credit for this tip goes to Dietmar Aust!

Labels: ,

posted by Patrick Wolf at 4/03/2008

del.icio.us digg dzone furl reddit technorati

16 Comments:

  • Hello Patrick

    I get that message when I logout of my application and it redirects me to the login page.

    [Fri Apr 4 11:08:08 2008] [error] [client 10.99.8.138] [ecid: 1207300088:172.19.4.41:19354:0:16910,0] mod_plsql: /apex/wwv_flow_custom_auth_std.logout HTTP-404 \nwwv_flow_custom_auth_std.logout: SIGNATURE (parameter names) MISMATCH\nVARIABLES IN FORM NOT IN PROCEDURE: AMP;P_NEXT_FLOW_PAGE_SESS\nNON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: \n


    I don't know what the reason is, but it happens only in Mozilla not in IE7.

    Do you happen to know, what could be wrong ?

    Regards, Matjaz

    By Anonymous Anonymous, at 04 April, 2008 11:11  

  • ... forgot to mention:

    I am using 3.1 and the cause seems to be unsubstituted ampersand character in URL.

    It works after manual replacement of "& amp " with "&" in URL.

    But I don't know where or how to fix this.

    Regards, Matjaz

    By Anonymous Anonymous, at 04 April, 2008 11:22  

  • Can you send me the link which you have defined in you Shared Component\Authentication\Logout URL

    Patrick

    By Blogger Patrick Wolf, at 04 April, 2008 11:40  

  • Logout URL is left unchanged from default ( here it isn't displayed like I see it because of replaced characters) :

    wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.& amp;p_next_flow_page_sess=&APP_ID.:1

    I found the cause for the problem. I had a logout mechanism implemented so that popup page closes and the main page is redirected:

    window.opener.location.href='&LOGOUT_URL.';

    I changed the above to ;

    var url='&LOGOUT_URL.';
    window.opener.location.href=url.replace('& amp ;','&');

    ... and it works.

    Thanks for pointing me in the right direction.

    Kind Regards, Matjaz

    By Anonymous Anonymous, at 04 April, 2008 13:26  

  • Is there an equivalent for environments running xdb? I've battled this recently with an XE installation.

    By Blogger Paul Dunbar, at 04 April, 2008 14:46  

  • Hi Patrick,

    thanks for blogging this. There is so much that we learned in our previous projects using these technologies, which could helpful for others.

    The is just so little time to write about it ;).

    Well done,
    ~Dietmar.

    By Blogger daust_de, at 04 April, 2008 22:07  

  • Just wanted to also share that we just recently have started experiencing a "404 - page not found" error consistently after upgrading to ApEx 3.1. We experience the following error whenever we do modify a region or process which has exceptionally long PL/SQL code. We created a service request with Oracle Support, but are still looking for resolution.

    ------------------
    [Wed Mar 26 10:55:31 2008] [error] [client xxx.xxx.xxx.xxx] [ecid: 118812560695,1] mod_plsql:
    /pls/htmldb/f HTTP-404 ORA-06502: PL/SQL: numeric or value error: character
    string buffer too small
    ORA-06512: at "FLOWS_030100.F", line 279
    ORA-06512: at line 23
    ------------------

    I'm not attempting to use your blog as a plea for help, but wanted to post something about it (and hopefully the solution soon) so that others who may run into the problem can find a solution.

    I will submit another comment about this when a solution is found.

    Shane.

    By Anonymous Anonymous, at 05 April, 2008 05:32  

  • Shane,

    one of my colleges also told me about such a numeric value error problem on another development database. Haven't had the time to investigate but it will be a support issue anyway.

    But thanks for keeping us updated.

    Patrick

    By Blogger Patrick Wolf, at 05 April, 2008 10:58  

  • Hi Patrick,
    I have a question (not related to this posting), how can I assess the table (for updates) underlying this view, APEX_APPLICATION_PAGE_ITEMS. The main reason, the admin user of my apex application wants to have a form to allow them to update the Help Text (context help) on items on various pages. I understand I can generate a report based upon this above view, but, can i also access the underlying table to actually achieve this. I will really appreciate your feedback.
    thanks & regards, Kavin.

    By Anonymous Anonymous, at 07 April, 2008 03:57  

  • Hi Kavin,

    direct manipulation of the underlaying tables is not official supported by Oracle. But have a look at my presentation The Power of the Oracle APEX Repository or the ApexGen project.

    Hope that helps
    Patrick

    By Blogger Patrick Wolf, at 07 April, 2008 08:42  

  • Thanks Patrick!
    I will try these out.

    regards,
    K

    By Anonymous Anonymous, at 07 April, 2008 16:35  

  • Hi Paul,

    yes, it is possible to do in XE (using XDB), too.

    Here are the instructions:
    http://daust.blogspot.com/2008/04/troubleshooting-404-not-found-error-on.html

    Regards,
    ~Dietmar.

    By Blogger daust_de, at 13 April, 2008 17:55  

  • Patrick,

    Your blog guided me to solve many problems.. but currently

    I've installed Apex successfully in my Oracle DB 9.2.0.6.0.. Apache also started..

    when I run


    [oradev@oracle bin]$ /d04/oradev/crptestdb/9.2.0/Apache/Apache/bin/apachectl status

    Looking up localhost:7778
    Making HTTP connection to localhost:7778
    Alert!: Unable to connect to remote host.

    lynx: Can't access startfile http://localhost:7778/server-status

    Now, my apex web page is also not opening.. I restarted apache ,but does'nt help.

    which port should I use to access Apex..

    Thanks
    Yusuf

    By Blogger yusuf, at 29 April, 2008 16:12  

  • Yusuf,

    I'm not really an Apache expert. The best would be if you post your question on the OTN forum. I'm sure someone can help.

    Greetings
    Patrick

    By Blogger Patrick Wolf, at 29 April, 2008 18:41  

  • Hi Yusuf,

    this error message is meaningless. In my configuration I get the same error. It seems to use the values which were initially used at installation time.

    You can get the real port by checking the Listen parameter in your httpd.conf file:

    www:oracle[]> cd $ORACLE_HOME/Apache/Apache/conf
    www:oracle[]> grep Listen httpd.conf
    # Listen: Allows you to bind Apache to specific IP addresses and/or
    #Listen 3000
    #Listen 12.34.56.78:80
    Listen 80

    Regards,
    ~Dietmar.

    By Blogger daust_de, at 29 April, 2008 19:27  

  • Thanks Dietmar. it worked fine..



    Yusuf

    By Blogger yusuf, at 29 April, 2008 23:01  

Post a Comment

<< Home