Distribution, Manufacturing, and Internet Modules

[nbirkes]

Last night around 10:00 my eBM web engine stopped responding and even after I restarted the web engine

(which normally fixes) it still would not work. When I got in this morning I rebooted the web engine server

and the site seemed to work, but it was running very slowly.

Then when I sat down to check my email I noticed that I was receiving about 60,000 notification/error emails

from eBM. That said:

---------------------------------------------------------- 

Subject: E-Mail Generation Error

 An error occurred during e-Business Manager e-mailgeneration.

Error reading from SY1UID (Key: '')

Notification Code: ITPSWRD

User ID: (UNKNOWN USER)

Time: 19-May-2009 9:49 pm

------------------------------------------------------ 

And this one

-----------------------------------------------------

Subject:  Password Request

 An error occurred during e-Business Manager e-mailgeneration.

Error reading from SY1UID (Key: '')

Notification Code: ITPSWRD

User ID: (UNKNOWN USER)

Time: 19-May-2009 9:49 pm

------------------------------------------------------ 

Why in the world is eBM generating so many error messages? I tried to check in the kb but couldn't find anything. 

[skipwhitten]

I wouls call your reseller or Sage for support.

Skip 

[nbirkes]

I called support. We opened ITLXXX.soa in datafile display and maintenance and there were 0 records

in the file. So we recovered the ITLXXX.soa from the past two days from a backup and opened them in

DFDM and they both showed 0 records as well.

The support guy talked to one of the tool techs and they said that the file could be corrupt so we deleted 

and recreated it.

Other than that they said call us back if it happens again. 

[Luke]

I think I can answer why you're getting so many messages.
I've not worked with the legacy E-Biz, but if it works the same way that the new E-Biz works, there's a process running on your webserver that just sits in a loop all the time. That loop cleans up dead web sessions and tries to send or resend email. If at first it doesn't succeed, it will try, try again.  It's quite persistent.

[agoldsmith99]

Just a thought -- create a quick crystal report to scan the SY1UID file for duplicate emails on users.  I have seen some odd errors when a duplicate email address is in the user id file.  If there are one or more duplicates then I would recommend researching with the customer if they are still valid and if not, deleting the user id.

[Luke]

---

agoldsmtih99 wrote:
Just a thought -- create a quick crystal report to scan the SY1UID file for duplicate emails on users.  I have seen some odd errors when a duplicate email address is in the user id file.  If there are one or more duplicates then I would recommend researching with the customer if they are still valid and if not, deleting the user id.

---

I second this suggestion. The routine that emails passwords to people looks up the information in SY1UID by email address, so duplicate email addresses can cause problems.

And if you're thinking of upgrading to 4.x and you think there's any possibility that there might be duplicate email addresses in SY1UID, please try to correct that before you upgrade or you will be in for a bumpy data conversion. This data conversion has zero tolerance for duplicate email addresses, and it happens early in the upgrade process before company data is converted because it's in a Library Master (SY) file.

[SPyle]

How does one create a report on SY1UID?  It doesn't come up as an accessible table when I try to create a new report.

[SPyle]

Also, check to make sure that all of your system emails are still correct.  I was getting a duplicate invoice notice sent out every 30 minutes.  It turns out I cancelled an internal sales email account that was the "salesperson's"
account for web customers and I believe that prevented the email from moving to completion. 

So the question here is why did you get thousands and I only got 22?  Somewhere there is a setting for how frequently the email processor runs.

[agoldsmith99]

---

SPyle wrote:
How does one create a report on SY1UID?  It doesn't come up as an accessible table when I try to create a new report.

---

You can do it through crystal reports.  We just pulled up a 3.71 install and double checked -- it is the last table in the list.

[Luke]

---

SPyle wrote:

So the question here is why did you get thousands and I only got 22?  Somewhere there is a setting for how frequently the email processor runs.

---

In 4.30, the E-Business Manager Setup Option "Minutes to Retain Inactive Session" determines how often the cleanup loop runs, which also determines how often it tries to redeliver pending email. I don't have an older version handy to compare to, but I doubt the design has changed.