Oracle Reports Error

[Guest]

I was having some trouble with Oracle reports and was wondering if you
can shed some light....

I am displaying 70,000 records amounting to a pdf file of size 15 MB on
internal MPL server using Oracle Reports. Now when I run it on unix
server using rwrun60 it crashed and gives the no errors and no output
pdf file. If I reduce the number of records to 500 everything works
fine on UNIX too(gives me the desired pdf report)Can anybody point out
in right direction.
CODE
====
$dir_dest = "../pdf/";
$report_name=chris_carl_nco;
$file_path = $dir_dest.$report_name.".pdf";
$connect_info = "ABC/ABC\@XYZ";
$ENV{'ORACLE_HOME'}="/thishost/unix/db/dev2k_6.0";
$ENV{'PATH'} =
"$ENV{'ORACLE_HOME'}/bin/:/opt/SUNWSpro/bin:/usr/bin:/usr/openwin
/lib:/etc:/usr/local/bin:/usr/sbin/bin:/usr/ucb:/usr/dt/lib:/usr/ccs/bin";
$ENV{'LD_LIBRARY_PATH'} =
"$ENV{'ORACLE_HOME'}/lib:/usr/lib:/usr/openwin/lib:/us
r/ccs/lib:/usr/dt/lib";
$system_command = "rwrun60 ".
" REPORT=../reports/$report_name".".rdf" .
" DESNAME=$file_path".
" DESFORMAT=pdf" .
" DESTYPE=file" .
" PRINTJOB=NO" .
" BATCH=YES" .
" PARAMFORM=NO" .
" USERID=$connect_info";
system "$system_command";

[Yuri Ivanov]

Hi!
I can advide you only to explore core file from crashed rwrun60 :(
And check the logs, you can find it by tracing rwrun60 :(


mannysingla@gmail.com пишет: I was having some trouble with Oracle reports and was wondering if you can shed some light.... I am displaying 70,000 records amounting to a pdf file of size 15 MB on internal MPL server using Oracle Reports. Now when I run it on unix server using rwrun60 it crashed and gives the no errors and no output pdf file. If I reduce the number of records to 500 everything works fine on UNIX too(gives me the desired pdf report)Can anybody point out in right direction. CODE ==== $dir_dest = "../pdf/"; $report_name=chris_carl_nco; $file_path = $dir_dest.$report_name.".pdf"; $connect_info = "ABC/ABC\@XYZ"; $ENV{'ORACLE_HOME'}="/thishost/unix/db/dev2k_6.0"; $ENV{'PATH'} = "$ENV{'ORACLE_HOME'}/bin/:/opt/SUNWSpro/bin:/usr/bin:/usr/openwin /lib:/etc:/usr/local/bin:/usr/sbin/bin:/usr/ucb:/usr/dt/lib:/usr/ccs/bin"; $ENV{'LD_LIBRARY_PATH'} = "$ENV{'ORACLE_HOME'}/lib:/usr/lib:/usr/openwin/lib:/us r/ccs/lib:/usr/dt/lib"; $system_command = "rwrun60 ". " REPORT=../reports/$report_name".".rdf" . " DESNAME=$file_path". " DESFORMAT=pdf" . " DESTYPE=file" . " PRINTJOB=NO" . " BATCH=YES" . " PARAMFORM=NO" . " USERID=$connect_info"; system "$system_command";