Hi Listers!! Need your help !!
We are in ARS 7.1 p7 with email engine 7.1 p9 and from last couple of days we are getting intermittent errors like below in the email logs... Oct 9, 2011 3:47:30 AM com.bmc.arsys.emaildaemon.LoggingModule doWork SEVERE: Index for value in SQL command is greater than the number of values returned we have not seen such error in email logs in the past Both user and inbound email template processing by email engine are intermittently affected due to this. User have to retry multiple times to login to the system(arplugin logs show it has successfully binded for users) The email message is configured to authenitcate using the From address of the email and few inbound email templates(not having any pattern) are not processing and throwing the above error message. This is high impact issue, since the inbound email templates are monitoring jobs for lot of application and this sudden scenario were its not processing doesn't give me how to proceed. BMC Support says this is a defect and fixed in ARS 7.1 patch 9 and wants us to upgrade the patch 9 ( SW00348721) My concern is it will take more time to review and apply the patch and also not sure what new issue patch 9 may bring in..and since the system was stable for couple of years now, trying to understand what other factor could have caused the system to throw this error now(just in email logs, not in arerror.log) As no recent changes has happened and the only doubt i got is factors like increase in the number of people and user_cache records, or more inbound email processing. I would like to know if any of you ran into similar issue and any recommendation you got for me on how it has been handled without applying the patch. Thanks!! Sathish _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
