Having taken delivery of a new E5500, we configured the machine (not that it took much effort, as it came with none of the usual “crap” that is pre-installed") and attempted to connect it to our WiFi in the office.

Every time it returned “Windows was unable to connect to CrocusWiFi”

Our network is nothing out of the ordinary – We use a plain old Belkin F5D7632 router, with WPA2-Personal security, TKIP. Nothing fancy, and plenty of other devices use this without a problem.

A phone call to Dell technical department predictably concluded that it must be our WiFi networks’ fault (not their laptop, of course) despite several devices (including other Dell machines) being successfully connected, without a hitch.

They agreed to replace the unit.

When the replacement unit turned up, the exact same error occurred.
I haven’t had time to dig around trying to find out what the problem is, however I suspect it’s a software issue.

If anyone can shed any light on this, please feel free to comment!

I was trying to install Windows Server 2008 Standard x64 on one of our servers, intended to be an internal SQL database server.
It’s equipped with a 3Ware 9650SE 8LPML RAID controller. It has 8x 250gb hard drives.
I’d set up 2 units:

  • RAID 0 (Stripe) – For the OS (2 drives)
  • RAID 10 (6 drives)

I downloaded the drivers from the 3Ware website, and put them on a USB flash drive.
I should point out at this point, that the download is circa 50mb – the actual drivers are only about 150kb… the rest is a .exe file used for upgrading drivers on an existing system.

You then go through the setup screens, and clicked Load Drivers where you are supposed to select a drive to install on. It finds the USB drive, select the drive… all seems ok so far.

Upon selecting the smaller of the 2 units (my RAID 0 stripe) and pressing next, I got a screen saying:

Windows Could not determine if this computer contains a valid system volume

Uh oh!

After much Googling, I found the problem was in the BIOS – and that the USB drive should be de-selected as a boot device.

I restarted, pressed F2 to get into the BIOS setting, and de-activated the USB drive.

However – this did not work! I still had the same error!

Here are the steps that I used to finally get it to work:

  1. Put driver files on USB floppy drive (not sure if this is significant, but it worked for me)
    Remember, the actual driver files are < 200kb – it’s just the EXE file that’s large
  2. Restart machine, leaving USB (floppy) plugged in
  3. Enter BIOS setup – Boot sequence.
  4. Deactivate USB  from the Boot sequence
  5. Make the 3ware RAID controller #1 in the sequence
  6. Save & Exit
  7. Enter Windows 2008 setup again, this time, it should work

I think the key is point #5 – You MUST make the RAID controller the first in the boot sequence.

What effect using the floppy drive had, I’m unsure. Probably nothing.

Upgrading from Navision 4 to Navision 5 – Database Error

This is a tad of a messy blog post, so apologies for that, however it’s mainly for my own reference.

Here at Crocus, we run Navision to handle product inventory, orders, and the like…
We wanted to upgrade from version 4, to version 5.

After following the upgrade instructions, I got this error:

Msg 8662, Level 16, State 0, Line 1
Cannot create the clustered index "VSIFTIDX" on view "Nav5.dbo.Crocus Live$OrderRequestDetail$VSIFT$1" because the view references an unknown value (SUM aggregate of nullable expression). Consider referencing only non-nullable values in SUM. ISNULL() may be useful for this.


There wasn’t anything obviously wrong.
So I opened up SQL Profiler, and re-ran the update process in the Navision client, to capture the exact SQL queries that were causing the error….

I saw it created a view called Crocus Live$OrderRequestDetail$VSIFT$1

Heres the create view script:

It was failing on the following query:

Problem was:

Some of the columns specified as “boolean” within Navision, were in fact NULLABLE tinyint columns within SQL Server.

I suspect that this was due to some legacy version of SQL not supporting bit columns, or something along those lines…

Anyway, none of the values in the column (close to a million rows within the table) was null, so I changed the datatype to BIT and set NOT NULL. I did this for each of the columns in the table which should of been a boolean (and were specified in the CREATE VIEW statement (in my case was Amount, AmountIncludingVAT and PaidFor)

This immediately solved the “Cannot create the clustered index” problem

Whilst setting up an application to run on my local machine (running Vista 64bit) I encountered this error:

Could not load file or assembly ‘ChilkatDotNet2’ or one of its dependencies. An attempt was made to load a program with an incorrect format.


Obviously, the application uses ChilKat components, but it would seem that the version we are using, is only the 32bit version.

To resolve this error, I set my app pool in IIS to allow 32bit applications.
Open up IIS Manager, right click on the app pool, and select Advanced Settings (See below)


Set IIS AppPool Advanced Settings

Then set “Enable 32-bit Applications” to True.

Enable 32-Bit Applications

All done!

I downloaded the latest release of the Dot Net Nuke Starter Kit (Version 4.9.4  released on 23rd June 2009)

I followed the instructions to install the Visual Studio templates etc… as found here
They are a little outdated, but the same process still applies.

Upon installing it, loading a new website, I selected the DotNetNuke Web Application Framework (pictured below)

DotNetNuke Web Application Framework

The template began loading, and after a short while, two errors popped up:

The file Blog_03.05.00_Install.resources could not be found within the project templates.
Continuing to run, but the resulting project may not build properly.

The file ActiveDirectory_01.00.05_install.resources could not be found within the project templates.
Continuing to run, but the resulting project may not build properly.

(see below)

The file Blog_03.05.00_Install.resources could not be found within the project templates.  Continuing to run, but the resulting project may not build properly.
The file ActiveDirectory_01.00.05_install.resources could not be found within the project templates.  Continuing to run, but the resulting project may not build properly.

Of course, I Googled the error.
It seems other people are having the same problem as me – here and here.

That got me thinking – it must be something actually missing from this release of the template.

I opened my Visual Studio Templates Directory > Project Templates > Visual Web Developer > Visual Basic
In there, there is a DotNetNuke.zip

To make poking around the files easier, I unzipped it to my desktop.

I opened up DotNetNuke.vstemplate in Notepad2 (but of course opening in VS would also work)

On lines 1186 and 1210 of this file, we see the problem:

Line 1186 DotNetNuke.vstemplate
Line 1210 DotNetNuke.vstemplate

If you open up the folder Install \ Package you will notice 4 files:

  • CardSpace_01.00.00_Install.resources
  • LiveID_01.00.00_Install.zip
  • OpenID_01.00.00_Install.zip
  • PlaceHolder.txt

Notice the missing ActiveDirectory_01.00.05_install.resources – yet it is specified in the DotNetNuke.vstemplate!

The same goes for Install \ Module
Again, a bunch of files are listed, however the missing Blog_03.05.00_Install.resources is not there!

This is obviously an error on the release.