The Baretta

On the 14th of May 2015, Yammer deployed an update to their Embed Yammer Feed script that stopped any Yammer Feeds on SharePoint 2010 from working.  In our case, the Yammer Feed got stuck on 'Loading...' This error that is causing the Yammer Feed to fail to load is: Object doesn't support property or method 'forEach' .  yam-platform-feed-57f4f449766511e4f91eb519a39b2781.js, line 480 character 19099 The reason this is happening is because SharePoint Master pages have a line of code which forces all Internet Explorer Browsers to run in IE8 Compatibility Mode.  This is done to ensure all the ribbon & SharePoint functionality continues to work on new browsers. The line of code in question:  <meta http-equiv="X-UA-Compatible" content="IE=8"/> Hint: don't just remove this line of code!  you'll cause yourself a headache. The line that Yammer & Microsoft are taking is that if you plan to stick to SharePoint 2010, th...

Recently I was working with a client who's SharePoint 2010 environment had been poorly managed for years.  They had a single site collection on a single, large content database (650GB).  Not uncommon, however this environment also occasionally froze up, never loading any of the pages on any sites until an IISRESET was performed on the Web Front End (WFE). It started off only happening once a month, then moved to once a week, a few times a week, to 5-10 times a day... Begin Troubleshooting: The issue was around too many lists, and items within those lists having their own permissions. Each permission for an item counts as one row in the RoleAssignment table in the database. apparently they say a healthy DB will only have 200,000 rows in that table. Ours had 10,000,000 rows (You can check this by right-clicking the Database in SQL Management Studio and clicking Reports > Disk Usage by Top Tables.  Then look for the RoleAssignment Table).  and every time...

This is how bad it is to actually have to walk into shops and try and order something nowadays. The bonnie lass & I recently scored a $100 Adairs* gift card and thought it was about time to go purchase something fancy with the "cash".  Normally we'd just look online, which we did, but we couldn't use the gift card online.  So we headed off to the Analog store.  After perusing the store for quite some time and being unimpressed with the range & the prices, we decided upon a quilt cover that we thought suited our needs. After the store clerk tried calling multiple Adairs' stores in the region, it turned out they didn't have the quilt cover in our size (the ever illusive Queen size quilt).  No bother, we went back to the wall and chose another quilt cover that we were reasonably happy with. Oh what's that you say?  You checked out the back, tried calling a few stores and you don't have a Queen in this print either? hmmm.  OK.  Well fuck it,...

We were getting an issue on one of our Test Server WFE's where we were having two issues: - If you were trying to load an InfoPath form that contained a connection to the GetUserProfileByName Web Service, it would fail. - If you tried to connect to the site via SharePoint Designer, it would error out. SO!  If you get any of the following issues: In SP Designer: "The server could not complete your request.  For more specific information, click the Details button." "An error occurred while trying to fetch data from your SharePoint site.  Unexpected response from the server.  The content type of the response is "", The status code is "OK"." On an InfoPath Form: "There has been an error while processing the form.  An error occurred while trying to connect to a Web service" In SharePoint Logs: "The following query failed: GetUserProfileByName (User: xx\username, Form Name: Template, IP: , Connection Target:...

Just a quick one after some deep thought. Thoughts on the Future: If you have to create an InfoPath Form, you should be creating it as a List Form (if possible), not a Form Library.  The reason for this is ease of upgrade now that InfoPath will not be upgraded/supported by Microsoft. If you have to create a Form Library (because you form requires repeating tables/sections): I’ve decided that InfoPath forms should NOT be published as Content Types.  The only time it would be considered OK is if the form is very generic and is being used on multiple sites.  E.g. a Help Form which could be used by multiple departments without any modification. The main issue when publishing as a Content Type is that every field you promote to be visible in SharePoint has to be created as a Site Column. This means that even for a small form, for instance, a Personnel Access Form, you’d have to create Site Columns for fields like: Room Number or Access Hours, which would only ever be ...

Today I tried to log into our DocAve 6 Suite on our SharePoint 2010 environment and came across this error message: Sorry, the account has been disabled. Please contact the administrator My guess was that due to inactivity (hadn't logged in for a few months) the accounts had been disabled.  The problem was that every Administrator account had been disabled so I couldn't get in! After a quick call to AvePoint, the techies solved the issue quick smart.  Here's how you can save yourself a call and Enable a user accounts status again: Log onto the SQL Server that stores the AvePoint Databases. Navigate to AvePoint's ControlDB Right-Click >  Select TOP 1000 rows for the table dbo.AccountMapping In the results, you should see all your accounts, and a Status column which states whether the account is disabled or not (1 = disabled, 0 = enabled) Right click the dbo.AccountMapping table and Edit TOP 200 Rows , and modify the Status from 1 to 0 for the account in q...

Wow that's a long heading...  Let me explain how this is done, and why this path was chosen out of all the options. THE OPTIONS Still to come... SETTING UP There's quite a few large steps to get this done, so I'll split it into the following sections, ensuring we test along the way to make sure we haven't missed a step: Install & Configure Oracle Client on Web Server Create custom Web Service in Visual Studio Deploy Web Service to IIS Build InfoPath Form Configure InfoPath Services Deploy InfoPath Form to SharePoint Environment Install & Configure Oracle Client on Web Server Ask your Oracle DBA what version of Oracle the database is running on. Navigate here and download the corresponding Client (for this excercise get the 32-bit version if its an option):  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Copy to the IIS Server (Web Front End) Extract and install, here's the settings I used for the i...