BizTalk Server Tutorials and Solutions

In my this post I am going to share my personal experience to configuration WCF-SQL Receive location using XmlPolling, Please go through with following steps: 1. Open BizTalk Server Administrator Console and Expand your BizTalk application 2. Right Click on Receive Location>New>One-Way Receive Location and Choose your receive port then click OK button. 3. Type proper name of receive location then choose transport type as WCF-SQL (If there is no WCF-SQL type, please install it form BizTalk setup and add adapter from Platform settings) and select Receive handler for it and leave receive pipeline as XML Receive. 4. Click on Configure... button from right side of transport type 5. In General tab type EndPoint Address - connection setting of SQL server (It should be unique) 6. Now Click Binding Tab then expand (FOR XML) and in XMLStoredProcedureRootNodeName: type xml root name of your schema where you want to retrieve table value in your schema tags after tha

Problem: We receive error at WCF-SQL send port -  The action " " was not understood as shown in above picture Solution: In typed procedure pooling it is mandatory to use same operation name in WCF-SQL two way send port as in orchestration send port operation name. !! Keep visiting BizTalkLive !!

Please follow below step to achieve inline schema (More than one schema): 1. Open orchestration add transform shape 2. Double click transform shape then showing transform configuration 3. Choose new MAP from the option 4. In Source Transform add more than one message part 5. After add Destination message part 6. Check checkbox When I Click OK, Launch the BizTalk Mapper. 7. Click OK button 8. Add your schema by BizTalk Type Picker 9. Finally map your schema form source to destination !! Keep visiting BizTalkLive !!

Problem: Generally when we auto generate Schema using biztalk WCF consume adapter service with help of the category Strongly-Typed Procedure then received following error- TypedProcedure/dbo/ProcedureName' ---> System.Data.SqlClient.SqlException: The error description is 'XML document must have a top level element.'. Could not find prepared statement with handle 0. Solution:   Open your store procedure and put FMTONLY  in the following way before temporary table DECLARE  @FMTOnlySet  bit ; SELECT  @FMTOnlySet = 0  WHERE  1 = 1                IF  @FMTOnlySet IS NULL SET   FMTONLY   OFF ; -- start temp table code here -- end temp table code here IF  @FMTOnlySet IS NULL SET   FMTONLY   ON ; !! Keep visiting BizTalkLive !!

There are a number of timeout settings available in WCF bindings. Setting these timeout settings correctly can improve not only your service’s performance but also play a role in the usability and security of your service. The following timeouts are available on WCF bindings: OpenTimeout CloseTimeout SendTimeout ReceiveTimeout Open Timeout :  This property represents the amount of time a channel open operation has to complete. Send Timeout :  Use this property to set the amount of time that a send operation has to complete. When used as part of a solicit-response scenario, this value encompasses the total amount of time for the interaction to complete. If we are sending a large message, we may need to increase this timeout to allow for the request and response messages to be processed within this window. Close Timeout :  A time-stamp that is used to indicate the amount Receive Timeout :  Used by the Service Framework Layer to initialize the session-idle timeo

Problem:  In general it is not editable both vocabulary and policy after public/ deployed Solution:  We can edit both vocabulary and policy after deployed by using update nStatus value from BizTalkRuleEngineDb of following Tables For Vocabulary -  re_vocabulary For Policy-  re_ruleset !! Keep visiting BizTalkLive !!

In biztalk there is not possible to contain same receive folder(URI) !! Keep visiting BizTalkLive !!

Problem: How use biztalk configuration variable in orchestration expression shape or Assignment shape Solution: Depending on machine either 64 bit or 32 bit, do the following steps- 1: Go to biztalk server installation directory 2: Open BTSNTSvc64.exe.config(if machinge is 64 bit) in any editor 3: Scroll down and type just below of  </system.runtime.remoting>       <appSettings>        <add key="Name_of_Variable" value="Variable_value"/>       </appSettings> 4: Now open biztalk orchestration and go to either in expression shape or assignment shape 5: get value by using : System.Configuration.ConfigurationSettings.AppSettings.Get("Name_of_Variable") Note: After change need to restart host instance !! Keep visiting BizTalkLive !!

Problem:  I have created a new In-Process Host and also a Host instance for it but this is not visible in receive or send handlers of the send or receive port. Solution: You did not link with the respective adapter, Pl follow below step to do- >Click Platform Settings >Click Adapters >Right click respective adapter >Click on either send or receive handler >Select Host name form dorp down list >Click Ok !! Keep visiting BizTalkLive !!

