Special offer from O'Reilly for NIMTUG members

Along with your 35% discount off print books, you can now get 45% off all ebooks you purchase direct from oreilly.com for a limited time.

When you buy an O'Reilly ebook you get lifetime access to the book, and whenever possible we make it available to you in four, DRM-free file formats--PDF, .epub, Kindle-compatible .mobi, and Android ebook--that you can use on the devices of your choice. Our ebook files are fully searchable, and you can cut-and-paste and print them. We also alert you when we've updated the files with corrections and additions.

Just use code DSUG when ordering online at www.oreilly.com/store

Posted by Damien McGivern with 1 comment(s)
Filed under: ,

SQL Error 30080 - The full-text population on table [table name] cannot be started because the full-text catalog is importing data from existing catalogs.

Earlier today I received an error while running an update script on a client's SQL Server 2008 database. The script was trying to add FTS to a new field in the table

The error code 30080 had the message The full-text population on table [table name] cannot be started because the full-text catalog is importing data from existing catalogs. After the import operation finishes, rerun the command.

I search the web but didn't get much help as the only solution I could find involved restarting the SQL Server which wasn't an option. Also there wasn't any additional help in the SQL logs, I tried restoring the database and updating again (only same issue occurred) and even waited for an hour then trying the script again.

In the end my solution was to: 

 

In SQL Server Management Studio open Database > Storage > Full Text Catalogs > Right click Properties 

In the general setting select 'Rebuild catalog' and click OK.

Then I can run the script without errors.

 

I'm not sure why this issue occurred in the first place but at least the database is updated and running as expected now. Hope this helps anyone with the same issue.


 

Posted by Damien McGivern with no comments
Filed under: ,

UK Students to get Windows 7 for £30

From 1st Oct Microsoft are offering UK students with a valid uni/college email address either Windows 7 Home Premium or Windows 7 Professional for only £30

For more information see http://www.microsoft.com/uk/windows/studentoffer/

 

Posted by Damien McGivern with no comments
Filed under: , ,

Google Page Speed - Firefox/Firebug Add-On - Web Developer Tool

Yesterday google announced some new tools and services for web developers

We've just added new tools to the suite:

  • Web Elements allows your customers to enhance their websites with the ease of cut-and-paste. Webmasters can provide maps, real-time news, calendars, presentations, spreadsheets and YouTube videos on their sites. With the Conversation Element, websites can create more engagement with their communities. The Custom Search Element provides inline search over your own site (or others you specify) without having to write any code and various options to customize further.
  • Page Speed allows webmasters to measure the performance of their websites. Snappier websites help users find things faster; the recommendations from these latency tools allow hosters and webmasters to optimize website speed. These techniques can help hosters reduce resource use and optimize network bandwidth.
  • The Tips for Hosters page offers a set of tips for hosters for creating a richer website hosting platform. Hosters can improve the convenience and accessibility of tools, while at the same time saving platform costs and earning referral fees. Tips include the use of analytics tools such as Google Analytics to help webmasters understand their traffic and linguistic tools such as Google Translate to help websites reach a broader audience.

I'm impressed by Page Speed which is a Firefox/Firebug add-on for web developers. If you are familiar with Yahoo's YSlow (if not you should be) which is also a FF add-on it offers similar features in that it enables you to analyse the loading of web pages, rates how good the load time is and suggests how you could improve page load times.

A couple of features that I like that are not available in YSlow are:

Use Efficient CSS Selectors - lists those CSS selectors that may slow down the user's experience

 

 

 

Remove unused CSS - lists all the CSS that is not used in a page, great for helping you to remove CSS that is no longer used or refractor large CSS files.

 

 

 

Page Speed Activity - enables you to record your activity on a website over multiple pages and see what the browser is doing and spending time on.

 

 

I highly recommend checking out this add-on - I think it's a great tool.

 

