Sharepoint 2010 Event Id 57
Windows 2012
Windows 2008 SQL 2008 Server hold all SharePoint 2010 data bases
SharePoint 2010 Cu November 2015
Getting this error all the time
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Server Search
Date: 1/24/2016 3:58:05 PM
Event ID: 57
Task Category: Search service
Level: Warning
Keywords:
User: XXX\SERV013.FQDN.com
Description:
A database error occurred. Source: Microsoft SQL Server Native Client 10.0 Code: 0 occurred 1 time(s) Description: No value given for one or more required parameters.
Context: Application 'Search_Service_Applicatio
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint
<EventID>57</EventID>
<Version>14</Version>
<Level>3</Level>
<Task>136</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000
<TimeCreated SystemTime="2016-01-24T20:
<EventRecordID>126494</Eve
<Correlation />
<Execution ProcessID="3752" ThreadID="7956" />
<Channel>Application</Chan
<Computer>SERV013.FQDN.com
<Security UserID="S-1-5-21-305458857
</System>
<EventData>
<Data Name="string0">Microsoft SQL Server Native Client 10.0</Data>
<Data Name="string1">0</Data>
<Data Name="string2">1</Data>
<Data Name="string3">No value given for one or more required parameters.</Data>
<Data Name="string4">
Context: Application 'Search_Service_Applicatio
</EventData>
</Event>
What's wrong here?
Tom
Windows 2008 SQL 2008 Server hold all SharePoint 2010 data bases
SharePoint 2010 Cu November 2015
Getting this error all the time
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Server Search
Date: 1/24/2016 3:58:05 PM
Event ID: 57
Task Category: Search service
Level: Warning
Keywords:
User: XXX\SERV013.FQDN.com
Description:
A database error occurred. Source: Microsoft SQL Server Native Client 10.0 Code: 0 occurred 1 time(s) Description: No value given for one or more required parameters.
Context: Application 'Search_Service_Applicatio
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint
<EventID>57</EventID>
<Version>14</Version>
<Level>3</Level>
<Task>136</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000
<TimeCreated SystemTime="2016-01-24T20:
<EventRecordID>126494</Eve
<Correlation />
<Execution ProcessID="3752" ThreadID="7956" />
<Channel>Application</Chan
<Computer>SERV013.FQDN.com
<Security UserID="S-1-5-21-305458857
</System>
<EventData>
<Data Name="string0">Microsoft SQL Server Native Client 10.0</Data>
<Data Name="string1">0</Data>
<Data Name="string2">1</Data>
<Data Name="string3">No value given for one or more required parameters.</Data>
<Data Name="string4">
Context: Application 'Search_Service_Applicatio
</EventData>
</Event>
What's wrong here?
Tom
Last Comment
ASKER
Vitor
I get this one also
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Server Search
Date: 1/25/2016 1:58:07 PM
Event ID: 57
Task Category: Search service
Level: Warning
Keywords:
User: xxx\spservices
Computer: SERV013.FQDN.com
Description:
A database error occurred. Source: Microsoft SQL Server Native Client 10.0 Code: 2812 occurred 1 time(s) Description: Could not find stored procedure 'dbo.proc_MSS_Crawl'.
Context: Application 'Search_Service_Applicatio
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint
<EventID>57</EventID>
<Version>14</Version>
<Level>3</Level>
<Task>136</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000
<TimeCreated SystemTime="2016-01-25T18:
<EventRecordID>126812</Eve
<Correlation />
<Execution ProcessID="3752" ThreadID="5540" />
<Channel>Application</Chan
<Computer>SERV013.FQDN.com
<Security UserID="S-1-5-21-305458857
</System>
<EventData>
<Data Name="string0">Microsoft SQL Server Native Client 10.0</Data>
<Data Name="string1">2812</Data>
<Data Name="string2">1</Data>
<Data Name="string3">Could not find stored procedure 'dbo.proc_MSS_Crawl'.</Dat
<Data Name="string4">
Context: Application 'Search_Service_Applicatio
</EventData>
</Event>
Thoughts?
I get this one also
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Server Search
Date: 1/25/2016 1:58:07 PM
Event ID: 57
Task Category: Search service
Level: Warning
Keywords:
User: xxx\spservices
Computer: SERV013.FQDN.com
Description:
A database error occurred. Source: Microsoft SQL Server Native Client 10.0 Code: 2812 occurred 1 time(s) Description: Could not find stored procedure 'dbo.proc_MSS_Crawl'.
Context: Application 'Search_Service_Applicatio
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint
<EventID>57</EventID>
<Version>14</Version>
<Level>3</Level>
<Task>136</Task>
<Opcode>0</Opcode>
<Keywords>0x40000000000000
<TimeCreated SystemTime="2016-01-25T18:
<EventRecordID>126812</Eve
<Correlation />
<Execution ProcessID="3752" ThreadID="5540" />
<Channel>Application</Chan
<Computer>SERV013.FQDN.com
<Security UserID="S-1-5-21-305458857
</System>
<EventData>
<Data Name="string0">Microsoft SQL Server Native Client 10.0</Data>
<Data Name="string1">2812</Data>
<Data Name="string2">1</Data>
<Data Name="string3">Could not find stored procedure 'dbo.proc_MSS_Crawl'.</Dat
<Data Name="string4">
Context: Application 'Search_Service_Applicatio
</EventData>
</Event>
Thoughts?
Could not find stored procedure 'dbo.proc_MSS_Crawl'Well, looks like stored procedure 'dbo.proc_MSS_Crawl' is missing.
Did you make any update on SharePoint lately?
Check if you have the latest SharePoint hotfixes installed.
ASKER
Vitor,
Server is updated regularly by WSUS but SharePoint is not included in WSUS
The last update to sharepoint was CU November 2015
I found this
December 8, 2015, cumulative update for SharePoint Server 2010 (KB3114408)
When you say Hotfixes do you mean the CU? or are there hotfixes available for SharePoint\?
If so where?
Server is updated regularly by WSUS but SharePoint is not included in WSUS
The last update to sharepoint was CU November 2015
I found this
December 8, 2015, cumulative update for SharePoint Server 2010 (KB3114408)
When you say Hotfixes do you mean the CU? or are there hotfixes available for SharePoint\?
If so where?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Vitor
I have CU Dec 2015 downloaded
SP2 for SharePoint is installed
Will search for hotfixes if you know of any please point me to them
A little back ground
about 3 months ago I rebuilt the entire Farm due to several error conditions
I have had the Event ID 57 ever since I installed SharePoint 2010 it comes and goes.
I believe it is just a configuration issue or security issue
The security issue seems to be a big issue with 2010
I have two other questions opened on this site about sharepoint if you would like to take a look at them that would be helpful also
I will apply Dec CU 2015 in the next couple of days.
https://www.experts-exchange.com/questions/28906719/Outlook-2013-Sharepoint-2010-Calendar-Connect-Issue.html
https://www.experts-exchange.com/questions/28906681/Sharepoint-2010-Backup-Event-Error-234.html
Thanks
I have CU Dec 2015 downloaded
SP2 for SharePoint is installed
Will search for hotfixes if you know of any please point me to them
A little back ground
about 3 months ago I rebuilt the entire Farm due to several error conditions
I have had the Event ID 57 ever since I installed SharePoint 2010 it comes and goes.
I believe it is just a configuration issue or security issue
The security issue seems to be a big issue with 2010
I have two other questions opened on this site about sharepoint if you would like to take a look at them that would be helpful also
I will apply Dec CU 2015 in the next couple of days.
https://www.experts-exchange.com/questions/28906719/Outlook-2013-Sharepoint-2010-Calendar-Connect-Issue.html
https://www.experts-exchange.com/questions/28906681/Sharepoint-2010-Backup-Event-Error-234.html
Thanks
Let me know after you apply the CU.
About the other questions I'm afraid I can't help you since they are out of my knowledge.
Cheers.
About the other questions I'm afraid I can't help you since they are out of my knowledge.
Cheers.
ASKER
Will apply the cu update this weekend
ASKER
Vitor
After applying the updates to my SharePoint server and sharepoint itself
Event If 57 still occurs
Thoughts?
After applying the updates to my SharePoint server and sharepoint itself
Event If 57 still occurs
Thoughts?
Sorry Thomas.
Unfortunaly I don't have any more ideas and don't want to tell you to reinstall everything.
Did you request Microsoft support?
Unfortunaly I don't have any more ideas and don't want to tell you to reinstall everything.
Did you request Microsoft support?
ASKER
Vitor
I found this researching this more need your thoughts on this
https://social.technet.microsoft.com/Forums/office/en-US/b9197f50-b26c-430d-8b56-09261bd67b8d/event-id-57-could-not-find-stored-procedure-dboprocmsscrawladmin-and-could-not-find?forum=sharepointsearchprevious
The last entry talks about this
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a40cb085-c872-486b-9461-311f607cd69c/sql-native-client-100-registry-error?forum=sqltools
HKEY_LOCAL_MACHINE\SOFTWAR
On my sharepoint server I went to this registry location not much defined there
Am I missing something?
see attached key
sqlnative.reg
I found this researching this more need your thoughts on this
https://social.technet.microsoft.com/Forums/office/en-US/b9197f50-b26c-430d-8b56-09261bd67b8d/event-id-57-could-not-find-stored-procedure-dboprocmsscrawladmin-and-could-not-find?forum=sharepointsearchprevious
The last entry talks about this
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a40cb085-c872-486b-9461-311f607cd69c/sql-native-client-100-registry-error?forum=sqltools
HKEY_LOCAL_MACHINE\SOFTWAR
On my sharepoint server I went to this registry location not much defined there
Am I missing something?
see attached key
sqlnative.reg
SQL Server client 10 is for MSSQL 2008 so I think that's correct for you.
ASKER
Vitor
Yes SQL Server Client 10 is the correct version for my SQL 2008 Server
My question is what is missing from the registry?
Where is this suppose to be?
Well, looks like stored procedure 'dbo.proc_MSS_Crawl' is missing.
Where can I find this?
Yes SQL Server Client 10 is the correct version for my SQL 2008 Server
My question is what is missing from the registry?
Where is this suppose to be?
Well, looks like stored procedure 'dbo.proc_MSS_Crawl' is missing.
Where can I find this?
Just want to make clear that I'm not a SharePoint guy but a SQL Server specialist.
I can't make any recommendation about the registry but that stored procedure should be created by the SharePoint. I had hope that applying a fix will recreate the SP but unfortunaly looks like it didn't.
I can't make any recommendation about the registry but that stored procedure should be created by the SharePoint. I had hope that applying a fix will recreate the SP but unfortunaly looks like it didn't.
ASKER
Victor
That's ok
Any idea where that procedure is stored?
I guess I need to check the search database?
That's ok
Any idea where that procedure is stored?
I guess I need to check the search database?
Yes, should be in the database. Open SQL Server Management Studio (SSMS) and connect to the correct SQL Server instance. Open the respective Database folder and then Programmability / Stored Procedures.
NOTE: If you have more than one SharePoint database you can search for the same SP in the other database to check if it exists there so you can copy to the one that is missing it.
NOTE: If you have more than one SharePoint database you can search for the same SP in the other database to check if it exists there so you can copy to the one that is missing it.
ASKER
Vitor
I found it in one database
Not sure which database the error is pointing to
I am wondering if it is a permission problem
The account in question is spservices. It only had connect permission
This is on the properties of the database I found the procedure in
Thoughts
I found it in one database
Not sure which database the error is pointing to
I am wondering if it is a permission problem
The account in question is spservices. It only had connect permission
This is on the properties of the database I found the procedure in
Thoughts
The account in question is spservices. It only had connect permissionThomas, by this MS article that user isn't requested to have permission on databases.
You may want to use the same article to perform a full check of permissions of your SharePoint accounts.
ASKER
Vitor,
After applying the CU and A SharePoint update came thru I restarted the server
Also gave authenticated users create ServiceConnectionPoint permission using ADSIEDIT on the Microsoft Sharepont Products CN
Now do not see event 57 for 3 days
Thanks for your help
After applying the CU and A SharePoint update came thru I restarted the server
Also gave authenticated users create ServiceConnectionPoint permission using ADSIEDIT on the Microsoft Sharepont Products CN
Now do not see event 57 for 3 days
Thanks for your help
Thomas, I'm very happy to hear that.
Cheers
Cheers
ASKER
Well guess what it came back again today.
Not happy about this error all the time
Not happy about this error all the time
Can you know the exact time the error occurred? If so, try to match the time with some process that were running in parallel. Something must be changing your database objects.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I don't know what action are you performing but it needs more parameters than it got.