Greetings,
Something has happened to my APEX installation which causes an error every time I want to edit a page.
When I made a new page, I accidentally entered a page number “8`1” instead of “81”. But I do not know if this is the cause of the problem.
When I edit any page, even existing ones, I get no clear error:
1 error has occured
* Error:
The page is missing a template.
I am on:
APEX Version=23.2.6
Patch Version=6
If I check the log I get the following:
Error: Error processing validation.
- Additional info: Contact your application administrator.
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: APEX.VALIDATION.UNHANDLED_ERROR
- SQL code: -1722
- SQL error: ORA-01722: Ongeldig getal
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1618
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2132
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_230200", regel 820
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1570
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1660
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1427
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 238
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 907
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 907
- Backtrace: ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2132
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_230200", regel 820
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1570
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1618
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2132
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_230200", regel 820
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1570
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1660
ORA-06512: in "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", regel 1427
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 238
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 907
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 907
ORA-06512: in "APEX_230200.WWV_FLOW_VALIDATION", regel 1111
- Statement: select count(*) from sys.dual where exists (select 1
from wwv_flow_steps
where flow_id = :FB_FLOW_ID
and security_group_id = :WORKSPACE_ID
and id = :P2501_PAGE_ID
)
- Component: APEX_APPLICATION_PAGE_VAL Page Number does not exists (12403573232612930)
Has anybody have any idea where to look or how to correct this error?