kick it on DotNetKicks.com Shout it
Posted by Damien McGivern with 2 comment(s)
Filed under: ,

WCF CommunicationObjectFaultedException " cannot be used for communication because it is in the Faulted state" MessageSecurityException "An error occurred when verifying security for the message"

I've just spent a couple of hours trying to track down a customer issue with one of our WCF services. Below was part of the unit test I was suing to test the service.

using (var client = new MemberServiceClient())
{
    client.ClientCredentials.UserName.UserName = ConfigurationManager.AppSettings["username"];
    client.ClientCredentials.UserName.Password = ConfigurationManager.AppSettings["password"];
    client.CreateMember(mem);
    client.DeleteMember(mem.ExternalRef);
}

and the exception it was throwing was:

failed: System.ServiceModel.CommunicationObjectFaultedException : The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
	
	Server stack trace: 
	at System.ServiceModel.Channels.CommunicationObject.Close(TimeSpan timeout)
	
	Exception rethrown at [0]: 
	at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
	at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
	at System.ServiceModel.ICommunicationObject.Close(TimeSpan timeout)
	at System.ServiceModel.ClientBase`1.System.ServiceModel.ICommunicationObject.Close(TimeSpan timeout)
	at System.ServiceModel.ClientBase`1.Close()
	at System.ServiceModel.ClientBase`1.System.IDisposable.Dispose()

When I debugged the code the code actually fails at the CreateMember line not at the close method indicated at by the stack trace. Then I realised that this was one of thoes WCF silly moments - don't use using blocks!. Yes believe it or not if you use a using block around a WCF client and it fails when the using block calls the dispose method it throws a new excpetion masking the real exception.

 

The code below is some helper methods we use for making WCF clients are cleaned up correctly.

 

/// <summary>
/// WCF proxys do not clean up properly if they throw an exception. This method ensures that the service proxy is handeled correctly.
/// Do not call TService.Close() or TService.Abort() within the action lambda.
/// </summary>
/// <typeparam name="TService">The type of the service to use</typeparam>
/// <param name="action">Lambda of the action to performwith the service</param>

public static void Using<TService>(Action<TService> action)
	where TService : ICommunicationObject, IDisposable, new()
{
	var service = new TService();
	bool success = false;
	try
	{
		action(service);
		if (service.State != CommunicationState.Faulted)
		{
			service.Close();
			success = true;
		}
	}
	finally
	{
		if (!success)
		{
			service.Abort();
		}
	}
}

 

Changing the code to using our service helper methods.

 

ServiceHelper.Using(
    client =>

        {
            client.ClientCredentials.UserName.UserName = ConfigurationManager.AppSettings["username"];
            client.ClientCredentials.UserName.Password = ConfigurationManager.AppSettings["password"];
            client.CreateMember(mem);
            client.DeleteMember(mem.ExternalRef);
        }
    );

 

Now the code exposed the actual exception that was causing the issue.

 

failed: System.ServiceModel.Security.MessageSecurityException : An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail.
  ----> System.ServiceModel.FaultException : An error occurred when verifying security for the message.
	
	Server stack trace: 
	at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.ProcessReply(Message reply, SecurityProtocolCorrelationState correlationState, TimeSpan timeout)
	at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.Request(Message message, TimeSpan timeout)
	at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.DoOperation(SecuritySessionOperation operation, EndpointAddress target, Uri via, SecurityToken currentToken, TimeSpan timeout)
	at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.GetTokenCore(TimeSpan timeout)
	at System.IdentityModel.Selectors.SecurityTokenProvider.GetToken(TimeSpan timeout)
	at System.ServiceModel.Security.SecuritySessionClientSettings`1.ClientSecuritySessionChannel.OnOpen(TimeSpan timeout)
	at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
	at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
	at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
	at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
	at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
	at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
	at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
	at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)


This exception had me stumped as I had never come across it before but after a bit of digging I discovered that the server time was 7 minutes late and that changing the time fixed the issue. Still trying to figure out how the server's time got out of synced.

