Wednesday, December 13, 2006
If your database team itself is seperate it is little hard to figure out where exactly the problems lie . SSO issues are mostly realted to MSDTC settings .
It is not a common knowledge but there is an SSO configuration and troubleshooting tool . This does not fix any issue but just gives you a report . Get the tool here
Once you run the tool check the DTC settings .
Network DTC Access is enabled
Xa Transactions is enabled
Network Dtc Access Outbound is enabled
Network Dtc Access Inbound is enabled
Mutual Authentication required
Enterprise Single Sign-On Service:
Service Account: domain\mybtssvc
Account na\btssvc is a member of the following groups
BizTalk Application Users
BizTalk Isolated Host Users
BizTalk Server Administrators
EDI Subsystem Users
SSO Affiliate Administrators
Remote Desktop Users
Service status: Running
Hope that helped some of you .
Thursday, October 12, 2006
Did you know you can get your custom queries into HAT .See Here
If you want to do that it is not so hard. All the tracking queries are stored in
C:\Program Files\Microsoft BizTalk Server 2004\Tracking\Queries
C:\Program Files\Microsoft BizTalk Server 2006\Tracking\Queries as the case maybe or wherever you have your Biztalk installation directory .
You can make a copy of one of the templates and rename it to yourQueryName.trq and open the file in a notepad then you will see an
Modify the second
and the fourth
don't change any of the other parameters .
Always make sure you test your query first in the HAT window before you do this .
Now the Pivot Table Part . This is the part where you are going to describe your result set and you start with the
then come to the
Name -- This is the Name of your Column
DataType !-- This is Data Type Date , Integer ,Number
PLDataOrientation !-- leave empty a.k.a No idea ,if U know leave comment :)
PLPosition !-- The column number like 1 ,2
EncodedType !-- Type adInteger,adVarChar
CompareOrderedMembersBy !-- UniqueName
You need to have < for < and > for > which is XML encoded text and namespace of x: , basically follow the template
Save and close and open your HAT . You should see your new query in HAT if everything went well . In case you get any error Close HAT and reopen the file and fix it . HAT actually locks the file . Hope that was of help
Friday, October 06, 2006
I opted to attend Jon's sessions as he always has this high energy when he speaks .
So true to that I picked two of jon's session
Developing Applications for the Web 2.0 and
Generating Orchestrations Using a Visual Studio Wizard.
The Orchestraion Wizard session was a complete dive in hands on on the tool . I was reallly blown away with the tool . This basically lets you templatize your solution , I tell you if you want to invest in 3 hours learning a feature this is one that you will absoultely not regret . Downlad the Wizad at Jon's Blog . The documentation is still in latest office . I send a feedback to Jon so hopefully they wil put an earlier office based documentation.
During Lunch I hanged out with Kevin(See Pic) whose team in corning I worked for pretty much the whole of last year going over the conference days so far . On day 4 there is only so much more presentaions you can take. I ended up going to " BizTalk WCF Adapters In-Depth " by Aaron Skonnard, Pluralsight and Gruia Pitigoi-Aron, Microsoft . This was a good session as it was not too many slide kind of session . I like those on Day 4 . The last one I picked was
"Part 6: The Future of the Microsoft Application Server Platform"
Steve Swartz & Clemens Vasters Microsoft . What I niceabout the session was it gves you a good understanding on what you can expect and what is going to come and the
road ahead like the transacted file systems , the transacted registry and even a transaction command from the command line " I must add Steve and Clemens have a great energy and they make a good team . I hae gone to many presentations where there are multple speakers but they never felt unfied . But these folks session are an absolute pleasure to attend and listen to ..
I spoke with Marjan our Biztalk MVP Community Lead on how the coference was a great value for everyone . I went to meet some of my friends and left seattle the next day morning and reached here withhout any major incidents en-route.
All in all it was a great conference and time well spend
Thursday, October 05, 2006
I missed the first session, most part of it amyway Windows Workflow Foundation: Creating Custom Activities for Workflows , Remember the movie and the relaxing yesterday .Anyway I had downloaded all the labs that day which has a Custom Activty lab . i then took the Driving Business Process Automation through Vertical Accelerators Brennan O’Reilly & Mark Smith . The had some intersting case studies . Interesting I met Brennan through one of my old friends Vishnu . So that was a definite higlight .
The next session I picked was "Effective Techniques for Handling Large Messages in Service Oriented Solutions " Thomas Abraham. This was an intersting session and one thing that I picked up was how BTS2006 pages your maps for translation on to disk after a certain threshhold and how you can control that threshhold. .
The next session was BizTalk Server 2006 R2 Adapter Framework - Walkthrough
Chandramouli Venkatesh Microsoft , This was no kidding the most Packed session of the conference in my opinion . I was sitting on the floor as there were no seats available . So that kind of gives you a general idea. CV's session was a blast !!. he demoed a WCF based SAP adapter . This is one of my High value session in mt eval . Hey You now owe me that drink !
Well the best part about thursday was getting to go for Dinner with the Product Team . This had a pretty good crowd.
Oliver Sharp: General Manager – BizTalk Server
Steve Swartz: Architect – WCF
Patric McElroy: Product Unit Manager – BizTalk Messaging & Process Server
Dan Eshner: Product Unit Manager – BizTalk Executive & Analytics
Kris Horrocks: Sr Technical Product Manager – BizTalk Product Marketing
Peter Wise: Group Program Manager – BizTalk Customer Projects & Services
Kartik Paramasivam: Dev Lead - BizTalk Messaging & Process Server
Lee Graber: Dev Lead – BizTalk Messaging & Process Server
Andrew Layman: Product Unit Manager – BizTalk Interoperability
John Wyss: Group Manager - BizTalk Customer Projects & Services
Jean-Emile Elien: Architect - BizTalk Messaging & Process Server
Chandramouli Venkatesh - Adapters
THe conversation was spontaneous and I rememeber some of the jokes that I had on my cold . Well if you dont know Ravan is a an evil king in Hindu Mythology who has 10 heads. I was thinking what if Ravan catches cold !. It is pretty funny when you think about . And since Ravan has 10 heads one head of that being on the nect , it has 4 on one side and 5 on the other that creates an equilibirium problem to an otherwise symmetirical human structure . And like in SQL it is possible to have a split brain for an issue if you have 5 heads voting for and against. And another one I thought is Ravan does not need to do a seperate brain storning session . He is always in one . And finally if one head sneezes does the other heads go belss you !
I also got to meet most of the Biztalk MVP's whose blogs I read regularly like
Alan ,Bill , Jon,Matt , Rod , Scott , Stephen Thomas
.It was a great evening , it was in Daniel's Broiler in Bellevue Downtown and I tell you the lamb chops there are absoultely delcious not to mention the crab cakes . So was an exciting day in short and a memorable day in my MVP life.
Wednesday, October 04, 2006
The session started with Customer Panel: SOA Success Stories for me and I was realy amazed at the cariety and scale of challenges that Biztalk is solving . The next session thta i picked was
Avoiding 3 Common Pitfalls in Service Contract Design by Tim Ewald. This was a great session , This did focus on the facts that message contracts and schemas do evolve no matter how much reasearch you do upfront and the trick is to expect that change and how to make your schema extensible and how to change your idea of validation from a sub- set presence rather than an exclusion from a sub set of valid nodes.
There was a demo by K2 on thier new Workflow tool and I must say I am IMPRESSED with it's capabilities starting from AJAX based browser workflow designer to thier tight integeration into the Visual Studio environment and integerated debugging. It is code named BlackPearl , Reminds me of Pirates of the carribean . It is truly amazing howK2 has grown from it;s humble begininig in South Africa.
Choosing the next session was tough . I was torn between two sessions
Advanced Routing and Correlation with BizTalk Orchestrations
Lee Graber Microsoft and
Building an ESB on the Microsoft Platform
Brian Loesgen , Neudesic & Lukas Cudridge, Microsoft
I finally chose to attend Lee's Session and it was well worth it . His slide on Zombie factory ( classic Zombie a Recieve with a timer in the parallel branch ) had the room in splits :-) . Other thing that I really found out was Lee was not Chinese , i am not sure how that notion got into my head . This was one of my best rated sessions
I went for the "ESB Technical Deep Dive " by Brian next as I missed the intro talk but I was really impressed with the framework . You can get more details on the tool at EBIZTLKIT@microsoft.com .
I finished the day with a Developer Q and A and went to the Birds of the feather and Partner Expo. Some of the things that caught my fancey were
Farpoint Spread - An excel pipeline component
SKELTA workflow tool . They too has Ajax based workflow designer like K2 . It has outlook integeration too .It is not integerated into the .net platform at this point . This might be a cost effective option if K2 is out of your reach .
Java- Bizalk - JNBridge Adapter
Did stroll over to Jon's QuickLearn Booth , but couldnt catch him anywhere . Spend some time chatting at the BOF tables and went for a movie to relax
Tuesday, October 03, 2006
This was one of the best talk that I had at the conference . It really does give you a pragmatic view of things.
The next session was by John deVadoss on Real World SOA .This really had some intersting comparison on the big bang approach vs the small end to end scenario in finding out the SOA Value . This had some intersting videos on a leading bank in Australia and some good case studies.
There was a presentation over lunch by HP
After this one had to choose between differnt tracks and I kind of took
The Architecture of SOA - John Evdemon
Technical Solution Spaces for BizTalk and CSD - Oliver Sharp
Then we had an SOA Q and A Panel which was really valuble and it kind of had lo of thought provoking question like what is schema versionin if XML stands for Extensible Markup Languuage. Well that was not the exact question but you know the philosphical flamy question . Really felt lie after a days full of presentations. I had suddenly got this cold from somewhere by then . WEnt ove rto Bldg 3 to meet some of my old friends and watched some movie in the evening
Monday, October 02, 2006
Thursday, September 28, 2006
Let us say your organization A has 2 SQL Servers and 2 BizTalk servers. So that means you would have 4 Windows licenses to run those servers. I am assuming BizTalk and SQL are not on the same server.
Your present scenario is
BTS - 2
SQL - 2
WIN - 4
Now consider a virtualization scenario where you have a single Quad proc machine.
Now let us consider this has 4 virtual processors and 2 of them runs BizTalk, 2 of them runs SQL
Now in the old licensing model you need to pay license per processor that would mean you need to have
BTS - 4
SQL - 4
WIN - 4
Effectively by virtualization the license cost went up. But with the new windows licensing model you pay only if the virtual processor runs the Server, In our example that would mean
BTS - 2 ( as it is running only on 2 virtual processors )
SQL - 2
WIN - 4
So effectively your BizTalk and SQL licensing costs have not changed by virtualization but your actual hardware and annual support cost will be driven down considerably and you can take other advantages of virtualization. Let us say you want to emulate 6 virtual processors using your Quad proc machine and run 4 BTS and 2 SQL servers you can do that without buying any extra hardware by paying only the additional BizTalk server licensing cost . In this case
WIN - 6
So as I said before virtualization does bring down support cost but not always software costs. But there are other software’s which are still using the physical processor based licensing. In that case you will have licensing benefits when you run more virtual processors than the actual processors and pay more when you have lesser virtual processors running your application.
Friday, September 15, 2006
There is also an Adapter comparison guide . Check out
Monday, August 14, 2006
The topic for the talk is
"Common Enterprise Integration problems,
Design Patterns and Solutions using BizTalk "
Talk about some common problems faced in EAI world and how biztalk can be used to
address those effectively. Will be some scenario problems and design ,Splitter, Enricher , Aggregator , Normalizer,Different Convoy
Discuss one or scenarios with a demo ( Aggregation ) .
The problem of zombies
Q & A
The session is scheduled on 21 August - Monday between 7.00 p.m. to 9.00 p.m. in Sangeetha Residency.
Friday, July 21, 2006
For eg let us you have a situation wher you have multiple flat files coming in and you need to find the schema . So normally we will put a flat file Dissasembler in and create a custom recive pipeline and we will need to create 3 pipelines.
In 2006 what you can do is have multiple flat file dissasembler components in the Dissassemble stage . So now your 3 pipelines now becomes one pipeline. All you need to for this is to go to your pipeline and drag in the 2 or 3 flatfile dissasembelrs and set the schema property to the ones you want and then voila. You wil notice that in the the Dissasemble stage property the execution mode appears as "First Match" .
But dont add too many dissasemblers in one stage . This wil have a negative imapct in performence . This is because probing for every dissasembler components degrades the perf.
In such a scenario consider implementing a Schema Resolver component
Thursday, July 20, 2006
I ran setup again chose Add Remove and could not find the installtion Option.
Anyway after a few painful hours I have finally got it to work . This is what I had to do
1. ) Get the VS 2005 CD . Browse to the VSS folder and run Setup .
2. ) You need the first check box in the custom installtion . Everything else is really optional
3.) Install the Visual Source safe client and connect to your existing Sourcesafe Manully
4.) Fire up Studio, and go to Tools > Options > Source Control> Show all settings > Select the current source control plug-in to "Microsoft Visual SourceSafe"
Well I hope that helps some of you atleast ! If it did leave me a note !
Friday, July 07, 2006
Part 1 Servers Hosts and Processes
First is the Table adm_Group which contains information about BizTalk Groups. They contain information like cache frequency, the large message ,threshold bytes and certificate thumb print. This is in a way the logical top table.
Second is the adm_Host table. This table contain information about the hosts like Inproc or isolated . The thread pool size, message delivery and certificate thumbprint if configured for signing messages . Maximum delay .
This table is connected to the adm_HostInstance table .This table has info about the
host instance ( BTS Service ) running within the hosts. You can also see under what accounts the host Processes are configured to run under here . Each host has several sub services specified in the adm_HostIntance_SubServices. These are services like Caching , EPM , XLANG engine
The host are configured on th server and this enlistment is captured in the the adm_Server2HostMapping . This essentially connects the adm_hostinstance and the adm_Server .The adm_Server contains the list of servers that are members of that Biztalk group
A brief note on adm_ServiceClass is needed here as this table controls the value of the high and
low watermarks for memory , file . This setting should not be manually edited , There is a a tool
for editing these value and should have a pretty strong reason to edit these .
The adm_MessageBox table contains the messagebox entries associated with this host . You can scale biztalk by increasing the message box first vertically and then horizontally even in those situations it is recommended to go from 1 to 3 and not to 2 to see increase in performance.
Part 2 : Adapters , Recieve Ports , Send handlers ,pipelines
The next main table is the adm_Adapter , This table contains all the adapters installed for Biztalk like FTP, HTTP, EDI, File,MQ Series, MSMQ,SOAP, SQL, POP3, SMTP and WSS.
The adm_RecieveHandler table contains key to the process identification guid in the registry/DB .The adm_SendHandler is the same for the Send Process.
When we create a Recive port and a Recieve Location . The adm_ReceiveLocation will contain the entry for the port location and will have tha adapterId value corresponding to the transport type in the adm_adapter table. This will also have an entry into the bts_recieveport table which has the containing port information . similary bts_sendport contains the send port information .
In general bts_ prefix stands for the corresponding biztalk artifacts ;bts_assembly contains the deployed assemblies the bts_orchestration contains the orchestrations other tables like bts_orchestration_port,bts_pipeline follow similar pattern
In general the prefix gives you some idea about the table
- ADM_ are administration tables
- BAM_ ,BAS_ BAM or BAS specific tables
- TDDS_ Tracking tables
- BTS_ Biztalk artifacts tables
- BT_ App specific tables
- BIZTALK General tables
Hope that was informative .
Monday, June 12, 2006
Features in brief are
- Microsoft EDI Solution for BizTalk 2006
- Microsoft RFID
- BizTalk Adapter for Windows Communication Foundation (WCF)
- WinFX Adapter Framework
- WinFX Line of Business (LOB) Adapters
- BAM interceptors for Windows Workflow Foundation (WF) and WCF
To sign up for TAP , Go to the Microsoft Connect Site .
Monday, May 22, 2006
Errr 1904.Module C:\Program Files\LoadGen\ComFileMonitor.dll failed to register
After being stumped for a while I went and looked at System Requirements
- Microsoft .NET Framework 2.0
I wonder if they have a version of the tool built on 1.1 as most Biztalk 2004 Developers would have 1.1 on the box . Hopefully I can get a 2.0 box configured and test our 2004 box
Thursday, April 20, 2006
This could be stuff like your Biztalk purgejobs are not running .This could seriously slow you down after some time. Or your Master secret server is not backed up .
There is some good posting and screenshots in Richard's Blog.
Tuesday, April 04, 2006
You get the above message and you are already logged on as the user who has full permission to the SQL Server group . We got this error when we were configuring a new server in our production environement . I had faced this problem before but I had forgotten the solution . So I blog it here so that any lost souls get the benefit . This is a know problem when configuring Biztalk in a multiple computer configuration . You need to enable network client access DTC before you start configuration or your configuration WILL FAIL !!
This is documented in MSDN Biztalk trouble shooting section .
Multiple computer configuration using Windows Server 2003 or Windows XP
Problem: If you attempt to run the Configuration Wizard on Windows Server 2003, or Windows XP, and point to a remote SQL server, the configuration will fail.
Resolution: You must enable network clients DTC access before configuring BizTalk Server. This is required for the distributed transactions performed by BizTalk Server components to work.
Important The following procedure must be run on each of the computers in the multiple computer configuration.
To turn on DTC Access
From the Start menu, double-click Control Panel, double-click Administrative Tools, and then double-click Component Services.
Expand Component Services, and then expand Computers.
Right-click the computer you need to set, and from the context menu select Properties.
In the Properties window, select the MSDTC tab.
In the Transaction Configuration area, click Security Configuration.
In the Security Settings area, select the Network DTC Access check box.
In the Security Settings area, check the Network Clients check box.
Click OK on each open dialog box.
Restart your computer to enable the remote DTC option.
Warning This configuration could take up to 15 minutes.
Hope that gets you back on track .. Leave me a comment in any case
Friday, March 24, 2006
Wednesday, March 08, 2006
When we tried to deploy the schema , We came across this error and had to spend some time trying to debug this one.
The error you get would be a variation of the one below
Property "ns0:Your_Promoted_Property" (msgType="YourSchema#RootNode") not found in Configuration database.
Delete the Node which it is complaining from the property schema and recreate it again
What was odd on our case was this same DLL was deploying in vertain machine but not on some other ones.
After aome amount of gogling I tried to think about the error for some time and this was my line of reasoning . The deployment was complaining about a promoted property not available in the configuration database . This was a bit weird because the property that Biztalk was complaining about was contained in the same Assembly.
But once I realized that somewhere in the deployment process the properties that were being promoted were first stored into SQL tables for eventual usage in CBR scenario . I realized that this insertion would be failing . The only reason this could be failing is if the variable already existed.
Since Biztalk being a Globalized product I figured the names would not be used as it is but rather some unique value a Identity or GUID . So I went ahead and changed the guid value of all the properties that it was complaining , I had edited the XML for this values . (You can delete and recreate the Node if you are not comfortable ) .
Then I rebuilt and it deployed like a charm !
PS: What had happened is one of our Dev's had copied the property schema from another project and changed the namespace and the field name of certain fileds.
This worked on certain machines without problems because these devemachines did not have the solution from which the property schema was copied deployed on them . Wheras we had this prior solution deployed on our servers.
So I guess Copy-Paste fanatics take care. !
Wednesday, February 22, 2006
Scott answers lot of intersting question here .. Like how did he become product manager of Latinum (Biztalk 2000).
While on code names these are the list so far..
Latinum --- BizTalk 2000
Bizet --- BizTalk 2002
Voyager --- BizTalk 2004
Pathfinder --- Biztalk 2006
Avalon --- Windows WorkFlow Foundation(WF)
??? --- Biztalk 2008
Now that Biztalk Server 2006 is out there and after having seen the demo of Windows Workflow Foundation (WF ) at PDC lot of us are asking what will be future of Biztalk Server 2008 ? .
Scott speaks out that the design surface of workflow for WF and BTS was built by the same team and the similarities end there Biztalk would still be needed to solve problmes of EAI, BPM ,B2B, Adaptor management .
Scott also mentions that the workflow for Biztalk 2008 would most probanly share the workflow piece with WF and there would be a upgrade to current customers. This also make me believer the news I heard about the Biztalk and Indigo Team got merged into one group .
Listen to the Biztalk Server Podcasts... here
Monday, February 06, 2006
You get the Error below
Event Type: Error
Event Source: XLANG/s
Event Category: None
Event ID: 10034
Uncaught exception terminated service Biztalk.Reusable.FileMover.FileMoveOrch(edf0c1f0-c242-60c9-5b56-41ab42b9ee5d), instance e756bd88-5966-48f9-be40-8a55451d2bf4
Exception occurred when persisting state to the database.
Exception type: PersistenceException
Target Site: Void Commit()
Additional error information:
A batch item failed persistence Item-ID f64a095a-eed6-451c-86ee-9aac941b935b OperationType MAIO_CommitBatch Status -1061151998 ErrorInfo The published message could not be routed because no subscribers were found. Please use the Health and Activity Monitoring (HAT) tool to diagnose this situation. .
There are a couple of things you should check
1.) Is the Orchestration and all corresponding objects send ports started
2.) Is Biztalk 2004 Service Pack Installed
3.) Is your Orchestration Calling another Orchestration whihc is not started
4.) Are you using Dynamic Send Ports , If yes are you setting the Address location
In the problem I was debugging, the value of this variable was set from an external call to a .net function and this value was not properly intitalized.
Fixing the function and regacing solved the issue.
Thursday, January 12, 2006
THIS information Applies if you have NOT backed up your master secret
( Thanks Patrick for pointing out this ) .
if you have in C:\Program Files\Common Files\Enterprise Single Sign-On
>ssoconfig.exe -restoresecret YouBTSSSOBackupfile
So one day you reset that password and suddenly you discover that your biztalk service is not running.
First - Dont Panic !
ok Now you are not panicking :-)
so these are the places you need to reset
Goto ->Start->Run-> Services.msc
and update the password for the following
BizTalk Base EDI service
Enterprise Single Sign-On Service
Rule Engine Update Service
Next Open Biztalk Administrator and change passwords for
BizTalk Host Instance Account
BizTalk Isolated Host Instance Account ( In case you set it up same which is not the recommendation btw )
Next Open IIS Manager
Goto ->Start->Run-> inetmgr.msc ->Application pools->Properties ->Identities
and change the password for all the onee below ( You might not have some based on your configuration )
TpmWSAppPool (If you are using BAS)
WSSAppPool (Sharepoint app Pool )
Whew !! That should get you back on track .
In case it did not leave me a comment or Ping me !
Tuesday, January 03, 2006
Inside the expression shape /Message Assignment Shape
objMapType = System.Type.GetType("Map Name ,( Full strong Name of Assembly)");
transform (Output_Xml) = objMapType (Input_Xml);