REP-52251 and REP-56033 Errors When Calling Reports From Forms With RUN_REPORT_OBJECT Against a Reports Cluster in 11g. (Doc ID 1074804.1)

Last updated on MAY 22, 2017

Applies to:

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

***Checked for relevance on 21-Dec-2015***


Symptoms

Calling Oracle Reports from Oracle Forms with RUN_REPORT_OBJECT and WEB.SHOW_DOCUMENT built-ins and using server=<Reports Server Cluster Name> when executing getjobid command is displaying the following intermittent error. Intermittent here means that sometimes the report output is being displayed fine but sometimes the REP errors are displayed.

REP-52251: The output of job ID XXXX requested on Mon XXXX cannot be retrieved. REP-56033: Job XXXX does not exist.
Forms Code Sample
declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(50);
BEGIN
repid := find_report_object('<report object>');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'<Reports Server Cluster Name>');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
message(v_rep);
IF rep_status = 'FINISHED' THEN
/*Display report in the browser*/
WEB.SHOW_DOCUMENT('http://<hostname>:<port>/reports/rwservle/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=<Reports Server Cluster Name>','_blank');
ELSE
message('Error when running report');
END IF;
END;

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