Posted by Damien McGivern with 7 comment(s)
Filed under: ,

XML Linq requires correct namespace for all XElements

I've been teaching myself ASP.Net MVC during any free time I get at the weekends. I started a simple test project which has developed into the events section on NIMTUG. Yesterday I was looking for a way to easily create search engine sitemaps for the event and sepaker pages and I found Robert Tennyson's post Dynamic sitemaps with ASP.NET MVC which seems very easy indeed. With a couple of changes I had the sitemaps working and so submitted them to google only to be notified a couple of hours later that they had failed with the error "Invalid Namespace".

I should have validated the outputed Xml using the Google Sitemap Validator but instead I had only tested the xml output in the browser which hid the root namespace (xmlns attribute) but more importantly also hid an empty namespace on all the url elements.

 

<?xml version="1.0" encoding="utf-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
  <url xmlns="">
    <loc>http://nimtug.org/events/speaker/details/41</loc>
   <lastmod>2009-05-23</lastmod>
  </url>
  <url xmlns="">
    <loc>http://nimtug.org/events/speaker/details/23</loc>

    <lastmod>2009-05-23</lastmod>
  </url> 

 

It appears that with LINQ to XMl you have to add the correct namespace to every XmlElement which seems like over kill to me as the child elements are supposed to inherit their namespace from their parent (as you would expect) - if anyone knows of an easier way please let me know. My fix was to just add the namespace to each XElement constructor.

protected string GetAlsoluteUrl(object routeValues)
{
    var values = new RouteValueDictionary(routeValues);
    var context = new RequestContext(HttpContext, RouteData);

    string url = RouteTable.Routes.GetVirtualPath(context, values).VirtualPath;

    return new Uri(Request.Url, url).AbsoluteUri;
}

protected ActionResult CreateSiteMap<TModel, TID>(IEnumerable<TModel> items, Func<TModel, TID> getID,
                                                  string controllerName, string actionName)
{
    // XML LINQ requires that ALL XElements have the correct namespace 
    XNamespace xmlns = "http://www.sitemaps.org/schemas/sitemap/0.9";

    var root = new XElement(xmlns + "urlset");
    foreach (TModel item in items)
    {
        object routeValues =
            new
                {
                    id = getID(item),
                    controller = controllerName,
                    action = actionName
                };


        // only add last modified element if we can get the date
        XElement lastMod = null;
        var lm = item as IObjectTimes;
        if (lm != null)
        {
            lastMod = new XElement(xmlns + "lastmod", (lm.Updated ?? lm.Created).ToString("yyyy-MM-dd"));
        }
        root.Add(new XElement(xmlns + "url",
                              new XElement(xmlns + "loc", GetAlsoluteUrl(routeValues)), lastMod
                     )
            );
    }


    using (var memoryStream = new MemoryStream())
    {
        using (var writer = new StreamWriter(memoryStream, Encoding.UTF8))
        {
            root.Save(writer);
        }

        return Content(Encoding.UTF8.GetString(memoryStream.ToArray()), "text/xml", Encoding.UTF8);
    }
}
Posted by Damien McGivern with 1 comment(s)
Filed under: , ,

PDF SQL Server Cheat Sheet

MVP Pinal Dave has posted his SQL Server cheat sheet as a PDF download.

Posted by Damien McGivern with no comments
Filed under:

My Phone public beta opens

Microsoft has opened the beta of the My Phone service to the public. Only Windows Mobile phones with version 6 and up are supported.

It allows you to backup you data and access it from you My Phone web account and more

Microsoft My Phone

Posted by Damien McGivern with no comments
Filed under:

Stop Forum Spam wrapper and ASP.Net HttpModule

