Home » Developer & Programmer » Reports & Discoverer » report 6i problem
report 6i problem [message #144933] |
Sat, 29 October 2005 01:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
humayun116
Messages: 9 Registered: October 2005
|
Junior Member |
|
|
hello all,
i am using windows xp and oracle 6i& 8i.
my problem is that when i run a report from any form, first time it is executed well and reports background engine is opened.After closing this report when we execute a new report it is hanged and i could not any work. but when i close reports background engine and execute any report it takes some time but its result is ok.
please help me to solve this problem as early as possible.
thanking you in anticipation,
from
Humayun (multan Pakistan)
|
|
|
|
|
Re: report 6i problem [message #148729 is a reply to message #144933] |
Sun, 27 November 2005 05:46 ![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) |
sandeepludhianvi
Messages: 1 Registered: November 2005
|
Junior Member |
|
|
hI DEAR, I have read in orafaq.com that you have been facing a problem regarding Reports in 6i that whenever Engine is opened the system gets hang else Report opens very late. I am just a oracle developer from INDIA and having the same problem. If you have got any solution then please heal me too. I'll be very grateful. If you have any other problem or Tricks to be discussed then You may use my e-mail id: sandeepludhianvi@rediffmail.com , I would be very happy after seeing you in my inbox.
|
|
|
Re: report 6i problem [message #148898 is a reply to message #148489] |
Mon, 28 November 2005 23:28 ![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) |
humayun116
Messages: 9 Registered: October 2005
|
Junior Member |
|
|
hello all,
special for Ashraf_arif59 and Sandeepludhianvi
My dear friends i solved my problem just temporary by using ORACLE_SHUTDOWN parameter to close the report engin, on my pc.After report execution this code close the report background engin automatically before execution of another report.but it takes huge time to formating or execution of report becoze this code close report background engin every time.this is better to nothing.this code is given below...
begin
pl_id:=get_parameter_list('tempdata');
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id:=create_parameter_list('tempdata');
add_parameter(pl_id,'ORACLE_SHUTDOWN',text_parameter,'yes');
run_product(reports,'test',synchronous,runtinme,filesystem,pl_id,");
end;
mr.sandeepludhianvi i will contact u if any problem thanks,
with best wishes,
bye
from humayun
|
|
|
Re: report 6i problem [message #148905 is a reply to message #148489] |
Mon, 28 November 2005 23:50 ![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) |
humayun116
Messages: 9 Registered: October 2005
|
Junior Member |
|
|
hello all,
special for Ashraf_arif59 and Sandeepludhianvi
My dear friends i solved my problem just temporary by using ORACLE_SHUTDOWN parameter to close the report engin, on my pc.After report execution this code close the report background engin automatically before execution of another report.but it takes huge time to formating or execution of report becoze this code close report background engin every time.this is better to nothing.this code is given below...
begin
pl_id:=get_parameter_list('tempdata');
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id:=create_parameter_list('tempdata');
add_parameter(pl_id,'ORACLE_SHUTDOWN',text_parameter,'yes');
run_product(reports,'test',synchronous,runtinme,filesystem,pl_id,");
end;
mr.sandeepludhianvi i will contact u if any problem thanks,
with best wishes,
bye
from humayun
|
|
|
Re: report 6i problem [message #148948 is a reply to message #148905] |
Tue, 29 November 2005 03:21 ![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) |
ashraf_arif59
Messages: 35 Registered: March 2005 Location: Pakistan
|
Member |
![ashraf_arif59](/forum/theme/orafaq/images/yahoo.png)
|
|
Mr humayun:
that great idea to close the engine. but there is again other problem, that when we again call the report, first the engine start and take some time then the report come.
the client didnot want that solution that take time.
i want the solution to engine should be open
becuase if the engine open the speed of calling of report will be fast. how can it happen
plz give me the solution
and i want the the built in parameter of report
like
parameter value
oracle_shutdown yes
maximze yes
plz if some one have any knowledge about these parameter
plz tell me
[Updated on: Tue, 29 November 2005 05:35] Report message to a moderator
|
|
|
Re: report 6i problem [message #149088 is a reply to message #148948] |
Wed, 30 November 2005 00:27 ![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) |
humayun116
Messages: 9 Registered: October 2005
|
Junior Member |
|
|
dear fried ashraf,
when i reply u i tell that due to oracle_shutdown code report will take huge time to execute.i am also facing same problem like you. i am searching but failed. in my opinon it is a 6i problem it will remove after downloading a special patch of oracle that i could not have.
sorry for this i can not help when i recover this fault then i will help you happily.i am searching again and again on many forums but failed this time.
if you succeed befor me plz tell me about this.i will thankfull to you.
best of luck,
allah hafiz
humayun
|
|
|
Re: report 6i problem [message #149093 is a reply to message #148948] |
Wed, 30 November 2005 00:54 ![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) |
humayun116
Messages: 9 Registered: October 2005
|
Junior Member |
|
|
mr.ashraf
some code that i know about built in parameter of report is given below that will helpfull for u is given below...
declare
pl_id ParamList;
FileExt varchar2(10);
od varchar2(17);
a varchar2(10);
BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
--this will close the report background engin after execution
add_parameter(pl_id,'ORACLE_SHUTDOWN',text_parameter,'yes');
--this will pass the values of forms fields to reports parameter
Add_Parameter(pl_id, 'type', TEXT_PARAMETER, :type);
Add_Parameter(pl_id, 'ph_no', TEXT_PARAMETER,:ph_no);
---this code will maximize the report preview
Add_Parameter(pl_id, 'maximize',TEXT_PARAMETER, 'YES');
Run_Product(REPORTS, :parameter.report_name, SYNCHRONOUS, RUNTIME,FILESYSTEM,
pl_id, NULL);
END;
from humayun
|
|
|
Re: report 6i problem [message #152768 is a reply to message #149093] |
Tue, 27 December 2005 00:05 ![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) |
ashraf_arif59
Messages: 35 Registered: March 2005 Location: Pakistan
|
Member |
![ashraf_arif59](/forum/theme/orafaq/images/yahoo.png)
|
|
Mr.humayun
thanx for giving me the instruction about the parameters
all these parameter are going well except this one
DECLARE
PL_ID PARALIST;
BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
Add_Parameter(pl_id, 'maximize',TEXT_PARAMETER, 'YES');
Run_Product(REPORTS,'ITEM_info.rep', SYNCHRONOUS,RUNTIME,FILESYSTEM, pl_id, NULL);
end;
is not working yet
plz give me the guidness how i maximize the report
|
|
|
Re: report 6i problem [message #152951 is a reply to message #152768] |
Wed, 28 December 2005 01:47 ![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) |
humayun116
Messages: 9 Registered: October 2005
|
Junior Member |
|
|
dear Mr.Ashraf_arif,
plz use this code which is tested by me and i hope that will work properly.in this code i use create_parameter_list('tempdata') instead of get_parameter_list('tempdata').
----------------------
DECLARE
pl_id PARAMLIST;
BEGIN
IF ID_NULL(PL_ID) THEN
pl_id := create_PARAMETER_LIST('tempdata');
add_parameter(PL_ID,'DATE2',text_parameter,:DATE);
add_parameter(PL_ID,'REGION',text_parameter,:RCODE);
add_parameter(PL_ID,'TERRITORY',text_parameter,:TCODE);
add_parameter(PL_ID,'CUSTOMER',text_parameter,:CUST_CODE);
Add_Parameter(pl_id, 'maximize',TEXT_PARAMETER, 'YES');
Run_Product(REPORTS, 'f:\SALE_SALE_RETURN_LTR222.rep', SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);
END IF;
destroy_parameter_list(PL_ID);
END;
----------------------------------------------------------
and plz tell me about ur problem as you say
(report engine take some time then the report come.the client didnot want that solution that take time.i want the solution to engine should be open).
plz help me if u have some idea to solve this problem.i have also same problem like your problem.
from
humayun tanveer
|
|
|
|
Re: report 6i problem [message #155315 is a reply to message #154406] |
Fri, 13 January 2006 16:48 ![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) |
RJ.Zijlstra
Messages: 104 Registered: December 2005 Location: Netherlands - IJmuiden
|
Senior Member |
|
|
The changing of the initora parameter 'OPEN_CURSORS' to 10000 is not a solution. The real problem is that the background engine is not correctly closing all open cursors. If you change from 300 to 10000, and you have a 24/7 db, you only postpone the problem.
We ran into the same problem, and the only solution that worked, was -as mentioned before in the replies- to shutdown the background engine by submitting 'SHUTDOWN=YES'
The remark about the speed of the report is in my eyes quite simple to solve: buy a state of the art network, computer etc. ( Do not try to buy cheap...)
The speed has nothing to do with the mentioned problems.
HTH
|
|
|
Re: report 6i problem [message #158633 is a reply to message #154406] |
Mon, 13 February 2006 12:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
dukemax
Messages: 1 Registered: February 2006
|
Junior Member |
|
|
Beware that having an open_cursors parameter at 10000 could possibly lead you to a huge amount of open cursors, which could rapidly consume your process memory.
About the ORACLE_SHUTDOWN parameter, has anyone used it on Forms/Reports 6? I've been using it in Forms/Reports 6i without any problems, but it is simply ignored when I call a report from a version 6 form. Could this be a bug I could overcome with applying any patches or an incompatibility with of this parameter to Forms/Reports 6?
Thsnk you in advance!
|
|
|
Goto Forum:
Current Time: Sat Sep 07 10:43:37 CDT 2024
|