Strange. Have you tried activating SQL logging on the server to see what's
happening there? Can you retrieve the file using the User Tool? I know that
you'd have to modify a setting on Oracle to store attachments of > 32 MB in
size.
Regards,
Michiel
On Dec 21, 2007 10:48 PM, Allan Yates <[EMAIL PROTECTED]> wrote:
> Great! The strdup fixed the core dump problem (I was using
> AR_LOC_FILENAME).
>
> Now I am getting SQL errors retrieving large attachments. A 4M
> attachment comes across fine, but a 65M one returns an SQL error.
> Anybody run into this before?
>
> PR00002953,86008,"spiff.logs.tar.gz"
> PR00002955,412393,"libmaint.PDE-tcl.target_a23733.log.Z"
> PR00002983,3323556,"dsc.20010219143011-PDE"
> PR00002983,3888804,"dsc.20010215113512-error"
> PR00003005,1039,"root.Regression-TraceOff.log"
> PR00003005,574,"root.Regression-TraceOff.command_a25659.log"
> PR00003005,406,"root.Regression-TraceOff.cmd_ctl_a11326.log"
> PR00003007,26820,"root.ServiceTest-TestLarge.ddsapi.log"
> PR00003007,11300,"root.ServiceTest-TestLarge.log"
> PR00003007,52817,"root.ServiceTest-TestLarge.source_a06706.log"
> PR00003034,9003,"rtpbuild.SIRTools-EnvTransfer_ENV2.ddsapi.log"
> PR00003034,1814,"rtpbuild.SIRTools-EnvTransfer_ENV2.log"
> PR00003034,65574175,"rtpbuild.SIRTools-EnvTransfer_ENV2.target_a26263.lo
> g"
> ars_GetEntryBLOB(
> PR_Problem Report, PR00003034, 536870917 ): [ERROR] Failure during SQL
> operation to the database () (ARERR #552)
>
> From:
> $att = ars_GetEntryBLOB($ctrl_car, $schema_sr, $srid,
> $attfid[$attnum], ARS::AR_LOC_FILENAME, $file );
> die "ars_GetEntryBLOB($schema_sr, $srid, $attfid[$attnum] ):
> $ars_errstr\n" if $ars_errstr;
>
>
> Thanks,
>
> Allan.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Thilo Stapff
> Sent: Wednesday, December 19, 2007 2:15 PM
> To: ARSperl User Discussion
> Subject: Re: [Arsperl-users] Solaris compile problems with 1.90 *
> GetEntryBLOB core dumps
>
> ARSperl 1.90 doesn't support ARS 4.0 any more.
>
> Concerning the core dump, do you call ars_GetEntryBLOB with
> AR_LOC_BUFFER or AR_LOC_FILENAME? Does the core dump occur with both of
> those variants?
>
> If it occurs only with AR_LOC_FILENAME, it might help to change line 756
>
> of the file "ARS.xs" from
>
> loc.u.filename = locFile;
>
> to
>
> loc.u.filename = strdup(locFile);
>
> and compile again. (The line number refers to ARS.xs in version 1.90 and
>
> might be different in 1.85)
>
>
> Regards,
> Thilo Stapff
>
>
> Allan Yates wrote:
> > I have a Solaris server:
> >
> > # uname -a
> > SunOS ottqa05 5.6 Generic_105181-35 sun4u sparc
> > I can compile ARSperl 1.8001, 1.81, 1.82, and 1.85 successfully.
> However
> > 1.90 fails. ARS version is 4.0.
> >
> > The reason I am trying to get a new version working, is that
> > ars_GetEntryBLOB is intermittentantly core dumping and I was hoping a
> > new version of the API might fix that. If I retrieve attachments in a
> > given field order on a service request then it core dumps every time,
> if
> > I reverse the order then it succeeds each time.
> >
> > Any ideas on the compile problem (or the core dump)?
> >
> >
> > Thanks,
> >
> > Allan.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Arsperl-users mailing list
> Arsperl-users@arsperl.org
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Arsperl-users mailing list
Arsperl-users@arsperl.org
https://lists.sourceforge.net/lists/listinfo/arsperl-users
