Solved

Unknown SQL Exception 33002 occured. Access to module dbo.proc_GetRunnableWorkItems is blocked because the signature is not valid

Posted on 2013-06-10
8
3,633 Views
Last Modified: 2013-08-13
Hi,
My customer's Small Business Server 2008 server is getting the following groups of error messages in the log periodically.  Can anyone point me in the right direction to a fix ?



Log Name:      Application
Source:        Windows SharePoint Services 3
Date:          11/06/2013 10:25:42 AM
Event ID:      5586
Task Category: Database
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      TMGS02.contoso.local
Description:
Unknown SQL Exception 33002 occured. Additional error information from SQL Server is included below.

Access to module dbo.proc_GetRunnableWorkItems is blocked because the signature is not valid.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Windows SharePoint Services 3" />
    <EventID Qualifiers="0">5586</EventID>
    <Level>2</Level>
    <Task>484</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T00:25:42.000Z" />
    <EventRecordID>2787630</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMGS02.contoso.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>33002</Data>
    <Data>Access to module dbo.proc_GetRunnableWorkItems is blocked because the signature is not valid.</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        MSSQL$MICROSOFT##SSEE
Date:          11/06/2013 10:25:42 AM
Event ID:      33002
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      TMGS02.contoso.local
Description:
The description for Event ID 33002 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

module
dbo.proc_GetRunnableWorkItems

The specified resource type cannot be found in the image file

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL$MICROSOFT##SSEE" />
    <EventID Qualifiers="49152">33002</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T00:25:42.000Z" />
    <EventRecordID>2787629</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMGS02.contoso.local</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>module</Data>
    <Data>dbo.proc_GetRunnableWorkItems</Data>
    <Binary>EA800000100000001700000054004D0047005300300032005C004D004900430052004F0053004F004600540023002300530053004500450000000B00000053006800610072006500570065006200440062000000</Binary>
  </EventData>
</Event>

Log Name:      Application
Source:        Windows SharePoint Services 3 Search
Date:          11/06/2013 10:25:38 AM
Event ID:      2424
Task Category: Gatherer
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      TMGS02.contoso.local
Description:
The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again.

Context: Application 'Search', Catalog 'index file on the search server Search'
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Windows SharePoint Services 3 Search" />
    <EventID Qualifiers="32768">2424</EventID>
    <Level>2</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T00:25:38.000Z" />
    <EventRecordID>2787628</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMGS02.contoso.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>

Context: Application 'Search', Catalog 'index file on the search server Search'</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        Windows SharePoint Services 3 Search
Date:          11/06/2013 10:25:38 AM
Event ID:      2436
Task Category: Gatherer
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      TMGS02.contoso.local
Description:
The start address <sts3s://remote.contoso.com.au:987/contentdbid={47084d13-3715-4ec5-a015-651e65c3a61b}> cannot be crawled.

Context: Application 'Search index file on the search server', Catalog 'Search'

Details:
      Error in the Site Data Web Service.   (0x80042616)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Windows SharePoint Services 3 Search" />
    <EventID Qualifiers="32768">2436</EventID>
    <Level>3</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T00:25:38.000Z" />
    <EventRecordID>2787627</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMGS02.contoso.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>

Context: Application 'Search index file on the search server', Catalog 'Search'

Details:
      Error in the Site Data Web Service.   (0x80042616)</Data>
    <Data>sts3s://remote.contoso.com.au:987/contentdbid={47084d13-3715-4ec5-a015-651e65c3a61b}</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        Windows SharePoint Services 3
Date:          11/06/2013 10:25:38 AM
Event ID:      5586
Task Category: Database
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      TMGS02.contoso.local
Description:
Unknown SQL Exception 33002 occured. Additional error information from SQL Server is included below.

Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Windows SharePoint Services 3" />
    <EventID Qualifiers="0">5586</EventID>
    <Level>2</Level>
    <Task>484</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T00:25:38.000Z" />
    <EventRecordID>2787626</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMGS02.contoso.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>33002</Data>
    <Data>Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        MSSQL$MICROSOFT##SSEE
Date:          11/06/2013 10:25:38 AM
Event ID:      33002
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      TMGS02.contoso.local
Description:
The description for Event ID 33002 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

module
dbo.proc_GetCurrent

The specified resource type cannot be found in the image file

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL$MICROSOFT##SSEE" />
    <EventID Qualifiers="49152">33002</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T00:25:38.000Z" />
    <EventRecordID>2787625</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMGS02.contoso.local</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>module</Data>
    <Data>dbo.proc_GetCurrent</Data>
    <Binary>EA800000100000001700000054004D0047005300300032005C004D004900430052004F0053004F004600540023002300530053004500450000000B00000053006800610072006500570065006200440062000000</Binary>
  </EventData>
</Event>
0
Comment
Question by:Michael Green
  • 5
  • 3
8 Comments
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39236575
this is referenced on this ms support page: http://support.microsoft.com/kb/931636
although the eventid is different
however "Access to module dbo.proc_MSS_GetConfigurationProperty is blocked because the signature is not valid." is referenced

hope this helps.
0
 

Author Comment

by:Michael Green
ID: 39236787
PortletPaul - thanks for the link but that hotfix is from 2007.  Why would this suddenly appear as a problem now ?
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39236798
no idea I have to say; if it isn't relevant to your version - well it isn't relevant

but I only seem to find references such at that one or like this http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/f662c6a7-587b-406b-a930-55d0e5b260bd) from that error message that points to some bug/issue/hotfix.

Have there been any recent patches/upgrades/changes applied to SP on-site?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:Michael Green
ID: 39236806
No hot fixes - Windows Update processes (Through Windows Server Update Services) only.....hence my concern to ensure that whatever manual fix is the right one / caused by the correct windows update....
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39236807
and another - also related to recent configuration change
http://go4answers.webhost4life.com/Example/configuration-failed-during-windows-71830.aspx

It's a long page, look at answer 6 (also SMB 2008) - but the symptom being discussed is quite different.

I gather from this question that it's just a frequent logged error without severe (known) consequences. From what I can see it seems to relate to patching of SP.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39236812
Windows Updates could be the cause - I'm not guaranteeing it is - but: if that's the the only config change source - then that's probably where it stems from.

I have not found a magic fix though.
0
 

Author Comment

by:Michael Green
ID: 39236837
I'm wondering whether this more recent issue is the problem (and solution):
http://onpointwithsharepoint.blogspot.com.au/2013/01/sharepoint-cannot-connect-to.html

However I'm not getting a 'cannot connect to configuration database' message on Companyweb
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39236872
those fix instructions are similar to others I have seen in the URLs above:
psconfig -cmd upgrade -inplace b2b
psconfig –cmd upgrade –inplace b2b –wait –force

i.e. they involve the psconfig command (from you last url)"

psconfig -cmd upgrade -inplace b2b -wait -force

I am not in a position to know if that will fix it or not but, answer 17 (the -wait -force options) was the fix there too.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question