Stop Forum Spam has an API that allows you to query their spam list using a REST call. I've written a simple wrapper for their API and created a HttpModule that checks the clients IP against the spam list. Making http requests is very expensive so the result of the IP check is cached for 24 hours making the performance impact to the end user only slightly noticeable on the first request.

The download includes the http module dll, test website and a couple of unit tests.

When I get a bit more time I'll look into improving the performance, perhaps async using requests. Now off to finish my online xmas shopping.

 

Download Code

Download DLL

Posted by Damien McGivern with no comments
Filed under:

ReSharper 4 doesn't like VS 2008 SP1/ .Net 3.5 SP1

 I’m a big fan of ReSharper and lately I’ve been installing the nightly builds which has resulted in a little pain with some dodgy builds but overall I’m still allot more productive. Yesterday I noticed that Visual Studio 2008 SP1 Beta had been released and as I’d no other VS beta software installed (there are issues with it if you do) I went ahead and tried it out. The installer is very small and downloads the required files before continuing the install. I’m not sure how long it took as I went off to play Grand Theft Auto 4 on the PS3 but about 1 hour later I returned to the laptop to discover that the install had failed. I opened up VS and checked the about dialogue – no mention of SP1 so I left it. This morning when I opened up VS I noticed that ReSharper no longer worked. I downloaded the latest nightly build and installed but still ReSharper didn’t load within VS. Checking the Installed Programs I noticed that .Net 3.5 SP1 was listed (I assume the VS SP1 installer installed this but didn’t uninstall after it failed) and once this was uninstalled ReSharper came back to life. Pity as I was looking forward to checking out some of the bug fixes and performance improvements with WCF which SP1  claims to add. I'm running Vista Ultimate 64 bit but haven't seen any other reports of issues.

 

Update: 19 May 2008

seems that my install may have failed due to issues with certain KB's see http://blogs.msdn.com/webdevtools/archive/2008/05/15/remove-kb945140-before-installing-visual-studio-2008-sp1-beta.aspx - don't think I'm going to try it again though untill I know R# will work. Some people do seem to have it working (with issues) though http://www.intellij.net/forums/thread.jspa?threadID=275245&tstart=0

VS 2008 Web Development Hot-Fix Roll-Up Available

Some initial performance glitches with VS 2008 Web Development have been resolved and a patch has been released. Read more about it on Scot Guthrie's blog post http://weblogs.asp.net/scottgu/archive/2008/02/08/vs-2008-web-development-hot-fix-roll-up-available.aspx 

Direct download https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=10826 (requires a live account)

 

Posted by Damien McGivern with no comments
Filed under: , ,

Vista SP1 & Windows Server 2008 both RTM

 

Vista SP1 and Windows Server 2008 have finally been RTM. For those of you also on the W2K8 beta program you will be able to download from the connect website. Unfortunately Vista SP1 hasn't been made available to beta testers on connect yet.

http://windowsvistablog.com/blogs/windowsvista/archive/2008/02/04/announcing-the-rtm-of-windows-vista-sp1.aspx 

http://blogs.technet.com/windowsserver/archive/2008/02/04/windows-server-2008-rtm.aspx 

Posted by Damien McGivern with no comments

WCF requires precompiled ASP.Net sites to be updatable

Today I was testing a deployment ASP.Net site build that I added some WCF services to. All other non deployment builds passed all testing so I was stumped when testing one of the services I got the following error.

 

