Home » Developer & Programmer » Forms » Report Engine Crashed
Report Engine Crashed [message #82773] Wed, 02 July 2003 09:42 Go to next message
Amir Khan
Messages: 3
Registered: July 2003
Junior Member
my prb is when i run a report and report engine is close it will run ok but whenever report engine already open report engine will crash down.

Form version is 6.0.8.8.3
Report version is 6.0.8.8.3

We are using the following procedue in our form builder files to call a report :

Add_Parameter(pl_id,'FROM_DATE',TEXT_PARAMETER,to_char( :OP_LOG.FROM_DATE, 'dd/mm/yyyy'));

Add_Parameter(pl_id,'TO_DATE',TEXT_PARAMETER,to_char( :OP_LOG.TO_DATE, 'dd/mm/yyyy'));

Add_Parameter(pl_id,'SECURITY',TEXT_PARAMETER,:OP_LOG.ISIN_POPLIST);

Add_Parameter(pl_id,'P_SECURITY_DESC',TEXT_PARAMETER,V_SECURITY_NAME);

Add_Parameter(pl_id,'P_WHERE_CLAUSE',TEXT_PARAMETER,CLAUSE);

--Launch the report

Launch_Report('ANNOUNCEMENT_DETAIL', pl_id);

--Launch_Report Method

PROCEDURE Launch_Report(report_name varchar2, pl_id ParamList) IS

BEGIN

Run_Product(REPORTS, report_name, ASYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);

END;
Re: Report Engine Crashed [message #82780 is a reply to message #82773] Thu, 03 July 2003 05:59 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
that problem happens ofthen,
uninstall reports, clean the registry [[reportpath]]
reinstall the reports.
do not run any oracle products while installing.
maybe there might be a patch about this problem also.
Re: Report Engine Crashed [message #82783 is a reply to message #82780] Thu, 03 July 2003 06:27 Go to previous messageGo to next message
Amir Khan
Messages: 3
Registered: July 2003
Junior Member
Thanks for your reply, I will check it with reinstalling report runtime, meanwhile would you pls tell me exact patch which should i apply.
Re: Report Engine Crashed [message #82784 is a reply to message #82783] Thu, 03 July 2003 08:46 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
i wrote there might be a patch wich means i dont know if there is a patch
you could ask that at the www.metalink.com
Re: Report Engine Crashed [message #82864 is a reply to message #82784] Thu, 10 July 2003 02:27 Go to previous message
Amir Khan
Messages: 3
Registered: July 2003
Junior Member
I have applied patch 14. Now the error is being produced are

Starting report Daily_Trade_List [[Thu Jul 10 12:57:51 2003]] ...
REP-1401: 'f_company_sec2formattrigger': Fatal PL/SQL error occurred.
ORA-06508: PL/SQL: could not find program unit being called

REP-0594: No report output generated.
End report Daily_Trade_List [[Thu Jul 10 12:57:56 2003]].
Previous Topic: password checking in Forms
Next Topic: fucntion of do_key
Goto Forum:
  


Current Time: Sat Mar 02 19:32:38 CST 2024