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,496 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:SGSMikeG
  • 5
  • 3
8 Comments
 
LVL 48

Expert Comment

by:PortletPaul
Comment Utility
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:SGSMikeG
Comment Utility
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
Comment Utility
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
 

Author Comment

by:SGSMikeG
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 48

Expert Comment

by:PortletPaul
Comment Utility
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
Comment Utility
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:SGSMikeG
Comment Utility
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
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now