Home » Developer & Programmer » Forms » Report not running (Reports9i, windows)
Report not running [message #575900] Mon, 28 January 2013 23:49 Go to next message
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|| '&paramform=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 #575901 is a reply to message #575900] Mon, 28 January 2013 23:58 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you remove the WHILE loop?
Re: Report not running [message #575911 is a reply to message #575901] Tue, 29 January 2013 01:01 Go to previous messageGo to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
Rightnow I didn't remove the while loop and after a long wait message appear

FRM-41214: Unable to run report
Re: Report not running [message #575948 is a reply to message #575911] Tue, 29 January 2013 12:43 Go to previous message
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>
Previous Topic: ora-12703 this character set conversion is not supported
Next Topic: Can we call Procedure from One Object Library to Another Object library
Goto Forum:
  


Current Time: Fri Apr 26 02:29:15 CDT 2024