Tuesday, July 25, 2006

VPC Copying results in ASP.NET 2 memory limit error

Today I found the following error in the event log of one of my virtual servers (Win2k3 Sp1):

Unable to get the private bytes memory limit for the W3WP process. The ASP.NET cache will be unable to limit its memory use, which may lead to a process restart. Error: 0x80070005

I had created this VPC by copying the virtual hard disk from another VPC and running NewSID on it. I was under the impression that this fixed any issues regarding SIDs from the old machine conflicting with SIDs on the new one. Not quite, it turns out.

The IIS_WPG group from the old box is on the ACL of the app pools in the metabase, not IIS_WPG of the new box. Use metaacl.vbs (download from MS) to check. Use the command:

MetaAcl.vbs "IIS://localhost/W3SVC/AppPools"

One of the entries will be an SID, not a user/group name. This is the IIS_WPG from the old box.

To fix this, add the IIS_WPG group of the new box to the ACL in question using the command:

MetaAcl.vbs "IIS://localhost/W3SVC/AppPools" IIS_WPG U

's Gravenhage

To those who don't know, the title of this post is the Dutch name for The Hague. I started a new contract there this week, and I agreed to work at the company for a few months. I'm back in the financial industry, this time doing a BizTalk 2k6 deployment from the ground up. Should be interesting enough and a good chance to make some new contacts.

Currently I am commuting from Arnhem, but it's a 2 hour trip door to door which is not that much fun. Ergo I am looking for a place to live in the Hague for the next 4 months. I can't decide whether I want to rent an apartment or just get a room in a student/roommate house. Getting an apartment would be the sensible grown up thing to do. Moving in with roommates seems like the fun thing to do, especially since it's temporary. I'll have to wait and see how things work out. (I know what some of my friends would recommend.)

I am still going to Canada in September, but other than that it looks like I will be working Mon-Fri 9-5 until December. I must say that I was getting used to working part time so to speak, but this will allow me to save up some coin and maybe buy a place in A'dam next year.

Wednesday, July 19, 2006

BizTalk 2006 SQL Schema Generation Wizard Error

Today I got this strange error when I was trying to use the SQL Transport Schema Generation Wizard. The error is "Failed to execute SQL Statement. Please ensure that the supplied syntax is correct." I was trying to call a stored proc that runs a simple SELECT statement. The stored proc worked fine elsewhere. What was going on? Well it turns out that you have to add some magic words at the end of your stored proc for this to work. Just paste the following at the end of your SQL code:

for xml auto, xmldata

I found this tidbit of info on this blog

Sunday, July 16, 2006

Feeling better

I have mostly recovered from my bike accident although there are still some issues with chewing hard food. I'm back to work although it has been a little slow lately. I've had a number of meetings about potential jobs and there seems to be more than enough work coming up so I'm not worried.

Last Wednesday I went to Utrecht to see the Tragically Hip and had a great time. I went on my own but met a few Canadians there so it was a good time. The pic with this post is a futile attempt to capture the atmosphere with my cell phone camera.