We just upgraded Apex from 21.2 to 23.1 and all the report subscriptions are errored as follow.
It seem that wwv_flow_sessions$ and wwv_flow_data are not copied properly.
Is there a reason ? Can I jest copy the data between the APEX schemas ?
report subscription log:
06/15/2023 15:00:01 ORA-20987: APEX - Your session has ended. - Contact your application administrator. Details about this incident are available via debug id "173163".
For the Debug id:
Error: Your session has ended.
- Additional info: Contact your application administrator.
Details about this incident are available via debug id "173162".
- 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: true
- APEX error code: APEX.SESSION.EXPIRED
- SQL code: 100
- SQL error: ORA-01403: no data found
- Backtrace: ORA-06512: at "APEX_230100.WWV_FLOW_SESSION", line 2602
- Statement:
- Component: APEX_APPLICATION_PAGES שורות הזמנות (103000000011)