We have Remedy 5.0 servers and an Oracle 9i database. Somehow users
are attaching files that become zero bytes after they are added to the
attachement field. We have not been able to narrow it down. I wanted to
see if anyone else had experienced this problem and what might be the
cause.

Hi Scott,

Just a guess but it might be that the files being attached are greater than
the Oracle default text size (about 250k).

If so, the attachment doesn't get stored in the database.

The user doing the save might not notice as they can still open the
attachment in the normal way; the file opens from the directory they have it
in.

Cheers

Peter

-----Original Message-----
From: Scott Ames [mailto:SAmes@NOVELL.COM]
Sent: 03 February 2003 15:55
To: ARSLIST@ARSLIST.ORG
Subject: Zero Byte Attachments


We have Remedy 5.0 servers and an Oracle 9i database. Somehow users
are attaching files that become zero bytes after they are added to the
attachement field. We have not been able to narrow it down. I wanted to
see if anyone else had experienced this problem and what might be the
cause.



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com


Please visit us at http://www.sonybiz.net

****************************************************************************
The information contained in this message or any of its
attachments may be confidential and is intended for the
exclusive use of the addressee(s). Any disclosure,
reproduction, distribution or other dissemination or use of
this communication is strictly prohibited without the
express permission of the sender. The views expressed in
this email are those of the individual and not necessarily
those of Sony or Sony affiliated companies. Sony email is
for business use only. This email and any response may
be monitored by Sony United Kingdom Limited.
****************************************************************************

**

You might want to double check that the users are actually attaching the files and not just shortcuts to the files. If you have direct access to the DB check the Bxxx table, there are columns in it that will tell you the full name of the file as well as the size (both original and compressed in the DB).

Fred

-----Original Message-----
From: Romain, Peter [ mailto:Peter.Romain@SONYBPE.COM]
Sent: Tuesday, February 04, 2003 4:00 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Zero Byte Attachments


Hi Scott,

Just a guess but it might be that the files being attached are greater than the Oracle default text size (about 250k).

If so, the attachment doesn't get stored in the database.

The user doing the save might not notice as they can still open the attachment in the normal way; the file opens from the directory they have it in.

Cheers

Peter

-----Original Message-----
From: Scott Ames [ mailto:SAmes@NOVELL.COM]
Sent: 03 February 2003 15:55
To: ARSLIST@ARSLIST.ORG
Subject: Zero Byte Attachments


We have Remedy 5.0 servers and an Oracle 9i database. Somehow users are attaching files that become zero bytes after they are added to the attachement field. We have not been able to narrow it down. I wanted to see if anyone else had experienced this problem and what might be the cause.






Please visit us at http://www.sonybiz.net

****************************************************************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. This email and any response may be monitored by Sony United Kingdom Limited.

****************************************************************************




This posting was submitted via the Web interface