Hi there,
I might found a bug in the latest Apex version...?!
Cross applications I'm sometimes getting the error "ORA-02047: Teilnahme an begonnener verteilter Transaktion nicht möglich ORA-06512". Sometimes after trying to login to any application, sometimes after logging in and branching to another page.
If I logout from the Application Builder and refresh the page, the error is gone. Logging in to the Application Builder again and trying the next App, chances are good, that the error is back again.
If I, some how, managed to get over it (e.g. by re-login to Application Builder and Apps several times), the error doesn't occur for a long time, not later than the next day and it starts again...
1. is_internal_error: true
2. apex_error_code: APEX.UNHANDLED_ERROR
3. ora_sqlcode: -2047
4. ora_sqlerrm: ORA-02047: Teilnahme an begonnener verteilter Transaktion nicht möglich ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1278 ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1318 ORA-02047: Teilnahme an begonnener verteilter Transaktion nicht möglich ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1278 ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1285 ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1337 ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1350 ORA-06512: in "APEX_220100.WWV_FLOW_DEVELOPER_TOOLBAR", Zeile 321 ORA-06512: in "APEX_220100.WWV_FLOW_PAGE", Zeile 3697384048 ORA-06512: in "APEX_220100.WWV_FLOW_PAGE", Zeile 3310
5. component.type: APEX_APPLICATION_PAGES
6. component.id: 132000000002
7. component.name: xxx
8. error_backtrace:
ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1278
ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1318
ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1278
ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1285
ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1337
ORA-06512: in "APEX_220100.WWV_FLOW_JSON", Zeile 1350
ORA-06512: in "APEX_220100.WWV_FLOW_DEVELOPER_TOOLBAR", Zeile 321
ORA-06512: in "APEX_220100.WWV_FLOW_PAGE", Zeile 3697384048
ORA-06512: in "APEX_220100.WWV_FLOW_PAGE", Zeile 3310
ORA-06512: in "APEX_220100.WWV_FLOW", Zeile 3308
Apex Version is 22.1.1, DB is on 19.0.0.0.0.
Any ideas on that?
Kind regards,
Daniel