Monday, April 30, 2012 10:34 PM
I have 2 warnings which won't go away...
one says my database is outdated... I have run the upgrade -inplace force 5 times already.. each time it says success, I then click on re analyse but the warning stays put!! I'm tearing my hair out..
The other warning says that I have fragmented indecis.. I clicked on that warning and click FIX IT... nothing... still there...
What am I supposed to do? It's driving me nuts.
or should I just get my coat, put my hat on and walk away..?
- Edited by dubsdj - MCITP Monday, April 30, 2012 10:43 PM
Tuesday, May 01, 2012 6:46 AM
check the above link if it did not give an answer please take a screen shot for the error so that we can help you
If the reply was helpful or informative, please remember to mark it as answer or vote as helpful. MCITP SHAREPOINT
Tuesday, May 01, 2012 7:41 AMOk I did that, and checked auto fix
warnings are still there..
Tuesday, May 01, 2012 3:25 PM
I've just run
PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
and then gone into the warnings, opened and re-analyzed the warning... Surely... that should do it????
Wednesday, May 02, 2012 8:56 AM
STILL THE WARNING WONT GO AWAY... I HAVE INSTALLED THIS 5 !##" times.. AND IT TELLS ME SUCCESS , YET THE WARNING IS STILL THERE!
personally I really think microsoft should have thought out the whole error process in SharePoint a little bit better...
It would have made so much sense to describe how exactly to fix the problem but no... that would be too sensible. Instead they just tell you to go to a webpage that has no useful information whatsoever.
IF this has any use, the databases that are outdated are:
- Edited by dubsdj - MCITP Wednesday, May 02, 2012 8:59 AM
Wednesday, May 02, 2012 2:53 PM
Here is some information on the errors you provided in your screenshot.
Databases running in compatibility range, upgrade recommended.
Search - One or more property databases have fragmented indices.
Wednesday, May 02, 2012 3:51 PMTo supplement the post above, if you database server is upgraded you still need to check your database compatibility mode itself on the database in sql. Right click your database, go to options and there you will see what mode it's in. SharePoint is pretty much compatible with all of them so you will want to use the highest level. Unless you have an old sql server this should fix it.
- Marked As Answer by Sally Tang Monday, May 14, 2012 1:33 AM
- Unmarked As Answer by dubsdj - MCITP Monday, May 21, 2012 8:24 AM
- Proposed As Answer by Jason WarrenMicrosoft Community Contributor Thursday, May 24, 2012 8:22 PM
- Unproposed As Answer by Jason WarrenMicrosoft Community Contributor Thursday, May 24, 2012 8:23 PM
Thursday, May 03, 2012 8:05 AMBut how do I upgrade it? I have all the latest and optional updates installed on the SharePoint Server... surely SQL R2 was one of those updates..
Thursday, May 03, 2012 8:11 AM
I'm in the SQL Management Studio, but I don't see the options that you describe? Or am I doing the wrong thing?
I have looked in my start menu, it says SQL Server 2008.... but I then went to windows updates ALL, I couldn't find an update for SQL
Thursday, May 03, 2012 9:14 PM
Your on the server options, not the database itself. You need to find your content database and see what the compatibility level is set at.
Tuesday, May 08, 2012 12:10 AM
I found one of the instances... checked its options.
it appears to be set to correct compatibility level?
even though central admin says it isn't..
- Edited by dubsdj - MCITP Tuesday, May 08, 2012 12:24 AM
Tuesday, May 08, 2012 12:12 AMDO you have screenshots? You don't connect to a database, you connect to an instance. Then there should be a databases drop down section which you shoudl see your content database there usually WSS_Content or something along those lines. You right click that and properties.
Tuesday, May 08, 2012 12:50 AM
isn't that what i have done in the post above?
Tuesday, May 08, 2012 1:18 AMyeah, i was responding to your post before you edited it ;P.
Tuesday, May 08, 2012 7:37 AMhehhehe
Monday, May 21, 2012 8:24 AM
Still not resolved by the way.
I have done everything mentioned here, and checked each database in SQL Server. All of them are set to the latest version.
I'm a bit worried about this warning now, if it falls out of the compatibility range will share point completely stop working?
Wednesday, May 23, 2012 8:49 PMTry upgrading to SQL Server Express 2008 R2
Thursday, May 24, 2012 8:32 AM
do you have a download link for this?
This is what I have got:
- Edited by dubsdj - MCITP Thursday, May 24, 2012 8:57 AM
Thursday, May 24, 2012 8:13 PMI missread the error, this isn't going to have anything to do with sql. it's something with your SharePoint not sql. Have you run the SharePoint configuration wizard on all your front end servers after upgrading? If so I would run them again anyway to see what happens. Then worse case maybe it's a stuck alert. Remove it then see if it comes back in later on.
Thursday, May 24, 2012 8:26 PMI'll give that a go
Thursday, May 24, 2012 8:30 PM
Have you recently applied any SharePoint updates?
What is the configuration database version listed in Servers in Farm (Central Administrator -> System Settings -> Manage servers in this farm)?
What are the versions listed in Mange Patch Status (Central Administrator -> Upgrade and Migration -> Check product and patch installation status)
In the affected databases, what are the versions listed in the dbo.Versions table (In SQL Management Studio: Expand the database -> expand Tables -> right click dbo.Versions -> Select Top 1000 Rows)?
Friday, May 25, 2012 8:11 AM
To answer the reply saying run the configuration wizard. Well the error has reappeared so that hasn't worked.
Friday, May 25, 2012 8:26 AM
I haven't applied any SharePoint updates. I don't know where I can do such a thing...
although I have run the database update over a million times.. (well not quite but..)
Database version is: 14.0.6114.5001
Manage Patch Status: 14.0.6029.1000
affected table 1:
affected table 2:
affected table 3:
Wednesday, May 30, 2012 8:11 AM
I'm really concerned now, if that compatibility range slips out of focus.. will my sharepoint just cease to work? That would be disasterous..
especially when it seems there is no apparent way to fix this :(
Wednesday, May 30, 2012 7:01 PM
So 6114 is the December 2011 CU and 6106 is the June 2011 CU, it looks like they didn't upgrade when the December CU was applied. You could try updating each database individually ($db = Get-SPContentDatabase [GUID]; $db.Update()), which may work.
Wednesday, May 30, 2012 7:20 PMYou did install the full SharePoint CU when you did updates right? and not just SharePoint Foundation? If you did just Foundation (if it lets you I don't know for sure) then this could be the cause since it wouldn't upgrade SharePoint Server databases. You might want to make sure you applied the full SharePoint Server CU then run the Configuration again and it should upgrde them automatically. Just a thought? Should be able to see by going to add/remove programs and checking the show updates box or whatever link they have now. Then look under sharepoint for your latest update installed and match up the KB article.
Thursday, May 31, 2012 7:52 AM
That shell command that you gave me Jason has confused me. Where would I attempt this? In the Powershell or something? Do you have a clearer description by any chance?
Turismon - I'm still a bit unsure when you say about installing the CU... what CU? I haven't done any windows updates with sharepoint included? Unless it does it itself without me knowing?
If somebody could point me in the right direction to get all these updates, would be great! I'm at a bit of a loss here.
I'm still learning this system.
Thanks very much!
Thursday, May 31, 2012 8:03 AM
Here are the updates that I have got applied? How can I get newer ones? or is it just automatic?
Thursday, May 31, 2012 9:27 AM
Well somone had to install SP1 :P. But it does look like you have an update of some sort to SharePoint Foundation. Your best bet would be to just update to the lasted CU (Cummlative Update). This gives you the latest build of SharePoint for all SharePoint Products and Foundation. You may want to read into doing the update but it's pretty easy.
You just download the package. Install it on your web front end servers, then once installed you run the SharePoint Product and configuration wizard and leave in the existing settings, this will run through and update your farm and databases. If you get an error installing it usually means because of some incompatable features on your site, I just run through it twice and it updates fine the 2nd time around running the configuration wizard. Processes takes about 10-20 minutes so be ready for a little bit of planned downtime.
Thursday, May 31, 2012 11:45 AM
ok, but I have sharepoint standard...At least I thought I did?!?
in my convert licence type, it says that I have:
I'm impressed with myself that I have managed to get as far as I have with Sharepoint, but now I think I'm a bit out of my depth with it LOL..
still, I won't give up.
Thursday, May 31, 2012 12:55 PM
Sorry, I was thinking out loud. The full directions are:
- Open an elevated SharePoint Management Console (right click -> Run as Administrator)
- At the prompt run the Get-SPContentDatabase cmdlet:
Get-SPContentDatabase -WebApplication http://yourwebappurl
- Get-SPContent database will return a list of content databases in the web application and their GUIDs. Select and copy the GUID from one of the databases with the issue.
- Run Get-SPContentDatabase again, this time telling it which DB to use (by pasting the GUID) and assigning the result to a variable:
$db = Get-SPContentDatabase -Identity [GUID]
- Run the Update() method on the content database:
Thursday, May 31, 2012 1:34 PM
I ran that shell command, all I get is this:
Which I assume is my whole Sharepoint database! I can't see the individual faulty tables... do I just update the whole thing?
- Edited by dubsdj - MCITP Thursday, May 31, 2012 1:44 PM
Thursday, May 31, 2012 1:39 PM
So I ran it anyway... did the db.update... it seemed to accept it but appeared to do nothing, just sat on the prompt?
do I need to do something else?
Thursday, May 31, 2012 2:29 PM
Thursday, May 31, 2012 2:38 PM
Here's the post I was thinking about. Similar issue -- after an upgrade the Search database was not upgraded. The OP had found a resolution online but could not validate that their database was affected. I was able to determine that the database needed upgrading, though I have no idea about the details of the resolution they were going to perform.
My suggestion to recreate the search database may apply if you're comfortable with noting the configuration and recreating the service. By creating the service from scratch, the databases would be created with the current version so the issue can be resolved.
The high-level process would be to:
- Create a new search service application in parallel to the existing search service application
- Transfer over the configuration from the old service to the new. Configuration to include would be content sources, scopes, properties, exclusions, etc.
- Set up crawls in the new service to validate the same number of items for all scopes (compared to the old service)
- Re-associate the web application to this new search application (Mange Web Applications -> Service Connections) to validate it is working before deleting the old service application.
- Delete the old service
Thursday, May 31, 2012 3:08 PM
Based on SQL Management screenshoot and warning info, the key is here : http://technet.microsoft.com/en-gb/library/hh564106.aspx.
You need to upgrade your SQL server to SQL Server 2008 R2.
SharePoint Architect, Singapore
Microsoft MVP | SharePoint Server | Singapore
Blog : http://blog.libinuko.com
Thursday, May 31, 2012 3:16 PM
the problem is, SQL server R2 does not appear in my windows update? So I don't know how I can get the upgrade for it.
Jason - That's a real pain, I have spent hours setting up my Search Service and Crawls :(
I really hope that I don't have to redo all that again.
Thursday, May 31, 2012 3:25 PM
You won't see updates for R2 because it's a separate product with new features. In other words, upgrading involves a purchase (software + licenses).
As for reconfiguring search, the SharePoint Enterprise Search Migration Tool for SharePoint Server 2010 (download site) can handle migrating your configuration to a new search instance. Personally I have never used the tool but it sounds promising.
Thursday, May 31, 2012 3:28 PM
I have just ran a query in Management Studio and it says I have:
Express Edition (64 bit) 10.0.5500.0 SP3
Thursday, May 31, 2012 3:29 PM
hmm ok wish me luck!
I'll let you know how I get on
Thursday, May 31, 2012 3:51 PMYou need to update to the latest CU first before anything else. You don't even have the CU right after SP1 which is pretty much a requirement with the SP1 install due to some major bugs, can't remember what but it was in the install instructions to do it. So I would start with the update I linked above to make sure you are running the newest build and that could solve you problem too. After that then you need to look at rebuilding your Search or whatever DB's.
Thursday, May 31, 2012 4:06 PMok Turismon, I will try that first.
Tuesday, June 05, 2012 11:12 PMhotfix for office? a bit confusing..
Wednesday, June 06, 2012 12:30 AM
hotfix applied, config wizard run
warning still present :(
I found this article, can anybody guide me through this?
I think I have to run the shell or something.
Wednesday, June 06, 2012 12:04 PM
I have deleted the warning.
I did that yesterday and it hasn't returned yet....
Monday, June 11, 2012 7:59 AM
OK now it's back again! Monday morning, great :(
I suppose I'm going to have to delete all my search settings :(
Tuesday, June 12, 2012 5:30 AMHonestly, at this point, just leave it, if everything is working and there are no issues, wait till the next CU comes out and see if the issue goes away after the updates are applied. It's just a service application, not like it messes with your main content databases or anything like that.
Tuesday, June 12, 2012 7:35 AM
Ok Turismon, thanks for the advice.
I'lll leave it for now, hopefully the CU will fix it next time.
I really appreciate your time and help on this.
Monday, September 24, 2012 10:18 PM
Just to say this still isn't fixed.... update run... still the same.
Monday, April 01, 2013 11:26 PM
The same problem just befell us. Warning (shown below) in the Health Analyzer Reports that just won't go away. According to Technet the solution is to let the health rule run. Yeah... not so much, Microsoft. Not so much.
Search - One or more property databases have fragmented indices.
2 - Warning
ExplanationHeavily fragmented indexes can degrade query and crawl performance.
RemedyIndex fragmentation can be remedied by either reorganizing an index or by rebuilding an index. Refer to SQL Server documentation for details on how to manually detect and repair fragmented indices. This job should be run outside your normal SQL Server maintenance window, during off-peak hours, as query and crawl performance will be adversely affected. Do not run this job during farm backup/restore/upgrade. Disable this job if your SQL database mirroring latency is excessive. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=167143".
Failing ServicesSPTimerService (SPTimerV4)
Tuesday, April 09, 2013 7:47 PM
Okay this was a strange fix for us, but it worked.
Looking through the ULS logs we saw the following errors:
SearchServiceApplication 'Search Service Application' is in restore/backup state. Skipping the rule. 0657476f-33d2-4707-905d-896091178675
04/01/2013 16:33:01.63 OWSTIMER.EXE (0x0DD8) 0x06AC SharePoint Foundation Health 8fs4 Medium Automatic repair is being attempted. 0657476f-33d2-4707-905d-896091178675
04/01/2013 16:33:01.79 OWSTIMER.EXE (0x0DD8) 0x06AC SharePoint Server Search HealthRule dls7 High SearchServiceApplication 'Search Service Application' is in restore/backup state. Skipping the rule. 0657476f-33d2-4707-905d-896091178675
04/01/2013 16:33:01.85 OWSTIMER.EXE (0x0DD8) 0x06AC SharePoint Foundation Health 8fs5 Medium The automatic repair Failed. 0657476f-33d2-4707-905d-896091178675
Went to Central Admin > Manage Service Applications > Search Service Application and saw that indeed the crawl status was stuck in a restore/backup state.
Try as I could, I could not get the Search Service Application out of that state. In the end I deleted the service application, re-ran the Health Analyzer Rule for "Search - One or more property databases have fragmented indices" and the warning message went away.
Luckily we didn't need our Search Service Application because we are using FAST for SharePoint 2010. For others, you will likely need to re-create the service application after you delete it (which sucks for you).