Guys I'm having a problem with sharepoint alerts the problem is if someone adds themselves to a document they recieve the first email telling them that you've been signed up for alerts. However, when the documents get updated they recieve no alert email telling them about the update. This is not happeing on all sites I've only noticed the behavior on certain sites. Also the timer jobs look ok they are set for immediate for the sites in question also there are no error in the windows log. If anyone has any experience with this please share?

I guess you checked the timer job stats in Central Admin (Operations-Timer jobs status) ? This post might help http://www.delphi-ts.com/blogs/lozzi/post/2009/06/02/SharePoint-Alerts-Are-Not-Sending.aspx Serge Luca; blog: http://www.redwood.be

I'm going to check that link out but the strange thing is I only have certain sites that are doing this. I have a few other site collections that work fine this is just strange my working sites an non working sites also share the same web app even though that does not mean anything.

Have you looked at the MOSS diagnostic logs? The more I think about it I think I've seen something similar and it was a SMTP relay related issue. I think the initial email uses a different method to send emails than the normal timer job does.David Lozzi Delphi Technology Solutions Blog | LinkedIn | Twitter

If you get the initial email & not the subsequent ones this may be a security trimming issue. Try running the steps in KB934838 HK

This may not be an smtp problem right now there's one account that's used for all services. I know thats a bad idea but I did not install the software but I do plan on fixing it. Anyway I took the main moss account and gave it domain admin rights which basically gives it full rights on exchange. After that I went to the outbound secuirty tab on the virtual smtp server that's installed on my frontend servers and entered the same moss account still if I sign up for an alert I get the first email after that I receive know update emails.

Hi alphabanks, You could get the first email, it indicated that there should be no problem with the SMTP. As the Alert Me feature takes advantage of Security Trimming, please double confirm that the affected users have properly permissions on the document items. A common mistake is that Versioning is enabled in Document Library and users who do not have approval permission cannot see the draft items (minor version) and receive the alerts until them publish as major versions. If this is not the cause of the issue, please do the following steps and let me know the result for further research. 1. Subscribe a alert to a user, let me know the permissions of the user. 2. After the initial mail was received, change the Least critical event to report to the trace log to Verbose in Central Administration > Operations > Diagnostic Logging > Event Throttling. 3. Modify the document and publish it as major version. 4. Monitor the ULS logs, search for the log entries looks like the following and let me know the information. <Time> OWSTIMER.EXE (0x1980) 0x1EBC Windows SharePoint Services Timer 95l5 Verbose AlertsJob processed 3 immediate notifications in 3 digests, sent 2 emails, failed to send 0 emails <Time> OWSTIMER.EXE (0x1980) 0x1EBC Windows SharePoint Services Timer 95lg Verbose Alertsjob results for immediate delivery: 0 prematches, 0 passed filtering, 0 of 0 passed security trimming, 0 final after rollup Let me know the result if possible. -lambertSincerely, Lambert Qin | Microsoft TechNet Managed Forum Support Posting is provided "AS IS" with no warranties, and confers no rights.

I looked in the uls log for my document library that's working I get this 07/14/2009 15:55:50.04 OWSTIMER.EXE (0x05B0) 0x0FC0 Windows SharePoint Services Timer 95lg Verbose Alertsjob results for immediate delivery: 5 prematches, 5 passed filtering, 3 of 5 passed security trimming, 1 final after rollup 07/14/2009 15:55:50.04 OWSTIMER.EXE (0x05B0) 0x0FC0 Windows SharePoint Services Timer 95lh Verbose Alertsjob results for scheduled delivery: 0 prematches, 0 passed filtering, 0 of 0 passed security trimming, 0 final after rollup 07/14/2009 15:55:50.19 OWSTIMER.EXE (0x05B0) 0x0FC0 Windows SharePoint Services Timer 95l5 Verbose AlertsJob processed 1 immediate notifications in 1 digests, sent 1 emails, failed to send 0 emails 07/14/2009 15:55:50.41 OWSTIMER.EXE (0x05B0) 0x0FC0 Windows SharePoint Services General 0 Medium Entering MRU trim routine. however for the libraries that will not send update notifications I receive the below entries hopefully this what you were speaking of. BTW I tested these on my account I have full control 95ld Verbose AlertsJob loaded 0 of 0 subscription records 07/14/2009 15:55:20.97 OWSTIMER.EXE (0x05B0) 0x0D10 Windows SharePoint Services Timer 95lg Verbose Alertsjob results for immediate delivery: 0 prematches, 0 passed filtering, 0 of 0 passed security trimming, 0 final after rollup 07/14/2009 15:55:20.97 OWSTIMER.EXE (0x05B0) 0x0D10 Windows SharePoint Services Timer 95lh Verbose Alertsjob results for scheduled delivery: 0 prematches, 0 passed filtering, 0 of 0 passed security trimming, 0 final after rollup

