Wednesday, December 9, 2009

Sharepoint - Vista Explorer/Windows View

Issue: User unable to open Explorer View or Open in Window Explorer in Document Libary.

Replication: This problem seems to be a Vista Problem, users in XP do not experience this. To replicate have a user go to a document library and either click the drop down arrow next to View and click Explorer view, or click Actions Open in Window explorer. Error: Your client does not support opening this list with windows explorer. May also see: “Please wait while Explorer View is loaded” or user may not see anything but a blank window, but nothing ever loads.

Workaround/Fix: One workaround is to add a link to the website to the users Network places.

Detailed Instructions: ADMINS proceed with caution I have not fully tested this solution. I know it works, but am not sure what users may have access too if they click on the network place and browse the website directly.
1) On the users machine - Copy the URL of your SharePoint site.
2) Click the Vista “Ribbon”, Click Computer, Right under Network Location, Click Add a new Network Location.
3) Click Next, Click “Choose a custom Network”, click Next.
4) Paste your URL into the Internet or network address box. REMOVE everything after the website address. For example if your URL is: http://mysharepoint.com/website/documentlibrary/Forms/AllItems.aspx. Then remove everything after .com/. Your URL will now look like: http://mysharepoint.com/ Click Next.
5) Enter the name of your website. Click ok.

ADMINS: You may want to add the link directly to the site collection the Document Library is in. This maybe the safer way to do this. Will test more once I find a normal user to test with. In this case use the URL: http://mysharepoint.com/website/.

Feedback is appreciated.

Thursday, June 14, 2007

12.0.4.0 - _PROF upgrade fails fix

[SPManager] [ERROR] [6/8/2007 4:19:44 PM]: Upgrade [SharedDatabase Name=[DBName]_PROF Parent=SPDatabaseServiceInstance] failed.

[SPManager] [ERROR] [6/8/2007 4:19:44 PM]: Violation of UNIQUE KEY constraint 'IX_DataServicePropMap_ServerIDPropName'. Cannot insert duplicate key in object 'DataServicePropMap'.

Problem: Above Errors found repeatedly in upgrade.log when attempting to migrate from 2003 to 2007 using any of the 3 migration methods.

Symptoms: Errors found in upgrade.log. When attempting an inplace or gradual upgrade, upgrade fails. When attempting a SSPrestore using database migration receive error: Action 12.0.4.0 of Microsoft.SharePoint.Portal.Upgrade.ProfileDatabaseSequence failed, and SSP shows as provisioning failed.

Fix:
In SQL open your _Prof DB. Open the table DataServicePropMap. Delete all the rows where bRecordIdentifier = 0. You should now be able to upgrade normally with no failures. If you are already in the middle of an upgrade just reboot your server hosting SharePoint (This restarts the upgrade job). Alternately you can got to /_layouts/1033/MgrProperty.aspx and delete any custom field you may have created.