|
|
Re: Form hangs when opening a Report [message #398349 is a reply to message #398343] |
Thu, 16 April 2009 01:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #398359 is a reply to message #398357] |
Thu, 16 April 2009 01:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #398409 is a reply to message #398403] |
Thu, 16 April 2009 03:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.).
|
|
|