here is a simple code we used sometime to check the integrity of the db related to the files stored.. Note that this will delete some files that are not on the db or delete records with out files. The code will need modifications in some cases. It will depend on how you system works

(please don't make me responsable if you get something erase with it that was not suppose to be erase.. check the code before running it)

here it is

http://srv1.metro.com.mx/soporte/articulos/integrity.txt

hope it helps

Guillermo

At 11:18 AM 12/11/2001 -0500, you wrote:
Thanks Guillermo, yes if you could email me that off list. :-)
-----Original Message-----
From: Guillermo Dewey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 1:29 PM
To: [EMAIL PROTECTED]
Subject: Re: [iMS] ODSMIME problem

this means the .mail file does not exist

the reasons for this could be:
mail files where moved or for some reason it was register on the db and the phisical file is not there (this a classic when there is no more space on hd). IMS Op validates this and if there is not file it sends an email to the administrator.

we have a code if you want it that checks for all the files to be register on the db and and all the records on the db to have existing files on the hard drive. We use to run this to check the "mail integrity" ones in a while because we had our domains/ code in some how buggy but now is error free :) every email is handle in some way so no data is loose.

regards

Guillermo

At 10:42 AM 12/11/2001 -0500, you wrote:
Howie, I am getting an error after changeing an accountnum in mail and aliases ..there was 2 records in aliases that were for the same username..So i deleted one account then went into mail and changed the accountnum to the correct number.. now i get an error for ALL the mail that was changed..
 

Error Diagnostic Information





CFX_ODSMIME v2.5 Exception occured while processing tag

Exception class: Exception
Exception message: Cannot proceed - file not found. - last status=Set initial variables...

The error occurred while processing an element with a general identifier of (CFX_ODSMIME), occupying document position (151:4) to (152:51).
Date/Time: 12/11/01 10:36:44
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
Remote Address: 63.148.218.250
HTTP Referrer: http://mail.fishingworks.com/viewmail.cfm?folder=334&id=&text=ARCHIVE
Query String: messageid=236174&folder=334&start=1&order_by=TimeStamp&sort=desc&p_page=1
 

 

 

Any help on this?!
This list server is Powered by iMS
"The Swiss Army Knife of Mail Servers"
To leave this list please complete the form at http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [EMAIL PROTECTED]


********************************************
*   Ing. Guillermo Dewey Guerra 
*   Metro Solutions S.A. de C.V.
*   [EMAIL PROTECTED]
*   ICQ: 25876549 (GDewey)
*
*   http://www.metro.com.mx
*   http://www.ablecommerce.com.mx
*
*   Tel. (011) (52) (8) 3-90-7000
*   Fax (011) (52) (8) 3-90-7001
*   Cel. (011) (52) (044) (8) 3-09-24-16
*   Monterrey N.L. Mexico
 ********************************************


********************************************
*   Ing. Guillermo Dewey Guerra 
*   Metro Solutions S.A. de C.V.
*   [EMAIL PROTECTED]
*   ICQ: 25876549 (GDewey)
*
*   http://www.metro.com.mx
*   http://www.ablecommerce.com.mx
*
*   Tel. (011) (52) (8) 3-90-7000
*   Fax (011) (52) (8) 3-90-7001
*   Cel. (011) (52) (044) (8) 3-09-24-16
*   Monterrey N.L. Mexico
 ********************************************

This list server is Powered by iMS
"The Swiss Army Knife of Mail Servers"

To leave this list please complete the form at http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [email protected]