Hi alphabanks, Thanks for your cooperation. From the logs, we can see that there is no alerts generated from your operations. I am not quite sure the root cause of the issue. It may cause by the corrupted document library. If the two document library are located in the same site, a quick resolution is that create a new document and migrate the content to the new document library. If you want to do some deeper troubleshooting, please follow the steps: 1. Make sure alerts was enabled using stsadm -o getproperty -url http://server_name -pn alerts-enabled (http://technet.microsoft.com/en-us/library/cc263206.aspx) 2. In the affected library, modify a document. 3. Verify whether the event entry is recorded in EventCache table using the SQL statement: Select * from EventCache Where EventType & 0xFFF != 0 Order by DESC 4. Check the ImmedSubscriptions and SchedSubscriptions table to confirm that the alert is recorded. 5. Let me know the affected rows in the Step 2 and Step 3 Let me know the result if possible. -lambertSincerely, Lambert Qin | Microsoft TechNet Managed Forum Support Posting is provided "AS IS" with no warranties, and confers no rights.

alphabanks, have you tried a creating new list or document library and create an alert from there?David Lozzi Delphi Technology Solutions Blog | LinkedIn | Twitter

I have this broken out into different site collections thats the only difference collection A works collection B does not. So basically every llibrary thats coming off site collection B will not work with alerts. I actually tried creating a brand new document library than uploading a test doc to it still the same results I get the first email but no update emails. I also tried alerts off an existing list same results. Ok I ran stsadm -o getproperty -url http://server_name -pn alerts-enabled and this was returned <Property Exist="Yes" Value="yes" />. If I did not run the below test correctly let me know and I will try again. One strange thing I noticed why are there 3 records generated when signing up for an alert two were generated when I updated the test document ImmedSubscriptions table 2d23edd2-b31d-4a1a-89ae-87dcbe82ea98 73b4ba45-0779-4272-b4b8-39595bca8c49 8dcc9e14-047d-4839-ba8e-582648e04dc4 0d507154-a2e6-4024-9069-b7bce7f7d19a 13 -1 2 testuser@company.com https://portal.company.com /corporate/Procurement Procurement 1033 1033 11 False 1 0 Procurement Key Performance Metrics Procurement Key Performance Metrics 1 101 Procurement Key Performance Metrics: testprocurement.docx 1 SPAlertTemplateType.DocumentLibrary <Binary data> <miscellaneous><property name="eventtypeindex" value="-1" /><property name="siteurl" value="https://sharepoint.onealsteel.com" /><property name="filterindex" value="0" /><property name="mobileurl" value="https://sharepoint.onealsteel.com/corporate/Procurement/_layouts/mobile/" /><property name="dispformurl" value="Procurement Key Performance Metrics/Forms/DispForm.aspx" /></miscellaneous> 0 76965d93-5094-404b-bedc-c07223060fcc False I see nothing in the SchedSubscriptions table Results from Select * from EventCache Where EventType & 0xFFF != 0 Order by DESC 2009-07-15 18:59:53.600 97472 73B4BA45-0779-4272-B4B8-39595BCA8C49 8DCC9E14-047D-4839-BA8E-582648E04DC4 0D507154-A2E6-4024-9069-B7BCE7F7D19A 14 AE8D9ACD-C045-40C4-B421-A9E977D19CC8 NULL NULL NULL NULL changetest.docx corporate/Procurement/Procurement Key Performance Metrics/changetest.docx 4097 1 User, Test 2009-07-15 18:59:53.000 NULL NULL 2009-07-15 18:59:58.210 97473 73B4BA45-0779-4272-B4B8-39595BCA8C49 8DCC9E14-047D-4839-BA8E-582648E04DC4 0D507154-A2E6-4024-9069-B7BCE7F7D19A 14 AE8D9ACD-C045-40C4-B421-A9E977D19CC8 NULL NULL NULL NULL changetest.docx corporate/Procurement/Procurement Key Performance Metrics/changetest.docx 8194 1 User Tes9-07-15 18:59:58.000 NULL NULL 2009-07-15 18:59:58.367 97474 73B4BA45-0779-4272-B4B8-39595BCA8C49 8DCC9E14-047D-4839-BA8E-582648E04DC4 0D507154-A2E6-4024-9069-B7BCE7F7D19A 14 AE8D9ACD-C045-40C4-B421-A9E977D19CC8 NULL NULL NULL NULL changetest.docx corporate/Procurement/Procurement Key Performance Metrics/changetest.docx 8194 1 User, Test 2009-07-15 18:59:59.000 NULL NULL I than ran the query after updating the document 2009-07-15 19:03:38.503 97477 73B4BA45-0779-4272-B4B8-39595BCA8C49 8DCC9E14-047D-4839-BA8E-582648E04DC4 0D507154-A2E6-4024-9069-B7BCE7F7D19A 14 AE8D9ACD-C045-40C4-B421-A9E977D19CC8 NULL NULL NULL NULL changetest.docx corporate/Procurement/Procurement Key Performance Metrics/changetest.docx 8194 1 User, Test 2009-07-15 19:03:38.000 0x010000000200000449440031340001000105436F6E74656E7454797065496400436F6E74656E74205479706520494400307830313031303046394146303330373841354332453436383234334332424439383038383944410001000005436F6E74656E745479706500436F6E74656E74205479706500446F63756D656E740007000015417574686F7200437265617465642042790032005374657068656E732C204D61726B0007000017456469746F72004D6F6469666965642042790032005374657068656E732C204D61726B000700001D436865636B6F75745573657200436865636B6564204F757420546F003200005374657068656E732C204D61726B00010001054D6F6469666965645F78303032305F427900446F63756D656E74204D6F646966696564204279004F4E45414C5C6D7374657068656E730001000105437265617465645F78303032305F427900446F63756D656E742043726561746564204279004F4E45414C5C6D7374657068656E73000100010546696C655F78303032305F547970650046696C65205479706500646F637800020001055F4C6576656C004C6576656C0032353500050001055F497343757272656E7456657273696F6E0049732043757272656E742056657273696F6E002D3100020001046F777368696464656E76657273696F6E003300020001055F554956657273696F6E0055492056657273696F6E003130323400010000055F554956657273696F6E537472696E670056657273696F6E00322E3000030001044F726465720031343030000100010447554944007B31373334373943322D453845312D344242462D384645442D3242463544343436334141447D00010000045469746C65006368616E6765000100010446696C654C656166526566006368616E6765746573742E646F6378000100010446696C6552656600636F72706F726174652F50726F637572656D656E742F50726F637572656D656E74204B657920506572666F726D616E6365204D6574726963732F6368616E6765746573742E646F6378000100010446696C6544697252656600636F72706F726174652F50726F637572656D656E742F50726F637572656D656E74204B657920506572666F726D616E6365204D65747269637300 0xF3FE000001000000000000003000000002000000FFFFFFFFFFFFFF7F03000000FFFFFFFFFFFFFF7F0400000061104308B000000005000000EF12433CB001000006000000001001083000000007000000FF1B5F3CB001000008000000EF1BE77EF001004009000000FF13433CB00100000A00000021100308300000000B00000000100108300000000E00000041104308B000000015000000FFFFFFFFFFFFFF7F16000000EF12433CB00100001700000061104308B00000001A00000061104308B000000024000000FFFFFFFFFFFFFF7F25000000EF12433CB00100002600000061104308B00000003F000000FFFFFFFFFFFFFF7F40000000001001083000000055000000FFFFFFFFFFFFFF7F56000000EF12433CB00100005700000061104308B0000000DB000000FFFFFFFFFFFFFF7FDC000000EF12433CB0010000DD00000061104308B0000000E3000000FFFFFFFFFFFFFF7FE4000000FFFFFFFFFFFFFF7F23010000FFFFFFFFFFFFFF7F24010000EF12433CB00100002501000061104308B00000003C010000FFFFFFFFFFFFFF7F3D010000EF12433CB00100003E01000061104308B0000000440100000010010830000000EB0100000010010830000000230200000010010830000000260200000010010830000000DD020000FFFFFFFFFFFFFF7FDE020000EF12433CB0010000DF02000061104308B0000000260300000010010830000000A10300000010010830000000A20300000010010830000000A30300000010010830000000A40300000010010830000000A50300000010010830000000FFFFFF3F0010010830000000 2009-07-15 19:03:38.767 97478 73B4BA45-0779-4272-B4B8-39595BCA8C49 8DCC9E14-047D-4839-BA8E-582648E04DC4 0D507154-A2E6-4024-9069-B7BCE7F7D19A 14 AE8D9ACD-C045-40C4-B421-A9E977D19CC8 NULL NULL NULL NULL changetest.docx corporate/Procurement/Procurement Key Performance Metrics/changetest.docx 8194 1 User, Test 2009-07-15 19:03:38.000 0x010000000200000449440031340001000105436F6E74656E7454797065496400436F6E74656E74205479706520494400307830313031303046394146303330373841354332453436383234334332424439383038383944410001000005436F6E74656E745479706500436F6E74656E74205479706500446F63756D656E740007000015417574686F7200437265617465642042790032005374657068656E732C204D61726B0007000015456469746F72004D6F6469666965642042790032005374657068656E732C204D61726B000700001D436865636B6F75745573657200436865636B6564204F757420546F003200005374657068656E732C204D61726B00010001054D6F6469666965645F78303032305F427900446F63756D656E74204D6F646966696564204279004F4E45414C5C6D7374657068656E730001000105437265617465645F78303032305F427900446F63756D656E742043726561746564204279004F4E45414C5C6D7374657068656E73000100010546696C655F78303032305F547970650046696C65205479706500646F6378000200010D5F4C6576656C004C6576656C00323535003100050001055F497343757272656E7456657273696F6E0049732043757272656E742056657273696F6E002D3100020001046F777368696464656E76657273696F6E003400020001055F554956657273696F6E0055492056657273696F6E003130323400010000055F554956657273696F6E537472696E670056657273696F6E00322E3000030001044F726465720031343030000100010447554944007B31373334373943322D453845312D344242462D384645442D3242463544343436334141447D00010000045469746C65006368616E6765000100010446696C654C656166526566006368616E6765746573742E646F6378000100010446696C6552656600636F72706F726174652F50726F637572656D656E742F50726F637572656D656E74204B657920506572666F726D616E6365204D6574726963732F6368616E6765746573742E646F6378000100010446696C6544697252656600636F72706F726174652F50726F637572656D656E742F50726F637572656D656E74204B657920506572666F726D616E6365204D65747269637300 0xF3FE000001000000000000003000000002000000FFFFFFFFFFFFFF7F03000000FFFFFFFFFFFFFF7F0400000061104308B000000005000000EF12433CB001000006000000001001083000000007000000FF1B5F3CB001000008000000EF1BE77EF001004009000000FF13433CB00100000A00000021100308300000000B00000000100108300000000E00000041104308B000000015000000FFFFFFFFFFFFFF7F16000000EF12433CB00100001700000061104308B00000001A00000061104308B000000024000000FFFFFFFFFFFFFF7F25000000EF12433CB00100002600000061104308B00000003F000000FFFFFFFFFFFFFF7F40000000001001083000000055000000FFFFFFFFFFFFFF7F56000000EF12433CB00100005700000061104308B0000000DB000000FFFFFFFFFFFFFF7FDC000000EF12433CB0010000DD00000061104308B0000000E3000000FFFFFFFFFFFFFF7FE4000000FFFFFFFFFFFFFF7F23010000FFFFFFFFFFFFFF7F24010000EF12433CB00100002501000061104308B00000003C010000FFFFFFFFFFFFFF7F3D010000EF12433CB00100003E01000061104308B0000000440100000010010830000000EB0100000010010830000000230200000010010830000000260200000010010830000000DD020000FFFFFFFFFFFFFF7FDE020000EF12433CB0010000DF02000061104308B0000000260300000010010830000000A10300000010010830000000A20300000010010830000000A30300000010010830000000A40300000010010830000000A50300000010010830000000FFFFFF3F0010010830000000

