tag:blogger.com,1999:blog-21519369067404084442023-06-15T02:39:39.948-05:00DotNetizenDigital diary of my learnings and experiences with Microsoft technologies!!!!!!Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-2151936906740408444.post-44668479913224871342012-07-24T15:48:00.002-05:002012-07-24T15:55:35.625-05:00Gotcha: BAM API Anomaly
Scenario:
A helper class is created to log activities using BufferedEventStream class available with BAM API. We created an instance of this helper class in orchestrations and called various methods from the helper class to ActivityStart, Error, EndActivity, ActivityUpdate etc.
Issue:
We observed that, some of the entries we logged using UpdateActivity method are randomly not storedRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-65912912544989174332011-12-12T13:03:00.000-06:002011-12-12T13:03:52.550-06:00Gotcha: Initial Value property of BizTalk orchestration integer variableDefine a variable in an orchestration and choose type as int32. We can see that value property is blank and we can tab out from property window. But if we specify some default value for Initial Value property , tab out, go back and try to delete it , we get a popup window with error as "Property value is not valid.".
To me , this looks like a bug in editor (unless I miss something Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-86877902888828346622011-12-10T08:40:00.000-06:002011-12-10T08:40:08.021-06:00Gotcha: BizTalk MapDid you ever find that, simply mapping link from source schema node to target schema node in BizTalk map doesnt stick as you intended to the mapping surface, but everything else seems to look fine?
Here is something to check out, see if value property on target schema node is set to some default value.If there is any value set, then we would not be able to map to that node until we Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-70314846133002665172011-11-21T11:26:00.000-06:002011-11-21T11:26:30.016-06:00Gotcha: Host instance set up during BizTalk Server reinstallationRecently we had an intance where one of VM's had crashed which has BizTalk server installed on it with its databases on SQL Server hosted on a different machine. We then reinstalled and set up BizTalk Server and associated components. Since the other machine which has SQL Server was not down, we could see that all our application configuration (like applications, Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-8737935025855419322011-10-17T16:33:00.000-05:002011-10-17T16:33:22.610-05:00SQL query for multi keyword searchI recently came across a scenario where user enters multiple search keywords separated by delimitor character and needs to retrieve all rows from SQL Server database when certain column contains at least one of the words in the given list. I thought, this is common scenario with search screens. Thus I am posting queries I used to do this, if anyone likes to use this approach.
User Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-5450648006427272462011-05-02T16:45:00.000-05:002011-05-02T16:45:59.955-05:00Gotcha: BizTalk HTTP adapter on IIS 7.0 and above Recently I needed to set up HTTP receive adapter(BizTalk 2009) on my Windows 7 development machine which has IIS 7.0. Source system is going to send a simple date value through query string parameter of HTTP site URL (like http://server/AppName/BTSHTTPReceive.dll?MyDate=datevalue). I followed instructions stated here on MSDN documentation and tested the set up by pointing to Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-52979711206539445752011-03-07T22:42:00.001-06:002011-03-07T22:44:10.562-06:00Gotcha: Order of input parameter of BizTalk Map functoidI often tend to oversee this and realize only after wasting few test cycles.
When a functoid has multiple input parameters and any input link other than last link is deleted and added, new link gets added as the last link instead of in its original position. This would adversely affect end result of functoids for which ordering is important (like Value Mapping, String Concat etc).
For eg. whenRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-77775543938270968372011-01-31T15:46:00.000-06:002011-01-31T15:46:27.154-06:00Fix: "Error occurred while configuring the connection uri. Invalid URI: The hostname could not be parsed."While generating schemas using WCF-SQL Adapter wizard, following error occurs if server name and instance name are not provided separately in Server Name and Instance Name fields under Config Adapter\Uri Properties tab,
"Error occurred while configuring the connection uri. Invalid URI: The hostname could not be parsed."
HTH.Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-5192520940162826062011-01-19T15:35:00.000-06:002011-01-19T15:35:06.215-06:00Tip: To find last updated timestamp of SQL Server objectsRecently, I was having a need to quickly find the recently deployed stored procedure between two SQL Servers. But I found that, only Created date property is available when I right clicked and looked at the properties of Stored procedure. We can get this information by querying for modify_date column in Sys.Objects system view (or object specific views like Sys.Procedures/Sys.Tables/Sys.Views etcRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-57082054461815330222011-01-17T11:56:00.001-06:002011-01-17T11:58:19.864-06:00Tip: How to add shortcut/hot key to open Source Control explorer in Visual StudioAlthough we currently have various ways to open Source Control Explorer in Vistual Studio IDE, I though it would be nice to have a shortcut or hot key to open Source Control Explorer (as we access it frequently for various needs while working in team environment). We can seet that, View->Other Windows-> Source Control Explorer does not have any shortcut key associated with it likeRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-64936024624307053642011-01-06T15:27:00.001-06:002011-01-06T15:28:50.726-06:00TIp: related to adapters of BizTalk Adapter PackAfter installing the BizTalk Adapter Pack, we can see it listed in the programs list and bindings get listed when we choose WCF-Custom adapter type. But I recently realized that, we need to manually add each adapter of Adapter pack in order use directly instead of WCF-Custom adapter with respective binding type. Steef has explained these steps in detail nicely in this blog post. Although we couldRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-38915476114084094282010-12-04T23:33:00.000-06:002010-12-04T23:33:59.583-06:00Tip: Replicating BizTalk Server 2010 dashboard settings across Host(Instance)sOne of the core enhancements introduced with BizTalk 2010 edition is improved BizTalk Settings Dashboard. This feature provides us an unified location to set various performance tuning settings at Group or Host or Host Instance level. In order to open this settings window, right click on BizTalk Group and choose Settings. We can also find Import and Export options on this window which allows us Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-16617997975634728472010-11-23T12:49:00.000-06:002010-11-23T12:49:32.548-06:00Tip: Verification of imported BizTalk assemblies after deploymentAs we all know, we need to import and install BizTalk assemblies in order to use at run time and these assemblies get GACed during install operation and inserted into BizTalkMgmtDb database during import operation. If we are not updating version for the assemblies and overwrite with new assemblies each time(although this is not preferrable), it is important to make sure that assemblies Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-15336927500558252552010-11-08T23:11:00.002-06:002010-11-09T09:23:42.577-06:00Tip: Specifying Key file path for BizTalk projectsAs we know, key file needs to be specified for any BizTalk project in order for assembly to have strong name before GAC/deploy the same. We could specify this key file either through project properties or in AssemblyInfo.cs file. We can conveniently specify the path to key file if we choose the later. But if we specify the path to key file using Project Properties window, I Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-252290913068991852010-11-08T13:19:00.003-06:002015-06-14T08:13:10.788-05:00Fix : Dll locking issue by Visual Studio
I have observed the following error while building BizTalk schemas and maps projects.
Unable to copy file "obj\Deployment\Schemas.dll" to "bin\Deployment\Schemas.dll". The process cannot access the file 'bin\Deployment\Schemas.dll' because it is being used by another process.
I could get rid of this annoying error after doing following tasks,
1. Paste the following script in Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com2tag:blogger.com,1999:blog-2151936906740408444.post-39137219387665369542009-10-06T16:33:00.001-05:002010-07-10T22:25:47.019-05:00Tip - Missing Add Service Reference in Visual Studio 2008(and above)??If we choose any Framework earlier than .NET Framework 3.0 while creating project or migrate an existing project from older version of Visual Studio, we might not find Add Service Reference in the context menu when you right click on the project. Here is a way to update to the framework version of the project and get Add Service Reference option in the context menu (Project should be saved beforeRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com1tag:blogger.com,1999:blog-2151936906740408444.post-45663796433073720472009-08-27T14:40:00.003-05:002010-07-10T22:24:38.009-05:00Exception Caught: Cannot load source/destination schema: .Issue: Ever got the following exception while trying to build BizTalk map project?
Exception Caught: Cannot load source/destination schema:. .. Either the file/type does not exist, or if a project dependency exists, the dependent project is not built.
Cause: You might probably have an empty namespace for schema file(not schema node) shown in the error above. Usually when we create a schema,Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-57353175652980921202009-04-14T11:57:00.001-05:002010-07-10T22:23:04.171-05:00Tip - Solution name is invisible in solution explorer!!!!Ever wondered why you are not able to see the solution name in order to add more projects after adding first project to the solution ?? Show All files also doesnt get the Solution back..Here is a tip to get it back...
Go to Tools->Options ->Projects and Solutions ->General and select Always show solution checkbox ..thats it!! any guess, why would this not be a default setting for Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-84964686154907692009-04-12T22:48:00.001-05:002010-07-10T22:21:49.812-05:00Installed BizTalk Server 2006 or BizTalk Server 2006 R2?It is very easy to differentiate between most of the Biztalk Server versions by just looking at the Start Menu Program list or Administration Console etc. But things are not very straightforward when it comes to differentiate between Biztalk Server 2006 and 2006 R2. As BizTalk Server name on Start menu and Help->About <> on Administration Console do not clearly show whether current Rajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-2088714406622504982009-03-21T23:24:00.001-05:002010-07-10T22:20:58.851-05:00Some random BizTalk Server facts!!!Here is an attempt to compile some vital information related to BizTalk server that might be useful to be aware of. I will keep updating this post as I find more interesting facts to share with. Also please feel free to let me know, if there are any corrections to the facts listed below or other useful facts.
Default number of Retry's that an atomic shape in an orchestration has (not sure yet, ifRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com0tag:blogger.com,1999:blog-2151936906740408444.post-24408743361902989252008-08-03T23:56:00.000-05:002008-09-29T17:07:56.589-05:00DisclaimerBeing in the era of Collaborative technologies and part of IT community for so long, I could not resist myself anymore from starting up my BLOG and digitalize my knowledge and opinions..Though I may not able to put fancy verbose, but I will make sure that my posts will be good enough to communicate my intentions to the readers and my posts will make sense to readers in someway or the other. HappyRajesh Babuhttp://www.blogger.com/profile/11724949075272660582noreply@blogger.com1