My Oracle Support Banner

Get Publisher Web Service With Apex_web_service.make_request Get ORA-29276 Timeout (Doc ID 2456579.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Application Express (APEX) - Version 5.0.2.00 and later
Information in this document applies to any platform.

Symptoms

A report has been created with a long query time: for example 200 seconds. The code is:

SET SERVEROUTPUT ON SIZE UNLIMITED
declare
  l_xml xmltype;
  l_url varchar2(4000);
  l_env clob;
begin
utl_http.set_transfer_timeout (4000);
l_env :='
  
  
  
  
  pdf
----
  
  
';

  l_url := 'http://<ipaddress>';

  l_url := l_url||':<port>';

  
  l_url := l_url||'/xmlpserver/services/v2/ReportService';
  l_xml := apex_web_service.make_request( p_url => l_url, p_envelope => l_env );

end;

After 180 seconds, the following error occurs:


ORA-29273: échec de demande HTTP
ORA-29276: expiration du transfert
ORA-06512: à "APEX_050000.WWV_FLOW_WEBSERVICES_API", ligne 172
ORA-06512: à ligne 30
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
  Fix the error and retry the HTTP request.

How do your resolved this timeout error when using the APEX_WEB_SERVICE API?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.