| Report Engine Crashed [message #82773] |
Wed, 02 July 2003 09:42  |
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  |
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 #82864 is a reply to message #82784] |
Thu, 10 July 2003 02:27 |
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]].
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
