Ben There, Done That

As discovered by Todd Carter there is a memory leak in SharePoint 2007.  He has outlined the details as well as a work around to the fix the memory leak.

I decided to do some testing with it, however, when I compiled the dll, placed it into the GAC, and changed my global.asax file, I started getting this error: “Could not load file or assembly ‘[Assembly Name]’ or one of its dependencies.  The system cannot find the file specified.”

After digging into this error for a while I discovered my problem.  This may be fairly obvious to developers out there , but coming at this from more of a SharePoint administrator type roll, I missed this one step that isn’t outlined in the steps provided by Todd.

After deploying your dll to the GAC, you need to open up your web.config and place

<add assembly="[Assembly Name], Version=[Version Number], Culture=neutral, PublicKeyToken=[Public Key Token]" />

in the web.config file of the web application you wish to apply your fix to.  This line should be added between <assemblies> and </assemblies> in the web.config file.

All of the information: Assembly Name, Version Number and the Public Key Token can be found by right clicking on your dll in the GAC and viewing the properties of the dll.

Once I added the assembly to my web.config for the web applications I was trying to apply the fix to, everything worked as expected.

Ben Customizations, Development, SharePoint, SharePoint 2007 Development, Errors, Memory Leak, SharePoint, SharePoint 2007

I was working with SharePoint surveys the other day and discovered an old issue working with surveys and Microsoft Office that appears to have resurfaced.

We were trying to see what other reports we could generate from a SharePoint survey.  Naturally with the option to export to Excel, we figured why not just export all the survey data into Excel and play with it there.  To test it out I tried to get a variety of questions in the survey, one of these questions being the rating (matrix) survey question.

I created a few responses to the survey and attempted to export the list data to Excel (I’m running 2010 Beta).  Everything came over well with the exception of the matrix type questions.  I did some searching and this was also an issue with Excel 2003.  However, people said it was resolved with Excel 2007.  I installed Excel 2007 and sure enough the matrix questions imported into Excel 2007 just fine.  I tried Excel 2010 once more and the values still failed to come over.

So, it appears that the problem with importing matrix type of questions from SharePoint 2007 to Excel 2003 has returned in Excel 2010.  Granted, this is the beta, so maybe it will be fixed by the release.

I also want to do some testing with SharePoint 2010 surveys, Excel 2010 and possibly PowerPivot.  I’ve been reading some great things about PowerPivot but haven’t had much of a chance to play with it for myself.  Once I get a chance to do some testing with these tools I’ll write a new post.  Hopefully there will be some good news about doing more in depth analysis of SharePoint Survey results using these new tools.

Ben Office 2010, SharePoint, SharePoint 2007, SharePoint 2010 Excel 2010, Office 2010, PowerPivot, SharePoint 2007, SharePoint 2010, SharePoint Surveys

After installing Office 2010 on my computer (both laptop and desktop) running Windows 7 RTM, I had a problem opening any Office files stored in our SharePoint 2007 environment.  I would click on a file to open it or edit it, the Office 2010 application would open, however, the file wouldn’t open.

I could download the document to my desktop, open it, edit it, and re-uploaded it, but this fare far from ideal.  I could link the site to Colligo, but I don’t want to have connect to a site every time I want to open a document.

Finally, today I ran across this helpful string of comments on the TechNet forum – http://social.technet.microsoft.com/Forums/en-US/office2010general/thread/230fc30a-8922-4c75-a8fc-540b0282dff8

In short, the solution is to make a fake proxy in IE:

1. Open up Internet Explorer
2. Click Tools –> Internet Options
3. Click the Connections tab
4. Click LAN settings
5. Check “Use a proxy server for your LAN (These settings will not apply to dial-up or VPN connections).”
6. Enter 127.0.0.1 for the address
7. Click Advanced
8. In the Exceptions type: *.*
9. Click OK, OK and OK

You should now be able to browse to a SharePoint site, click an Office document and have it successfully open in your Office 2010 client.  This successfully worked for me with MOSS and reports in the TechNet forum are that it works with WSSv3 as well.

admin Office 2010, SharePoint, SharePoint 2007 Documents, Office 2010, SharePoint, SharePoint 2007, WSSv3

Just this morning, I was working with a client who had some errors pop up in their SharePoint farm.  I looked at the Windows Event log and didn’t find a whole lot of helpful info.  So, I moved on to the ULS logs, to my dismay, they were almost all 0 KB with a couple of files that were 2 KB or 3 KB.

I opened up the files that appeared to have some text in them and found the following entry:

“08/20/2009 10:38:58.08     wsstracing.exe (0×07A0)                     0×07CC    ULS Logging                       Unified Logging Service           uls1    Monitorable    Tracing Service lost trace events.  Current value 5.”