Problem: Installing DLL into GAC is little doubt, how we do with help of Developer Command Prompt or using Command Prompt Solution: First open as administrator Developer Command Prompt vs2015 or current install visual studio and type following command- gacutil /i "full path of DLL that you want to install into gac" /f   (including "") then press enter key Another way to install  dll into gac if in your machine did not install visual studio then you need to install dll into gac of following way- Open command prompt as administrator >cd C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools > gacutil /i "full path of DLL that you want to install into gac" /f   (including "") then press enter key Folder v8.1A is depent on installed Framework it may be different. !! Keep visiting BizTalkLive !!

What is the purpose of a document schema? The schema is basically a contract of your message and defines it. The XML Schema definition (XSD) language defines the structure of an XML instance message, and this is the intended purpose of XSD, such schemas use XSD in a straightforward way. A schema is a term borrowed from the database world to describe the structure of data in relational tables. In the context of XML, a schema describes a model for a whole class of documents. What is the purpose of a property schema? Property schema is a special type of schema, not created to describe messages. Instead it describes context properties. It consists of only child node under a root node What is the purpose of an envelope schema? An envelope schema is a special type of XML schema. Envelope schemas are used to define the structure of XML envelopes, which are used to wrap one or more XML business documents into a single XML instance message. When you define an XML schema to be a

To create a new schema In Solution Explorer, select the BizTalk project to which you want to add a schema. On the Project menu, click Add New Item. In the Add New Item – <ProjectName> dialog box, in the Templates section, click Schema. In the Name box, type a name for the schema, and then click Add. If necessary, press F4 to open the Visual Studio Properties window. In the schema tree view, select the Schema node, and then in the Properties window, select the Target Namespace property and type a name for the target namespace. It is important that you set this property in this initial phase of schema creation; avoid using the default Target Namespace property value. Schema from a non-XSD source In Solution Explorer, right-click a BizTalk project, point to Add, and then click Add Generated Items. In the Add Generated Items – <BizTalk ProjectName> dialog box, in the Templates section, click Generate Schemas, and then click Add.In the Generate

Problem: Sometime after deployed BAM activities and views but it is not showing inside BAM Portal Solution: Generally permission issue when user have admin rights the views should be automatically displayed without any problem. But if you are not authorize user do the following ways: Open Command Prompt as Administrator user > CD C:\Program Files (x86)\Microsoft BizTalk Server 2009\tracking > bm add-account -accountname:domain\username -view:viewname Now showing views !! Keep visiting BizTalkLive !!

Problem: By default when we transform schema form map the output generated XML is in inline Solution: Right Click in grid view of map > select Yes from drop-down menu Indent              Indent- Specifies additional white space to add when outputting the result tree; the value must be "yes" !! Keep visiting BizTalkLive !!

Problem:   When you are try to select column list from left to right item to show column then it generally not showing Solution: Open Internet Explorer > Click on Tools icon from left side > Click menu Compatibility View Setting> Add current running website>Click OK. Now everything is showing properly. !! Keep visiting BizTalkLive !!

Problem:  The query could not be processed.. getting this error when we try to open pivot table view in BizTalk BAM Portal. Solution:  We need to install or repair SQL_AS_OLEDB,msi after refresh your page it working fine !! Keep visiting BizTalkLive !!

Problem:  Connecting to the Integration Services service on the computer "xxxx" failed with the following error: "The specified service does not exist as an installed service.". When you try to connect sql server 2016 integration services from SQL Server management studio 17 or 17.1 version generally local server name is not seeing for connection Solution: SSMS 17 or later does not support SSIS 2016 so please uninstall ssms 17 or newest version and install previous version i.e ssms 16 or 16.x version. !! Keep visiting BizTalkLive !! 

Microsoft BizTalk Server is a middleware system that enables companies to integrate and manage automated business process by exchanging documents, within organization or across(End system) organization, through help of adapters like File, SFTP, FTP, MSMQ, WCF, HTTP etc. It provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring. Major application developed by Mirosoft Visual Studio, few of direct created by Microsoft BizTalk Server console with the help of routing mechanism. Developers can create BizTalk Artifacts such as Schema(Create and Validate Business Messages), Orchestration(Define Business Process), Map(Transform and Translate business message from one format to another or one type to another type), BRE(Create Business Rules), BAM(Create business portal to monitor business level activity), Pipeline(Validate messages,Digital Signing, Zip, Unzip messages etc..) and even more a