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,663 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
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 quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

766 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