Visio 2010/SharePoint 2010 Internal Error #3400 Action 1787 Check in file
Posted by Dave Mellors | Filed under Fixes to problems, SharePoint, Software
Problem:
Visio would display the following error when someone tried to check in a Visio file into a SharePoint 2010 Document Library:
Internal Error: #3400
Action 1787: Check in file
First try closing and reopening the file. Next try restarting Visio.
Cause:
One of the fields in the document library had been set to required and as no data had been put into that field the file wasn’t able to be checked-in.
Resolution:
In this case we were able to set the field to optional.
SharePoint 2010 slow extranet performance
Posted by Dave Mellors | Filed under Fixes to problems, SharePoint
A while back we extending our SharePoint 2010 server to provide an extranet enabling users to access SharePoint across the Internet. The main benefit being that users didn’t have to use VPN to access their content and data. The problem was that the extranet performance was too slow.
Part of the SharePoint extranet solution used ISA Server 2006 and my gut feeling was that somehow it was ISA 2006 that was causing the problem. I don’t have much experience with ISA 2006 and it is always easy to blame problems on the thing you know least about.
Fortunately I was investigating another SharePoint issue when I noticed that we didn’t have the output cache enabled in SharePoint. Turning on the output cache (Site Collection Administration, Output Cache Settings) and setting the Authenticated Cache Profile to Intranet (Collaboration Site) and now Extranet is performing as expected.
Looks like I will be spending a bit more time going through the SharePoint Cache documentation on Technet and its an important reminder that it easy to blame the thing you least know about when investigating an issue
Girls Football Team St Ives, Huntingdon, Cambridge
Posted by Dave Mellors | Filed under Uncategorized
Today the St Ives Rangers Under 9s football team played at a Girls Football Tournament hosted by Sawston United Youth FC.
We all had a great time and they done incredibly well especially as this was the first time they had played together as a team. Thank you to the organizer and all the other teams and helpers.
If you are know anyone looking for a Girls Football Team in the St Ives, Huntingdon/Cambridge area then please contact me (St Ives 464339) or pop along to one of our training session at the outdoor leisure centre in St Ives on a Tuesday evening 6pm-7pm.
SharePoint 2010 Diagnostics Studio Errors Event ID 6398
Posted by Dave Mellors | Filed under Fixes to problems, SharePoint
Having installed the SharePoint 2010 Diagnostics Studio on a server we were seeing hundreds of events with ID 6398:-
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 6398
Task Category: Timer
Level: Critical
Description:
The Execute method of job definition Microsoft.SharePoint.Diagnostics.SPSqlBlockingReportDiagnosticProvider (ID e0c0213b-63fc-4ede-acc9-7a569ba95812) threw an exception. More information is included below.You do not have permission to run ‘SP_TRACE_CREATE’.
and
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 6398
Task Category: Timer
Level: Critical
Description:
The Execute method of job definition Microsoft.SharePoint.Diagnostics.SPSqlBlockingReportDiagnosticProvider (ID e0c0213b-63fc-4ede-acc9-7a569ba95812) threw an exception. More information is included below.
The blocking query diagnostics provider could not set the ‘blocked process threshold’ for the sql instance SPSQL01. Blocking queries will not be captured in this instance. Error Code: User does not have permission to perform this action.
You do not have permission to run the RECONFIGURE statement.
The configuration option ‘blocked process threshold’ does not exist, or it may be an advanced option.
You do not have permission to run the RECONFIGURE statement.
Solution
On the SQL server make sure the account specified in the username of the events has ALTER TRACE and ALTER SETTINGS enabled. You can do this through Management Studio by selecting the username and changing the securables.
Tags: error, SharePoint 2010, SQL Server
SharePoint 2010 MsiInstaller PeopleILM Errors Event ID 1004, 1001, 1015
Posted by Dave Mellors | Filed under Fixes to problems, SharePoint, Software
After installing the SharePoint 2010 Feb 2011 CU and restarting the server I started seeing MsiInstaller Errors with event id 1004, 1001 and 1015.
The event details were:-
Source: MsiInstaller
Event ID: 1001
Level: Warning
Keywords: Classic
User: NETWORK SERVICE
Detection of product ‘{90140000-104C-0000-1000-1000000FF1CE}’, feature ‘PeopleILM’ failed during request for component ‘{1681AE41-ADA8-4B70-BC11-98A5A4EDD046}’
Source: MsiInstaller
Event ID: 1015
Level: Warning
Keywords: Classic
User: NETWORK SERVICE
Failed to connect to server. Error: 0×80070005
Resolution:
The resolution suggested by http://support.microsoft.com/kb/2473430 was to give the NETWORK SERVICE account access to the %programfiles%\Microsoft Office Servers\14.0 folder and sure enough that has done the trick.
Group By Totals, Page Navigation and Sort Only by Specified Criteria – bug?
Posted by Dave Mellors | Filed under Fixes to problems, How To, SharePoint
When someone comes and tells me that SharePoint is behaving weird I’m not normally surprised. The way SharePoint works and it’s interface are not exactly intuitive but I can normally work out an explanation for the “weird” behaviour but not this time.
The Problem
I have a document library with 16 documents in it.
3 documents have the reporting week set to Week 1
4 documents have the reporting week set to Week 2
5 documents have the reporting week set to Week 3
4 documents have the reporting week set to Week 4
As you can see below, the view is grouped by Reporting Week, sorted by Created and I have set the item limit to a low number just to recreate the problem without having to create 100s of documents.
Page 1.
The first page looks perfectly normal and the group total for Week 2 is correct so when I click the arrow to goto the next page I would expect to see the other 2 documents for Week 2 but instead I see…
Page 2.
Where have the rest of Week 2 gone? All I can see if the 5 documents for Week 3 – perhaps they are on the next page?
Page 3.
Nope. No Week 2 documents are on Page 3. I know I will click the arrow to go back to the previous page…
Page 2 again
Oh! Now one of the missing Week 2 documents has appeared – but I’m still missing one.
Anyway you get the idea – it’s in a right mucking fuddle with groups totals correct but documents missing and no wonder the poor users of this site are confused.
The Fix
The fix!
Uncheck the checkbox for “Sort only by specified criteria” and the views work correctly with all documents visible and no there aren’t any folders are permission inheritance issues.
Tags: SharePoint 2010
The type or namespace name ‘LayoutsPageBase’ does not exist in the namespace ‘Microsoft.SharePoint.WebControls’ (are you missing an assembly reference?)
Posted by Dave Mellors | Filed under SharePoint, Software Development
Image 1
After creating an empty SharePoint 2010 solution in Visual Studio 2010 I added an Application Page to the project but compiling failed and gave me the following error:
The type or namespace name ‘LayoutsPageBase’ does not exist in the namespace ‘Microsoft.SharePoint.WebControls’ (are you missing an assembly reference?)
Image 2
Using the object browser in Visual Studio I could see that the namespace Microsoft.SharePoint.WebControls didn’t contain LayoutsPageBase (Image 1) but when I viewed the same Microsoft.SharePoint.dll outside of Visual Studio (in Red Gate Reflector) I could see (Image 2).
The reason for this was quite simple when I created the SharePoint Project I had chosen to deploy it as a Sandbox Solution and application pages are not supported in sandboxed solutions. Selecting the project properties and changing the Sandboxed Solution property to False and it compiled successfully.
Tags: error, SharePoint 2010, Visual Studio 2010
SharePoint 2010 change order of User Profile properties
Posted by Dave Mellors | Filed under SharePoint, Software
Creating a new user profile property is really easy in SharePoint and there are lots of articles out there that describe how to do it but once you have created the custom property you find that it appears at the bottom of the user profile page and changing the order of the properties is a PITA – you have to click the up arrow next to the property to move it up one and each time you click the arrow the page refreshes so you have to scroll back down before you can do it again and if you have to move the property by 50 positions that 50 clicks and 50 page refreshes – AAAAARGH!
Fortunately you can do the same thing with some simple powershell:-
Add-Type -Path "c:\program files\common files\microsoft shared\web server extensions\14\isapi\microsoft.office.server.dll" $mySiteUrl = "http://yourmysitegoeshere" $site = Get-SPSite $mySiteUrl $context = Get-SPServiceContext $site $upConfigManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($context) $profilePropertyManager = $upConfigManager.get_ProfilePropertyManager() $upConfigManager.GetProperties().SetDisplayOrderByPropertyName("NameOfProperty", OrderNumber)
The powershell method is a much easier way to re-order things I’m sure you will agree 
Problem workbook opening in Excel in SharePoint 2010 – Internet Explorer
Posted by Dave Mellors | Filed under Fixes to problems, SharePoint
One person in the team wasn’t able to open an Excel spreadsheet on our SharePoint 2010 server. There were two errors depending on how you tried to open the file.
The first error was shown when the excel spreadsheet was being displayed in the browser and you clicked on the Open In Excel button.
“To open this workbook, your computer must have a version of Microsoft Excel installed and your web browser must support opening files directly from Excel in the browser.”
The second error was seen when trying to Open in Excel from the Document Library view.
“The document could not be opened for editing. A Microsoft SharePoint Foundation compatible application could not be found to edit the document.”
Solution
The answer to the problem was that they were using some sort of quick launch application which was always executing the 64 bit version of IE and switching to the 32 bit version worked.
Tags: internet explorer, Microsoft Office, SharePoint 2010
Outlook 2010: Ignore Conversation – does it just filter on subject line?
Posted by Dave Mellors | Filed under Software
I POSTED THIS @ SOCIAL TECHNET: 
Ignore Conversation – does it just filter on subject line? feel free to answer there or here.
Hi,
Does IGNORE in Outlook 2010 work based on conversation threads or just on the subject line? Why am I asking? Let me explain…
There was an ongoing internal email conversation with the subject line of “Parking” and so in Oulook 2010 I right clicked on the message and clicked on ignore. This took all the messages in that conversation thread (so I thought) and placed them in the deleted items folder. Great! What a simple idea and very effective! However, the boss later sends me an email (not a reply or forward) with the same subject line and that email also goes into deleted items – NOT GOOD AT ALL!
In Outlook 2010 looked in the Deleted Items folder and checked “Show conversations” and I can see it also removed some older emails with the same subject line. When I expand the view I can see clearly the actual conversation emails are linked but the others that also got placed in the deleted items are not linked. This makes me suspect that the Ignore button actually worked on the subject line and not on the conversation – please tell me it ain’t so!
Can anyone else confirm, deny, provide an explanation, workaround or fix?
Thanks, Dave
Tags: outlook 2010