Hi alphabanks, Thanks for your cooperation. From the result you attached, I know that: 1. The Alert subscription was added to the SQL Server correctly. 2. The add document and modify document was successfully recorded. The EventType 4097 means the document was added. The EventType 8194 means the document was modified. 3. The alert was enabled. Please further narrow down the issue follow the steps: 1. If the two site collection was located on difference web application, please make sure Immediate Alerts timer job was running in Central Administration > Operations > Timer Job Status. 2. Modify the test document. 3. Monitor the event entry recorded in EventCache table using the SQL statement: Select * from EventCache Where EventType & 0xFFF != 0 Order by DESC 4. You should see that the last two column (Event Data and ACL) was not empty. 5. Wait for 5 minutes, monitor the Event Data and ACL columns values. 6. The expected result is that the Event Data and ACL columns values are Null. 7. If the results are not null, please repeat the steps from step 2 to step 5 and capture the SQL Profile trace for me. 8. If result was as expected, but you still cannot receive the alert, there should be the permission issue, I suggest you to re-examine the permissions on the user who created the alert and the Timer Service. You could upload the SQL Profile trace log to: Workspace URL: (https://sftus.one.microsoft.com/ChooseTransfer.aspx?key=898e97eb-a184-4206-ad5a-1e275b98f7d4) Workspace Password: kpB[mM#)K%ujIhL Let me know the result if possible. -lambertSincerely, Lambert Qin | Microsoft TechNet Managed Forum Support Posting is provided "AS IS" with no warranties, and confers no rights.

I opened up a case with microsoft support the tech thinks it's a smtp problem however, I will perform your steps and post back. I'm still confused on the permissions problem because I have full control and the alerts do not work for me

Lambert Qin do you have an im account I can get I would like to talk to you about my problem btw do they have private messaging on the forum here

Hi alphabanks, Thanks for let me know you are now working with our supporting professional, I am sure your issue would be resolved with their help. Could you please share me the ticket number in order to let me track your issue in our internal database? Currently the forum do not support send private messages, please understand I could not share private information in the public forum. However, if you use LinkedIn, you could contact me via http://www.linkedin.com/in/lambertqin Thanks. -lambertSincerely, Lambert Qin | Microsoft TechNet Managed Forum Support Posting is provided "AS IS" with no warranties, and confers no rights.

I will do that talk to you there

Did you ever figure out a solution for this issue?I'm having the same problem at a client and could use help.Thanks-Nate

Microsoft support is still working on the problem. I would like to ask you though are you sending email through mail enabled security groups that require authentication

Hi alphabanks,I am also travelling in the same boat [same problem] .Could you please let us know if you managed to solve this?

Hi all, The problem is solved!!!! we happened to do a restart of our web frontend and appservers this weekend beforeinstalling June Cumulative Updateand that solved our problem!!!Regards,Kishore.

Hi all,I was having the same problem.No email alerts would be sent for any siteor library created from my site collection.I would get the initial notification email that I had subscribed to get alerts, but no alert was ever sent when items were added/changed or deleted.I confirmed that there was an "Immediate Alerts" timer job definition for my site;I then looked in the "ImmedSubscriptions" table and noticed that the value for the "SiteUrl" column was different than the default value that was setup in the Alternate Access Mappings in Central Admin. The default value in central admin was incorrect, I corrected the value and viola! I got email alerts.Kent Lynch

I fixed this issue. here is the blog http://suryapulipati.blogspot.com/2012/05/server-administration-programs-and.htmlSurya.P