Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Report queries on Apex.oracle.com after upgrade to 22.1

Arjan GrunefeldApr 23 2022

Hi Sir/Madam,
I have a few xml rtf lay-outs working on Report Queries. After the upgrade to 22.1 they all give an error. When testing the report queries (not from the page i am using it) i get "ORA-29273: HTTP request failed". When I use it on the page where a call the report query i get a similar error message: But more detailed because i am a developer:

is_internal_error: true
apex_error_code: APEX.UNHANDLED_ERROR
ora_sqlcode: -29273
ora_sqlerrm: ORA-29273: HTTP-aanvraag is mislukt. ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 1182 ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 782 ORA-12541: TNS: geen listener. ORA-06512: in "SYS.UTL_HTTP", regel 380 ORA-06512: in "SYS.UTL_HTTP", regel 1148 ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 756 ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 1023 ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 1438 ORA-06512: in "APEX_220100.WWV_FLOW_WEBSERVICES_API", regel 612 ORA-06512: in "APEX_220100.WWV_FLOW_PRINT_UTIL", regel 789 ORA-06512: in "APEX_220100.WWV_FLOW_RENDER_QUERY", regel 1842 ORA-06512: in "APEX_220100.WWV_FLOW_RENDER_QUERY", regel 1930
component.type: APEX_APPLICATION_PAGES
component.id: 14973000000006
component.name: Zangdienst
error_backtrace:

ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 1182
ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 782
ORA-06512: in "SYS.UTL_HTTP", regel 380
ORA-06512: in "SYS.UTL_HTTP", regel 1148
ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 756
ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 1023
ORA-06512: in "APEX_220100.WWV_FLOW_WEB_SERVICES", regel 1438
ORA-06512: in "APEX_220100.WWV_FLOW_WEBSERVICES_API", regel 612
ORA-06512: in "APEX_220100.WWV_FLOW_PRINT_UTIL", regel 789
ORA-06512: in "APEX_220100.WWV_FLOW_RENDER_QUERY", regel 1842
ORA-06512: in "APEX_220100.WWV_FLOW_RENDER_QUERY", regel 1930
ORA-06512: in "APEX_220100.WWV_FLOW", regel 2980

Is this report query print server xml publisher feature shut down? Or has Oracle forgotten something when upgrading and is Oracle still working on it?
I Hope I was clear and it wil be solved.
Kind Regards
Arjan Grunefeld

Comments
Post Details
Added on Apr 23 2022
8 comments
999 views