Value cannot be null.
Parameter name: key

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentNullException: Value cannot be null.
Parameter name: key

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentNullException: Value cannot be null.
Parameter name: key]
System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument) +51
System.Collections.Generic.Dictionary`2.FindEntry(TKey key) +5295964
System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value) +20
System.ServiceModel.Activation.MetabaseSettingsIis.GetTransportSettings(String virtualPath) +154
System.ServiceModel.Activation.MetabaseSettingsIis.GetAccessSslFlags(String virtualPath) +9
System.ServiceModel.Activation.HttpHostedTransportConfiguration.GetBaseAddresses(String virtualPath) +113
System.ServiceModel.Activation.HostedTransportConfigurationManager.InternalGetBaseAddresses(String virtualPath) +146
System.ServiceModel.HostingManager.CreateService(String normalizedVirtualPath) +162
System.ServiceModel.HostingManager.ActivateService(String normalizedVirtualPath) +46
System.ServiceModel.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath) +738

[ServiceActivationException: The service '/demo2/services/memberservice.svc' cannot be activated due to an exception during compilation. The exception message is: Value cannot be null.
Parameter name: key.]
System.ServiceModel.AsyncResult.End(IAsyncResult result) +7571873
System.ServiceModel.Activation.HostedHttpRequestAsyncResult.End(IAsyncResult result) +4504815
System.ServiceModel.Activation.HostedHttpRequestAsyncResult.ExecuteSynchronous(HttpApplication context, Boolean flowContext) +288
System.ServiceModel.Activation.HttpModule.ProcessRequest(Object sender, EventArgs e) +273
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +177


Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
 

 

 

The only difference with the deployment build is that the website is precompiled and the assemblies merged. Then I checked the even log and noticed that for every request of  memberservice.svc the following two errors occurred.

 

Event Type:    Error
Event Source:    System.ServiceModel 3.0.0.0
Event Category:    WebHost
Event ID:    3
Date:        30/01/2008
Time:        11:30:35
User:        NT AUTHORITY\NETWORK SERVICE
Computer:    ELGRECO
Description:
WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/30607723
 Exception: System.ServiceModel.ServiceActivationException: The service '/demo2/services/memberservice.svc' cannot be activated due to an exception during compilation.  The exception message is: Value cannot be null.
Parameter name: key. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: key
   at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
   at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
   at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value)
   at System.ServiceModel.Activation.MetabaseSettingsIis.GetTransportSettings(String virtualPath)
   at System.ServiceModel.Activation.MetabaseSettingsIis.GetAccessSslFlags(String virtualPath)
   at System.ServiceModel.Activation.HttpHostedTransportConfiguration.GetBaseAddresses(String virtualPath)
   at System.ServiceModel.Activation.HostedTransportConfigurationManager.InternalGetBaseAddresses(String virtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)
 Process Name: w3wp
 Process ID: 708

Followed by:

Event Type:    Error
Event Source:    System.ServiceModel 3.0.0.0
Event Category:    WebHost
Event ID:    3
Date:        30/01/2008
Time:        11:30:35
User:        NT AUTHORITY\NETWORK SERVICE
Computer:    ELGRECO
Description:
WebHost failed to process a request.
 Sender Information: System.ServiceModel.Activation.HostedHttpRequestAsyncResult/49972132
 Exception: System.ServiceModel.ServiceActivationException: The service '/demo2/services/memberservice.svc' cannot be activated due to an exception during compilation.  The exception message is: Value cannot be null.
Parameter name: key. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: key
   at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
   at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
   at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value)
   at System.ServiceModel.Activation.MetabaseSettingsIis.GetTransportSettings(String virtualPath)
   at System.ServiceModel.Activation.MetabaseSettingsIis.GetAccessSslFlags(String virtualPath)
   at System.ServiceModel.Activation.HttpHostedTransportConfiguration.GetBaseAddresses(String virtualPath)
   at System.ServiceModel.Activation.HostedTransportConfigurationManager.InternalGetBaseAddresses(String virtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   --- End of inner exception stack trace ---
   at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.End(IAsyncResult result)
 Process Name: w3wp
 Process ID: 708

 

 After a bit of searching I found the following post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1150859&SiteID=1 which states that WCF hosted in a precompiled ASP.Net site requires the site to be updatable. So adding the -u switch to our build scrip which calls aspnet_compiler solved the problem.

 

Posted by Damien McGivern with 8 comment(s)
Filed under: , , ,
More Posts Next page »