Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The requested URL /apex/f was not found on this server

helmut_hJun 5 2011 — edited Jun 7 2011
Hi all,
I have a problem accessing my admin and developer workspaces. (I still can login to the applications!).
Probably it's my fault, but the question is how this can be corrected. What I've done:
As the Admin(Internal) user I wanted to raise the timeout settings for the developer sessions. I changed the values for "Maximum Session Length in Seconds" and "Maximum Session Idle Time in Seconds" without using the LOV, simply typed some huge numbers and saved with "Apply Changes". (This can be done in Home>Manage Instance>Security>Session Timeout)
Don't know what happened with this values in the database, I searched for them but couldn't find them, but since this change I cannot login as workspace admin anymore.
The error is 404 not found "The requested URL /apex/f was not found on this server".
Some lines from one of the traces in bdump (DB_s001_18957.trc) which may give a clue for someone who knows more about the internals of wwv_flow:
...
Embedded PL/SQL Gateway: HTTP_REFERER(13)=(59)http://server:7070/apex/f?p=4550:1:3062356472748196
Embedded PL/SQL Gateway: WEB_AUTHENT_PREFIX(19)=(1)
Embedded PL/SQL Gateway: DAD_NAME(9)=(5)apex
Embedded PL/SQL Gateway: DOC_ACCESS_PATH(16)=(5)docs
Embedded PL/SQL Gateway: DOCUMENT_TABLE(15)=(23)wwv_flow_file_objects$
Embedded PL/SQL Gateway: PATH_ALIAS(11)=(1)
Embedded PL/SQL Gateway: REQUEST_CHARSET(16)=(9)AL32UTF8
Embedded PL/SQL Gateway: REQUEST_IANA_CHARSET(21)=(6)UTF-8
Embedded PL/SQL Gateway: SCRIPT_PREFIX(14)=(1)
*** ACTION NAME:(PAGE 3) 2011-06-05 21:47:23.396
*** MODULE NAME:(APEX:APPLICATION 4050) 2011-06-05 21:47:23.396
*** CLIENT ID:(ADMIN:3062356472748196) 2011-06-05 21:47:23.396
Embedded PL/SQL Gateway: /apex/f HTTP-404 ORA-20867: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "APEX_040000.WWV_FLOW", line 10704
ORA-06512: at "APEX_040000.F", line 267
ORA-06512: at "APEX_040000.F", line 294
ORA-06512: at line 32
Embedded PL/SQL Gateway: (wpu.c,627) longjumping back to the beginning
Embedded PL/SQL Gateway: (wpu.c,489) cleaning up before longjmp
Embedded PL/SQL Gateway: (wpu.c,493) doing a rollback
Embedded PL/SQL Gateway: (wpcs.c, 76) Executed 'rollback' (rc=0)
Embedded PL/SQL Gateway: (wpcs.c, 76) Executed 'begin dbms_session.reset_package; end;' (rc=0)
Embedded PL/SQL Gateway: (wpd.c,1818) Going to close cursor
Embedded PL/SQL Gateway: (wpx.c,688) Shutdown has been called
Embedded PL/SQL Gateway: (wpx.c,700) Going to logoff
---
Following tables I've checked for timeout values, but couldn't find any "wrong" number.
APEX_040000.APEX_APPLICATIONS (MAXIMUM_SESSION_LIFE_SECONDS, MAXIMUM_SESSION_IDLE_SECONDS)
APEX_040000.WWV_FLOWS(MAX_SESSION_LENGTH_SEC,MAX_SESSION_IDLE_SEC)
APEX_040000.WWV_FLOW_STEPS(CACHE_TIMEOUT_SECONDS)
--
As the body of "APEX_040000.WWV_FLOW" is wrapped I have no idea what's at line 10704. Otherwise it would be easy to find out which statement is crashing.
Any help is appreciated.
Thanks
Helmut

Edited by: user10508411 on 06.06.2011 21:58
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2011
Added on Jun 5 2011
2 comments
1,361 views