Suneet Nangia- Blog Viewer

Blogs

Archives

Feeds

RSS 2.0

About Me

Hello,
I am Suneet and this is my personal web space to put my views and tips on cutting edge MS technologies and otherwise at times. I am sort of a mouse potato who would stick to his PC for hours. I love playing badminton, table tennis and roller skating.
Incase you want to ping me for anything, get in touch at techie@suneet.net.

Making of the beast...


Intel i7 950 CPU
ASUS Extreme Rampage II
NVidia GTX 295 Graphics
Corsair 6GB (3x2GB) DDR3 1600MHz XM
Western Digital 1TB SATAII 7200rpm
Razer Arctosa Silver Keyboard
Razer CopperHead Laser Mouse
Samsung P2250
HAF 932
Corsair HX750 PSU

Photography Freaks


Ben Cops
Richard Parker

My Other Spaces


Flickr Photo Albums Created especially for my new EOS 40D

Interesting Articles


Richard Grime's .Net Security Extremely good .net security article. I have never come across any such tutorial before.
What Leads to EAI MS Journal Article

Blogs I Visit


Stephen W. Thomas
Kevin B Smith
Saravan Kumar
John Flander
Biztalk Server Team
Darren Jefford
Daniel Moth I have attended few of his workshops@ MS, Thames Valley. Very sharp fella with good programming knowledge.
Mike Taulty
Richard Grime
Chris Dickson One line for him- Fantastic Biztalk & .Net Expert. I had a chance to work him, he is one person who will always do the right things rightly.
Mohit Nayyar Exciting MS SQL/DB blog
Ben Cops He is techincally very sound person with good balance between work and life.

Technical Readings


BizTalk 2006 Recipes
Pro BizTalk 2006
Microsoft BizTalk Server 2004 Unleashed
CLR Via C# Amazing book on core concepts of CLR and C#. Must have book. Jeffrey has finished its 3rd edition as well which will soon be in the market. Follow this link for its release dates, availability etc

BLOGs-

All Months, All Years

Fri, 04 Jun 2010 11:21:30 GMT
Message Context Lost After Call Rules Shape

Another problem I faced while working on BRE recently.
If you call BRE from orchestration using Call BRE shape and pass in the message into it, the message lose all its context and you cannot access it after it. It seems Call BRE shape creates new message out of the passed XLangMessage and points the same message variable to it.

Solution: Just extract all values from the context before you make a call to BRE.

Comments(0) | Permalink | Biztalk 2004/2006/2009

Thu, 20 May 2010 16:55:00 GMT
Map project does not compile on BizTalk 2009 build server

While working on the new project on BizTalk 2009 I came across this compilation error on the build server which had only "Build Components" of BizTalk deployed on it as suggested by documentation.

Our map project was throwing the following error while compiling-

Error: XXXX.btm : error btm1023: Exception Caught: The map contains a reference to a schema node that is not valid. Perhaps the schema has changed. Try reloading the map in the BizTalk Mapper. The XSD XPath of the node is: /*[local-name()='']/*[local-name()='XXXXXXX']/*[local-name()='XXXXXXXX']/*[local-name()='XXXXXXX']/*[local-name()='XXXXX']

Map project was building correctly on development machine but failing on this build server.

Resolution: Install SDK and Developer Tools components of BTS as well on the build server.

Comments(3) | Permalink | Biztalk 2004/2006/2009

Thu, 15 Apr 2010 22:51:25 GMT
SSO Config Error in BizTalk Server 2009. Failed to connect to the SQL Database 'SSODB' on SQL Server

While configuring BizTalk 2009 eval copy on my development machine, I faced the following error in the event log-
Login failed for user 'xyz' SQL error '18456'

And following error in the config console-
Failed to connect to the SQL Database 'SSODB' on SQL Server 'abc'

You get this error when a 'SSOSQL.dll' is unregistered on the machine. To register it back use the following command from the visual studio command prompt-
'Regasm SSOSQL.dll'

Note: Make sure you change the current directory in the prompt to the location where this dll is present i.e. "C:\Program Files\Common Files\Enterprise Single Sign-On\"

Another thing I noticed was that when I installed BTS before installing VS 2010 it was configured smoothly but somehow I guess VS 2010 unregistered the SSOSQL.dll file.

Comments(0) | Permalink | Biztalk 2004/2006/2009

Thu, 20 Aug 2009 13:40:10 GMT
"data rows to skip" bug in SSIS Flat File Connection Manager

SSIS 2005
Flat File Connection Manager Bug-
I was bit shocked to see this bug which MS is still reluctant to fix.

If you change the "data rows to skip" settings under "Preview" tab it will impact how the rows are imported actually using a file and is not just confined to the preview of the data in that window. Essentially, if you set it to say 100, the package when executed will skip 100 rows from the file and guess what not just from beginning but also also the random positions as well.

If MS says this is a minor UI bug then the question is why is it skipping rows from the random positions also and not just from the top?? I am sure no developer will like to skip random rows from the file :)

It is a BUG indeed.

Comments(0) | Permalink | SSIS