Home » Developer & Programmer » Reports & Discoverer » Form hangs when opening a Report (Forms & Reports 10g)
icon13.gif  Form hangs when opening a Report [message #398309] Thu, 16 April 2009 00:25 Go to next message
Blade83
Messages: 5
Registered: April 2009
Junior Member
I'm trying to call a report using a button in a form. The form hangs. I'm not passing any variables.

Reports Server shows the below status:

Terminated with error: <br>REP-1212: Object 'M_G_ASSETTAGNO_GRPFR' is not fully enclosed by its enclosing object 'Body'.

The same problem was reported here
http://www.orafaq.com/forum/m/341962/0/?srch=form+hangs#msg_341962
Re: Form hangs when opening a Report [message #398343 is a reply to message #398309] Thu, 16 April 2009 01:25 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Report seems to be invalid. How did you manage to compile it? Such an error prevents report to be executed so - perhaps you should review its design. Pay attention to M_G_ASSETTAGNO_GRPFR frame.
Re: Form hangs when opening a Report [message #398349 is a reply to message #398343] Thu, 16 April 2009 01:42 Go to previous messageGo to next message
Blade83
Messages: 5
Registered: April 2009
Junior Member
I created a simple report with the statement, SELECT SYSDATE FROM DUAL, I compiled the report and everything was ok.

I'm using following code in calling button in form.

DECLARE
   PL_ID PARAMLIST;
   repid report_object;
   v_rep varchar2(100);
   Rep_Status varchar2(500);
begin
	
	select global_server,global_port,global_report_server 
	into :global.server,:global.port,:global.report_server from system_global;
	
	IF NOT ID_NULL(PL_ID) THEN
    DESTROY_PARAMETER_LIST(PL_ID);
 	END IF;
	repid := FIND_REPORT_OBJECT('EMPDATA');
  PL_ID := CREATE_PARAMETER_LIST('TMPDATA');
  Set_Report_Object_Property(repid, REPORT_EXECUTION_MODE, RUNTIME);
	Set_Report_Object_Property(repid, REPORT_SERVER, :global.report_server);
	Set_Report_Object_Property(repid, REPORT_DESFORMAT, 'SPREADSHEET');

  ADD_PARAMETER(PL_ID,'PARAMFORM',      TEXT_PARAMETER, 'NO');
  ADD_PARAMETER(PL_ID,'ORACLE_SHUTDOWN',TEXT_PARAMETER, 'YES');
 
	v_rep := RUN_REPORT_OBJECT(repid,PL_ID);
 	
 	WHILE Rep_Status IN ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
		Rep_Status := REPORT_OBJECT_STATUS(v_rep);
 	END LOOP;
 	
	IF rep_status='FINISHED' THEN
	WEB.SHOW_DOCUMENT(:global.server||:global.port
	||'/reports/rwservlet/getjobid' || substr(v_rep, length(:global.report_server) + 2, length(v_rep)) 
	|| '?server='|| :global.report_server);
	END IF;

	DESTROY_PARAMETER_LIST(PL_ID);
  
	EXCEPTION
		WHEN OTHERS THEN
		message(sqlerrm);
		message(' ');
END;	
	
Re: Form hangs when opening a Report [message #398357 is a reply to message #398349] Thu, 16 April 2009 01:55 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did your "simple report" got a frame named M_G_ASSETTAGNO_GRPFR? Wizard doesn't do that so - are you sure that you are calling that very "simple report"?
Re: Form hangs when opening a Report [message #398359 is a reply to message #398357] Thu, 16 April 2009 01:59 Go to previous messageGo to next message
Blade83
Messages: 5
Registered: April 2009
Junior Member
Hi Littlefoot, I couldn't find out what was the problem with M_G_ASSETTAGNO_GRPFR. I looked normal to me. then after your reply I created another report with the above statement and tried to call it from form.
Re: Form hangs when opening a Report [message #398363 is a reply to message #398359] Thu, 16 April 2009 02:02 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see ... so, what has happened? Did that simple report run correctly?
Re: Form hangs when opening a Report [message #398365 is a reply to message #398363] Thu, 16 April 2009 02:06 Go to previous messageGo to next message
Blade83
Messages: 5
Registered: April 2009
Junior Member
It didn't.
Re: Form hangs when opening a Report [message #398403 is a reply to message #398365] Thu, 16 April 2009 02:55 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
And the error was ...?

P.S. Remove WHEN OTHERS exception handling section. It does nothing but hides useful information.

[Updated on: Thu, 16 April 2009 02:56]

Report message to a moderator

Re: Form hangs when opening a Report [message #398409 is a reply to message #398403] Thu, 16 April 2009 03:10 Go to previous messageGo to next message
Blade83
Messages: 5
Registered: April 2009
Junior Member
Here is the status of the report with statement, SELECT SYSDATE FROM DUAL;

Job status: Waiting in the queue. Please wait.
Please wait while your job is processed. Otherwise, you may return to the job list by clicking on the link below.
Re: Form hangs when opening a Report [message #398413 is a reply to message #398409] Thu, 16 April 2009 03:31 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Job is waiting in the queue ... why did that happen, I wouldn't know, sorry. Is there any administrator there who might take a look? Or, if you know how to do that, see what is going on (for example, is the queue stopped, stalled for some reason, etc.).
Previous Topic: discoverer
Next Topic: Page Break Qtn
Goto Forum:
  


Current Time: Thu Dec 08 02:21:56 CST 2016

Total time taken to generate the page: 0.16320 seconds