Naturally I went to Google with my error as I had never seen this before and found this blog post: http://weblogs.asp.net/jimjackson/archive/2008/05/13/sharepoint-logs-tacing-service-lost-trace-events.aspx by Jim Jackson.  I restarted the Windows SharePoint Services Tracing service just as he suggested and bingo! My ULS logs started recording events again.  Thanks Jim!

Ben SharePoint 2007 SharePoint, SharePoint 2007, ULS Logs, Windows SharePoint Service Tracing

Thanks to a co-worker for this blog post – http://msfarmer.blogspot.com/2009/07/sharepoint-versions.html

It lists all of the updates for MOSS and WSS 2007 along with what version number the update is.  I’ve had several times when I’ve wanted to know exactly what version number went with which update and was never able to find a comprehensive list (I would always ask this co-worker if he knew

So, if you aren’t sure if an update fully installed (I’ve had it happen before) or you can’t remember the last update you installed into your farm, head over to the Microsoft Farmer blog and check it out!

Ben SharePoint, SharePoint 2007 MOSS, SharePoint, SharePoint 2007, Updates, Versions, WSS

After a little over a month since my last blog post I’m back.  The lapse in posting had several contributing factors.  The biggest being that within the last month I go married and then went on a week long honeymoon to St. Lucia with my beautiful bride. (I’ll maybe put up a few pics when we get our favorites).  That combined with the increased workload to make up for the time off didn’t give me a lot of time to blog.  I’ve also been eagerly awaiting the Office 2010 suite of products to start working with.

So, rather than posting sever updates, I figured I would post one update that highlights what has been going one.

First, I have the SharePoint 2010 bits that I have started testing.  Due to an NDA with Microsoft, I can’t talk about them other than if you want to get a peak, head over to http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/default.aspx where MS has posted 3 videos giving you a sneak peak at SharePoint 2010.

Secondly, I have also installed the Office 2010 clients.  I was accepted into the Office 2010 beta program on http://connect.microsoft.com.  There is no NDA in place for the clients, so there may be more posts following on that topic.

Also, Windows 7 and Windows Server 2008 R2 have both RTM’d.  You should expect to see them on MSDN and TechNet the beginning of August.  I’ve seen several dates, so I won’t try to predict, just keep your eyes open. You can see the official Microsoft Post here.

The June Cumulative Update Package for SharePoint 2007 has also been released.  Head over herehttp://blogs.msdn.com/sharepoint/archive/2009/07/20/june-cumulative-update-packages-ready-for-download.aspx to get the download links and more information about the update.

I read an article on The Seattle Times website that in an attempt to compete with Google Docs, Microsoft will be releasing a free web based version of Microsoft office. Read the Full Article here.

I think that’s all I have for now, stay tuned as more and more information becomes available on the Office 2010 suite of products.

Ben Office 2010, SharePoint, SharePoint 2010 Microsoft, MOSS, SharePoint, SharePoint 2007, SharePoint 2010, Windows 7, Windows Server

First of all, I realize I’m a little behind on this post.  The truth is I started it over a week ago.  The day after I started it, I lost my access to TechNet.  It was a weird glitch with TechNet and I never found out what it was, but I was able to get to it again about 2 1/2 days later.  As Murphy’s law would have it, shortly after that I had computer problems that let to a format.  But finally, here it is:

Microsoft has add an stsadm reference on TechNet allowing you to “navigate through the stsadm commands with both WSS and SharePoint.  You can filter commands are not in the UI, which commands were new with SP1, SP2.  You can also view al the commands with a key that lets you see the same thing as the filters above.

The commands are also categorized so you can see which commands are available for Import and Export, General, Features and Solutions, etc.  But, enough with my babling, go check it out for yourself!!

WSS -  http://technet.microsoft.com/en-us/windowsserver/sharepoint/dd418924.aspx

MOSS – http://technet.microsoft.com/en-us/office/sharepointserver/cc948709.aspx

Ben SharePoint MOSS, SharePoint, SharePoint 2007, SP1, SP2, stsadm, WSS

True to their word, Microsoft release SP2 for their Office suite today.  It includes SP2 for Office 2007, WSSv3 and MOSS 2007.  For a little more detail on the updates, SharePoint Joel has a great blog post.

Of, if you just prefer to go straight to the downloads the links are below:

Office 2007 SP2

Office 2007 Language Pack SP2

WSSv3 SP2

WSSv3 Language Pack SP2

MOSS 2007 SP2

MOSS 2007 Language Pack SP2 (x86)

MOSS 2007 Language Pack SP2 (x64)

Ben SharePoint MOSS, Office, Office 2007, Service Pack 2, Service Packs, SharePoint 2007, SP2, WSS, WSSv3

This past Wednesday, Microsoft announced the scheduled release of the Office Suite Service Pack 2.  This includes Service Pack 2 for SharePoint.  You can read the official announcement here.  For those of you that just want to know the date, it is between February and April of 2009.

admin SharePoint Microsoft, Service Packs, SharePoint 2007