Dear Jeo, Yes my email form has lot of recored which is being deleted after 45 days and the maim thing is the system send mail in HTML format, that mein the form is heavy.. I have changed the deletion day from 45 to 30 but still think of reducing more to say 15-20 days
I have check with the index and it seems to working fine.. is their any other place where I need to check. In an average my email engine send approx 60 mail a min Regards Rajesh -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, October 21, 2010 12:39 AM To: arslist@ARSLIST.ORG Subject: Re: Cannot open catalog; Message number = 94 94 is a timeout error indicating that the email engine is up but timing out when processing your queue. Is your email message form fairly large? Check the number of records in your email form. I would do it from a SQL query by doing a select count(*) from AR_SYSTEM_EMAIL_MESSAGES; I think that would be the name of the view but double check that... If you have a fairly large number of records there running into hundreds of thousands or millions, it could be a possible reasons why your email engine is timing out. Maybe the search the email engine is using to search for unprocessed emails is not using an index. Check the indexes on the email engine form.. Create an index for the flag which indicates whether or not the mails have been processed if there is none on that field.. If there are indexes on that form on fields that might be qualified as ones that are used for the search, I would suggest that you delete emails that have already been processed and sent. They need not really be present in that form anymore. They serve no purpose other than for an archive or an audit purpose for troubleshooting email problems. But the disadvantage of having it there outweighs the advantage.. You could write an escalation to delete these automatically that would delete emails that have been processed over 30 days ago so you have records of those that have been processed for the last 30 days.. I think a record of about 30 days of processed emails is good enough for all practical reasons.. CANNOT OPEN CATALOG:: I'm assuming you are on UNIX. If you want to resolve this problem, make sure that you have followed the instructions during the time of install of the AR Server and email engine, of coping the cat files to a location recommended and then changing the permissions of these cat files to that of the user that runs the ARS. You do not need to move these files, you could just create a symbolic link to these and give both the link as well as the files the appropriate permissions.. Hope this helps... Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Nair, Rajesh IN BOM SISL Sent: Wednesday, October 20, 2010 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Cannot open catalog; Message number = 94 No their has not been any patch updates on the server since last 1 years Regards Rajesh -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, October 20, 2010 6:54 PM To: arslist@ARSLIST.ORG Subject: Re: Cannot open catalog; Message number = 94 Have there been any patches put on that server? You may also wish to restart the email engine in debug mode to see more detail on exactly what is happening. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nair, Rajesh IN BOM SISL Sent: Wednesday, October 20, 2010 6:32 AM To: arslist@ARSLIST.ORG Subject: Re: Cannot open catalog; Message number = 94 ** HI, Currently I am getting this error in the error log MAPILogonEx Failed - Unable to login to MAPI javax.mail.MessagingException: MAPILogonEx Failed - Unable to login to MAPI at com.remedy.mail.mapi.MAPINative.getStore(Native Method) at com.remedy.mail.mapi.MAPIStore.connect(MAPIStore.java:145) at com.remedy.mail.mapi.MAPIStore.connect(MAPIStore.java:165) at com.remedy.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(Recei verModule.java:1687) at com.remedy.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:205) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Unknown Source) Mapi Client is working on the server where the email engine is present and all the services are working properly Regards Rajesh -----Original Message----- From: Nair, Rajesh IN BOM SISL Sent: Wednesday, October 20, 2010 2:12 PM To: 'arslist@ARSLIST.ORG' Subject: Cannot open catalog; Message number = 94 Hi Any idea what this error is i am getting this error when i am sending a mail to the email server(i had done a new configuration and this did work earlier,but now it has stopped working) I can see the errors in the Email Error Log form. System is not accepting any mails i am send in a fixed format. ARSYSTEM 6.3 patch 23 emial engine 6.3 patch 23 Regards Rajesh ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"