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,709 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

696 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