Report not running [message #575900] |
Mon, 28 January 2013 23:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
snsiddiqui
Messages: 172 Registered: December 2008
|
Senior Member |
|
|
My report is not running, whenever I want to run HOUR GLASS comes. My code is
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
vParamValue number;
REP_PROPERTY VARCHAR2(100);
v_show_document VARCHAR2 (2000) := 'http://test1:8888/reports/rwservlet?';
v_connect VARCHAR2 (200) := 'userid=abc/abc123@laptop';
v_report_server VARCHAR2 (30) := 'rep_test1';
v_report_name VARCHAR2(100) := 'DAILYPRSNT';
v_format VARCHAR2(12) := 'PDF';
BEGIN
plid := Get_parameter_List('tmp');
IF NOT Id_Null(plid) THEN
Destroy_parameter_List( plid );
END IF;
plid :=Create_parameter_List('tmp');
repid := FIND_REPORT_OBJECT(v_report_name);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_FILENAME, v_report_name);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,cache);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_report_server);
v_rep := RUN_REPORT_OBJECT(repid,v_report_server);
rep_status := REPORT_OBJECT_STATUS(v_rep);
message('1 '||rep_status);message('1 '||rep_status);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(v_rep);
END LOOP;
v_show_document := v_show_document|| v_connect|| '&server='|| v_report_server|| '&report='||v_report_name|| '&destype=CACHE'|| '&desformat='||v_format|| '¶mform=yes' ;
if rep_status = 'FINISHED'then
pause;
message('Finished');
web.show_document(v_show_document,'_blank');
else
message ( 'error while running reports-object ' || error_text );message ( ' ' );
clear_message;
end if;
END;
|
|
|
|
|
Re: Report not running [message #575948 is a reply to message #575911] |
Tue, 29 January 2013 12:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
It sounds like maybe the report server is not running. Do other reports run?
If the report server is running, the best thing to do is go to the URL for your reports server status and there will be a red X on the report you just ran. Click on the X and you'll get more info. It always helps me.
The url will be something like:
http://<server>:<port>/reports/rwservlet/showjobs?queuetype=past&server=<report server name>
|
|
|