Page Errors

Search For

Date First	Date Last	Last Error Occurred	N	Page ID	Page Name	Log Context	Error Message	Error On Component Type	Error On Component Name
2024-04-24 09:57:16	2024-04-24 09:57:16	220238 minutes AFTER last update	1	1107	Apex - General - Database Dependencies	APEX - GENERAL - DATABASE DEPENDENCIES	Unable to populate collection. Contact your application administrator. Details about this incident are available via debug id "544055".	APEX_APPLICATION_PAGE_PROCESS	populate collection
2024-04-24 09:56:57	2024-04-24 09:56:57	220237 minutes AFTER last update	1	1107	Apex - General - Database Dependencies	APEX - GENERAL - DATABASE DEPENDENCIES	Unable to populate collection. Contact your application administrator. Details about this incident are available via debug id "544054".	APEX_APPLICATION_PAGE_PROCESS	populate collection

row(s) 1 - 2 of 2

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 ,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.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 not (t.page_id = 1098 and t.error_message in ('ORA-00936: missing expression')) -- User input error, nothing to do and t.error_message not like '% must have some value.' -- Items with Value Required 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 t.error_message not like 'APEX - Session state protection violation: This may be caused by manual alteration of a URL containing a checksum or by using a link with an incorrect or missing checksum.%' -- Most likely Bot activity ) 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(iv_a.view_date) as date_first ,count(*) as n ,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