ORA-29276: 'Transfer Timeout' When Calling Report Via Event-Driven Publishing API (Doc ID 262163.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Reports Developer - Version 9.0.2.3 and later
Information in this document applies to any platform.




Symptoms

Using the Oracle Reports Event-Driven Publishing API the PL/SQL always fails with the following error stack e.g

ERROR at line 1:
ORA-20002: ORA-20212:
ORA-06512: at "TESTREP.SRW", line 622
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1665
ORA-29276: transfer timeout
ORA-06512: at line 82

The SQL script contain, for example, the following code:

DECLARE
myPlist SRW_PARAMLIST;
myIdent SRW.Job_Ident;
BEGIN
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
srw.add_parameter(myPlist,'GATEWAY','http://mymachine.domain:portno/reports/rwservlet');
srw.add_parameter(myPlist,'SERVER','rep_myserver');
srw.add_parameter(myPlist,'REPORT','/tmp/testrep.rdf');
srw.add_parameter(myPlist,'USERID','scott/tiger@mydbalias');
srw.add_parameter(myPlist,'AUTHID','orcladmin/pword');
srw.add_parameter(myPlist,'DESTYPE','file');
srw.add_parameter(myPlist,'DESNAME','/tmp/test.txt');
myIdent := srw.run_report(myPlist);
END;

The report request completes ok, and output is produced

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms