This content has been marked as final. Show 8 replies
yes u can trace the log massages
Edited by: Ramani_vadakadu on Apr 10, 2013 3:14 PM
SELECT * FROM apex_workspace_access_log OR connect with another schema if you have apex 4.2 login as user/password= APEX_040200/apex and check the table WWV_FLOW_DEBUG_MESSAGES IN apex screen: Home>Administration>Monitor Activity>Login Attempts/Application Errors
I would like to know if session state protection errors are logged any where.
I don't know if they are logged anywhere and I can't expect them in version 3.2
However you can do it by yourself easily. In Authorization Scheme, you can just include an INSERT statement (to capture user details, session details etc.) just before returning FALSE.
Edited by: Hari_639 on Apr 23, 2013 3:08 PM
Check the ERROR_MESSAGE in the APEX_WORKSPACE_ACTIVITY_LOG view.1 person found this helpful
I just tried this.
I altered the url to a page that I should not be able to access. I got the error page, as expected with the authorization error message.
I queried the APEX_WORKSPACE_ACTIVITY_LOG, but no error message
Hello Gus,1 person found this helpful
I just tried altering url for SSP enabled page. Yes, it's not logging error, but logging access info with-out error message. Strange!
I have just checked the table behind the view, APEX_040000.WWV_FLOW_ACTIVITY_LOG2$ and it has column as SQLERRM. So it looks like it only logs "un-handled exceptions that will be raised to APEX from any of page processes or computations or SQL Queries"
Am I correct to say that, out of the box, it does not log authorization errors or ssp errors.
I think this would be a good idea to have this information, but then you could quickly identify any authorization problems or
users who are playing with the url's
I have logged a feature request.
Thanks for the information