RE: SQL Timer Jobs
Hi Chris, I was saving that for a last resort. Thanks for the query tips. I was hoping to use Mike Stringfellow's suggestion of exporting the sitecollection and then search the XML for any reference to those GUIDs. Unfortunately it's a little large for either an export or backup using standard STSADM commands. Does anyone know if there's an option to export/backup a sitecollection WITHOUT content?? Regards, Paul From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Christopher Scalley Sent: Friday, 13 February 2009 4:33 PM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Hi Paul, I believe the GUIDs are visible if you look directly in the SQL tables/views. Not a very elegant solution, but if you can't find any other way it should provide you what you need. If you use a SQL query to look in tables like: Sites Webs Lists Webparts and look in one of the first couple of columns you can guess which column is the GUID. You can also try tables/views starting with All. So for example you might use SQL Management Studio to run a query like: select * from lists I can then see the the tp_id column is probably the GUID (tp_WebID is not unique in the table so that's not the one - this is showing which Web the list is related to I guess). So I'd then run the following query searching for the particular GUID's you're interested in: select * from lists where tp_id like '%C91183C6-0AA9-451A-A282-952D7E88A85A'%' or tp_id like '%C5271BBD-917E-4A5E-9331-FCB3E1683597%' Alternatively, I can give you some code (a SQL cursor) that will look through every field in every table in a database. That may put a significant load on the SQL server, if you're content databases are more than a few GBs. But it would save you time looking through the tables yourself. Hope that helps! P.S. My background is in SQL, I'm just learning Sharepoint. Regards Chris Scalley Technical Specialist Managed Services T +61 2 9286 2255 [cid:image001.jpg@01C9902D.A658B810] F +61 2 9286 2200 M +61 (0) 400 660 371 E cscal...@cdm.com.aumailto:cscal...@cdm.com.au W www.cdm.com.auhttp://www.cdm.com.au/ Communications, Design Management Pty Limited Level 23, 1 Oxford Street NSW 2010, Darlinghurst This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Friday, 13 February 2009 10:59 AM To: ozmoss@ozmoss.com Subject: SQL Timer Jobs Hi guys, We're continuing to get dozens of event log errors on most of the servers. Most were references to an old SSP which didn't seem to get deleted properly. Others were to files/paths which no longer existed. But I have it a wall with the following. Every minute I get two errors on the SQL box regarding connection issues with one of the WFEs (we have two but only one is throwing errors!). SQL Profiler shows the following two lines that match the event logs but how can I work out which site, web or list is responsible from the GUID? ULT-SPPWEB-01 is the WFE which continues to throw errors. exec proc_StartTimerRunningJob 'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E1683597',N'Config Refresh',N'ULT-SPPWEB-01',1 exec proc_CompleteTimerRunningJob 'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E1683597',N'ULT-SPPWEB-01',2 Thanks in advance, Paul Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists IMPORTANT NOTICE TO RECIPIENT Computer viruses - It is your responsibility to scan this email and any attachments for viruses and defects and rely on those scans as Communications Design Management Pty Limited (CDM) does not accept any liability for loss or damage arising from receipt or use of this email or any attachments. Confidentiality - This email and any attachments are intended for the named recipient only and may contain personal information, be it confidential or subject to privilege, none of which are lost or waived because this email may have been sent to you in error. If you are not the named addressee please let CDM know by return email, permanently delete it from your system and destroy all copies and do not use or disclose the contents. Copyright - This email is subject to copyright and no part of it maybe reproduced in any manner without the written permission of the copyright owner. Privacy - Within the jurisdiction of Australian law, personal information in this email
RE: SQL Timer Jobs
That smells like your machine account has expired in Active directory or something like that, or when you brought it back up, it now has a new SID in Active directory, but the SQL server still has the old SID in its permissions and is barfing. I've had this sort of thing before. You might need to do a little manual surgery in SQL Server permissions? From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 16 February 2009 1:52 PM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Found it! J The first GUID is a fairly generic service ID but the second one is for the Config Refresh timer job. The job runs twice per minute on every server in the farm and the status screen in Central Admin shows 100% success in all cases. But the SQL logs show a repeated login failure for one of the front ends. 2009-02-11 11:43:07.01 Logon Error: 18456, Severity: 14, State: 11. 2009-02-11 11:43:07.01 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: xx.xx.x.xxx] State: 11 means Valid login but server access failure. But what the hell does that mean? And why is the ANONYMOUS account beign used?? If it's any help, this is the WFE that was killed a couple of months ago which we then had to bring back up. It's possible we missed something during this process. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 16 February 2009 11:57 AM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Hi Chris, I was saving that for a last resort. Thanks for the query tips. I was hoping to use Mike Stringfellow's suggestion of exporting the sitecollection and then search the XML for any reference to those GUIDs. Unfortunately it's a little large for either an export or backup using standard STSADM commands. Does anyone know if there's an option to export/backup a sitecollection WITHOUT content?? Regards, Paul From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Christopher Scalley Sent: Friday, 13 February 2009 4:33 PM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Hi Paul, I believe the GUIDs are visible if you look directly in the SQL tables/views. Not a very elegant solution, but if you can't find any other way it should provide you what you need. If you use a SQL query to look in tables like: Sites Webs Lists Webparts and look in one of the first couple of columns you can guess which column is the GUID. You can also try tables/views starting with All. So for example you might use SQL Management Studio to run a query like: select * from lists I can then see the the tp_id column is probably the GUID (tp_WebID is not unique in the table so that's not the one - this is showing which Web the list is related to I guess). So I'd then run the following query searching for the particular GUID's you're interested in: select * from lists where tp_id like '%C91183C6-0AA9-451A-A282-952D7E88A85A'%' or tp_id like '%C5271BBD-917E-4A5E-9331-FCB3E1683597%' Alternatively, I can give you some code (a SQL cursor) that will look through every field in every table in a database. That may put a significant load on the SQL server, if you're content databases are more than a few GBs. But it would save you time looking through the tables yourself. Hope that helps! P.S. My background is in SQL, I'm just learning Sharepoint. Regards Chris Scalley Technical Specialist Managed Services T +61 2 9286 2255 image001 F +61 2 9286 2200 M +61 (0) 400 660 371 E cscal...@cdm.com.au W http://www.cdm.com.au/ www.cdm.com.au Communications, Design Management Pty Limited Level 23, 1 Oxford Street NSW 2010, Darlinghurst _ This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Friday, 13 February 2009 10:59 AM To: ozmoss@ozmoss.com Subject: SQL Timer Jobs Hi guys, We're continuing to get dozens of event log errors on most of the servers. Most were references to an old SSP which didn't seem to get deleted properly. Others were to files/paths which no longer existed. But I have it a wall with the following. Every minute I get two errors on the SQL box regarding connection issues with one of the WFEs (we have two but only one is throwing errors!). SQL Profiler shows the following two lines that match the event logs but how can I work out which site, web or list is responsible from the GUID? ULT-SPPWEB-01 is the WFE which continues to throw errors. exec proc_StartTimerRunningJob 'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E16 83597
RE: SQL Timer Jobs
Hi Paul, That sounds right on the money but I couldn't find any reference to SIDs in SQL. Where should I be looking? Clearly this step needs to be added as part of bringing up a restored WFE but I've found no reference to it. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Monday, 16 February 2009 4:07 PM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs That smells like your machine account has expired in Active directory or something like that, or when you brought it back up, it now has a new SID in Active directory, but the SQL server still has the old SID in its permissions and is barfing. I've had this sort of thing before. You might need to do a little manual surgery in SQL Server permissions? From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 16 February 2009 1:52 PM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Found it! :) The first GUID is a fairly generic service ID but the second one is for the Config Refresh timer job. The job runs twice per minute on every server in the farm and the status screen in Central Admin shows 100% success in all cases. But the SQL logs show a repeated login failure for one of the front ends. 2009-02-11 11:43:07.01 Logon Error: 18456, Severity: 14, State: 11. 2009-02-11 11:43:07.01 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: xx.xx.x.xxx] State: 11 means Valid login but server access failure. But what the hell does that mean? And why is the ANONYMOUS account beign used?? If it's any help, this is the WFE that was killed a couple of months ago which we then had to bring back up. It's possible we missed something during this process. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 16 February 2009 11:57 AM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Hi Chris, I was saving that for a last resort. Thanks for the query tips. I was hoping to use Mike Stringfellow's suggestion of exporting the sitecollection and then search the XML for any reference to those GUIDs. Unfortunately it's a little large for either an export or backup using standard STSADM commands. Does anyone know if there's an option to export/backup a sitecollection WITHOUT content?? Regards, Paul From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Christopher Scalley Sent: Friday, 13 February 2009 4:33 PM To: ozmoss@ozmoss.com Subject: RE: SQL Timer Jobs Hi Paul, I believe the GUIDs are visible if you look directly in the SQL tables/views. Not a very elegant solution, but if you can't find any other way it should provide you what you need. If you use a SQL query to look in tables like: Sites Webs Lists Webparts and look in one of the first couple of columns you can guess which column is the GUID. You can also try tables/views starting with All. So for example you might use SQL Management Studio to run a query like: select * from lists I can then see the the tp_id column is probably the GUID (tp_WebID is not unique in the table so that's not the one - this is showing which Web the list is related to I guess). So I'd then run the following query searching for the particular GUID's you're interested in: select * from lists where tp_id like '%C91183C6-0AA9-451A-A282-952D7E88A85A'%' or tp_id like '%C5271BBD-917E-4A5E-9331-FCB3E1683597%' Alternatively, I can give you some code (a SQL cursor) that will look through every field in every table in a database. That may put a significant load on the SQL server, if you're content databases are more than a few GBs. But it would save you time looking through the tables yourself. Hope that helps! P.S. My background is in SQL, I'm just learning Sharepoint. Regards Chris Scalley Technical Specialist Managed Services T +61 2 9286 2255 [cid:image001.jpg@01C99051.68B45810] F +61 2 9286 2200 M +61 (0) 400 660 371 E cscal...@cdm.com.aumailto:cscal...@cdm.com.au W www.cdm.com.auhttp://www.cdm.com.au/ Communications, Design Management Pty Limited Level 23, 1 Oxford Street NSW 2010, Darlinghurst This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Friday, 13 February 2009 10:59 AM To: ozmoss@ozmoss.com Subject: SQL Timer Jobs Hi guys, We're continuing to get dozens of event log errors on most of the servers. Most were references to an old SSP which didn't seem to get deleted properly. Others were to files/paths which no longer existed. But I have it a wall with the following. Every minute I get two errors on the SQL box regarding connection issues with one of the WFEs (we have
RE: SQL Timer Jobs
Hi Paul, I believe the GUIDs are visible if you look directly in the SQL tables/views. Not a very elegant solution, but if you can't find any other way it should provide you what you need. If you use a SQL query to look in tables like: Sites Webs Lists Webparts and look in one of the first couple of columns you can guess which column is the GUID. You can also try tables/views starting with All. So for example you might use SQL Management Studio to run a query like: select * from lists I can then see the the tp_id column is probably the GUID (tp_WebID is not unique in the table so that's not the one - this is showing which Web the list is related to I guess). So I'd then run the following query searching for the particular GUID's you're interested in: select * from lists where tp_id like '%C91183C6-0AA9-451A-A282-952D7E88A85A'%' or tp_id like '%C5271BBD-917E-4A5E-9331-FCB3E1683597%' Alternatively, I can give you some code (a SQL cursor) that will look through every field in every table in a database. That may put a significant load on the SQL server, if you're content databases are more than a few GBs. But it would save you time looking through the tables yourself. Hope that helps! P.S. My background is in SQL, I'm just learning Sharepoint. Regards Chris Scalley Technical Specialist Managed Services T +61 2 9286 2255 [cid:image001.jpg@01C98DF8.5D3044A0] F +61 2 9286 2200 M +61 (0) 400 660 371 E cscal...@cdm.com.aumailto:cscal...@cdm.com.au W www.cdm.com.auhttp://www.cdm.com.au/ Communications, Design Management Pty Limited Level 23, 1 Oxford Street NSW 2010, Darlinghurst This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Friday, 13 February 2009 10:59 AM To: ozmoss@ozmoss.com Subject: SQL Timer Jobs Hi guys, We're continuing to get dozens of event log errors on most of the servers. Most were references to an old SSP which didn't seem to get deleted properly. Others were to files/paths which no longer existed. But I have it a wall with the following. Every minute I get two errors on the SQL box regarding connection issues with one of the WFEs (we have two but only one is throwing errors!). SQL Profiler shows the following two lines that match the event logs but how can I work out which site, web or list is responsible from the GUID? ULT-SPPWEB-01 is the WFE which continues to throw errors. exec proc_StartTimerRunningJob 'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E1683597',N'Config Refresh',N'ULT-SPPWEB-01',1 exec proc_CompleteTimerRunningJob 'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E1683597',N'ULT-SPPWEB-01',2 Thanks in advance, Paul Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists IMPORTANT NOTICE TO RECIPIENT Computer viruses - It is your responsibility to scan this email and any attachments for viruses and defects and rely on those scans as Communications Design Management Pty Limited (CDM) does not accept any liability for loss or damage arising from receipt or use of this email or any attachments. Confidentiality - This email and any attachments are intended for the named recipient only and may contain personal information, be it confidential or subject to privilege, none of which are lost or waived because this email may have been sent to you in error. If you are not the named addressee please let CDM know by return email, permanently delete it from your system and destroy all copies and do not use or disclose the contents. Copyright - This email is subject to copyright and no part of it maybe reproduced in any manner without the written permission of the copyright owner. Privacy - Within the jurisdiction of Australian law, personal information in this email must be dealt with in compliance with the Australian Federal Privacy Act 1988. Support procedure: http://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists inline: image001.jpg
