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,563 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
 

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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 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