Ugh!! Why IS that? We don't update our oracle tables directly, everything is done through the client, then the app server then Oracle.
I might log this with BMC to at least get an answer as to why they store the full path? Also, I don't get this error when I push this field via a filter. We had a problem before when someone overseas in Europe saved an attachment in a record and everyone who opened that record had their client crash on them. It was because there was a European character in the path of the attachment and the client is not Unicode. Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, August 09, 2007 1:36 PM To: [email protected] Subject: Re: ARERR [342] Cannot find/open the directory file: 0 Lisa, I have experienced something like this before. The full path to the attachment is stored in the ARS table. When attempting to access it from a computer that does not have the same drive letter and/or folder structure it sometimes generates an error. When attachments are saved to the form I run a process that removes the path and only leaves the filename. HTH To see how filenames are stored run a SQL command on the base table, for example: "SELECT TOP 10 * FROM B611" where the primary table name is T611. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, August 09, 2007 1:25 PM To: [email protected] Subject: ARERR [342] Cannot find/open the directory file: 0 I'm trying to push an attachment field to another form (with the same Attachment Pool number and Attachment field number) via an Active Link. I can do this with a Filter no problem, but when trying to do it through an Active Link (via a push), I'm getting this error: ARERR [342] Cannot find/open the directory file: 0 I checked the ErrMsgsGuide for 6.3, but it really doesn't tell me much. We are on Server 6.3, User 7.0.1 Patch 003, Sun Solaris..... Lisa ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
