Page Errors

no data found

An easy overview of things that went wrong recently during the use of this site.
Usually this is caused by things I changed, so I have added the Last Error Occurred column to check that easily.

Note that the ted_access_log.bot_pk_id function used in the query is a function I created to detect webcrawlers and bots - I don't really care which errors they get because they almost always cause those errors themselves by using old/weird URLs.
Take a look at my Statistics page for more info on that subject.

Page

Identification
	Page ID	4
	Name	Page Errors
	Page Alias	PAGE-ERRORS

Region

Identification
	Sequence	10
	Title	Page Errors
	Type	Report
Source
	Source Type	SQL_QUERY
	Table Name	TED_P0004_V

View

View
	Name	TED_P0004_V
	DDL	with iv_bot as (select ip_address ,agent ,ted_access_log.bot_pk_id(p_ip_address => ip_address, p_user_agent => agent) as bot_pk_id from (select distinct t.ip_address ,t.agent from apex_workspace_activity_log t where t.workspace = 'TEDSTRUIK' and t.application_id = nvl(v('APP_ID'), 25384) and t.error_message is not null)), iv_a as (select t.view_date ,p.last_updated_on ,t.page_id ,t.page_name ,t.log_context ,t.error_message ,t.error_on_component_type ,t.error_on_component_name ,t.agent ,t.debug_page_view_id ,iv_bot.bot_pk_id from apex_workspace_activity_log t join apex_application_pages p on (p.workspace = t.workspace and p.application_id = t.application_id and p.page_id = t.page_id) left join iv_bot on (iv_bot.ip_address = t.ip_address and nvl(iv_bot.agent, 'x') = nvl(t.agent, 'x')) where t.workspace = 'TEDSTRUIK' and t.application_id = nvl(v('APP_ID'), 25384) and t.page_id < 9000 -- exclude test pages and t.error_message is not null and t.error_message not like '%Note: End users get a different error message.%' -- Errors during development in Apex Builder and t.error_on_component_type not in ('APEX_APPLICATION_AUTH') -- Session expired and t.error_message not like '% must have some value.' -- Items with Value Required and not (t.page_id = 2 and t.error_message = 'ORA-12725: unmatched parentheses in regular expression') -- typo in search field or possible hacking attempt and not (t.page_id = 1021 and t.error_on_component_type in ('WWV_FLOW_SECURITY')) -- Cannot reproduce but seems harmless, maybe expired session? and not (t.page_id = 1029 and t.error_on_component_type in ('WWV_FLOW_SECURITY')) -- Cannot reproduce but seems harmless, maybe expired session? and not (t.page_id = 1050 and t.error_message like 'APEX - ERR-1002 Unable to find item ID for item "&#x%') -- URLs with possible hacking attempt, like /f?p=25384:1050:0::NO::%27 and not (t.page_id = 1098 and t.error_on_component_type = 'report') -- User input error in where clause and not (t.page_id = 1107 and t.error_message like 'Unable to populate collection.%') -- Cannot reproduce, see page 1110 - ORA-00001: unique constraint (FLOWS_240100.WWV_FLOW_COLLECTIONS_UK) violated and t.error_message not like 'APEX - Session state protection violation: %' -- Most likely Bot activity and t.error_message not like 'APEX - Checksum format error - %' -- Most likely Bot activity and t.error_message not like 'APEX - Checksum content error - %' -- Most likely Bot activity and t.error_on_component_name <> 'worksheet ACTION FILTER UPDATE' -- User error in filter options and t.error_on_component_name <> 'worksheet ACTION FILTER ADD' -- User error in filter options and t.error_message not like '%Ensure the page template in use on page % is of template type "Dialog page"%' -- Trying to directly open a Dialog Page url (e.g. 1180) ) select max(iv_a.view_date) as date_last ,trim(abs(round((iv_a.last_updated_on - max(iv_a.view_date)) * 24 * 60))) \|\| ' minutes ' \|\| (case when max(iv_a.view_date) > iv_a.last_updated_on then 'AFTER' else 'before' end) \|\| ' last update' as last_error_occurred ,min(view_date) as date_first ,count(*) as n ,max(iv_a.debug_page_view_id) as debug_page_view_id ,iv_a.page_id ,iv_a.page_name ,iv_a.log_context ,iv_a.error_message ,iv_a.error_on_component_type ,iv_a.error_on_component_name from iv_a where iv_a.bot_pk_id is null -- ignore errors caused by silly bot requests group by iv_a.last_updated_on ,iv_a.page_id ,iv_a.page_name ,iv_a.log_context ,iv_a.error_message ,iv_a.error_on_component_type ,iv_a.error_on_component_name ,iv_a.bot_pk_id

Page Errors

Info

Code

Page

Region

View