tag:blogger.com,1999:blog-19256084283508153232024-03-05T03:16:19.340-08:00BiztalkUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1925608428350815323.post-74359578934658702272023-01-21T09:22:00.002-08:002023-01-21T09:23:01.053-08:00back biztalk apps<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTdWl3dyU9ebTCAMlftS7PTfHC_ZKwumQ48m72UP5rZOJNuJxve4Qy2fQ-9RKOY-lZzfRg4MnN7V4syO7p5dCuHJch_lbyvlr7hd1Mf0UlL1XqeGSKN8hYZwL1NIAfJE3QNgwLyNCOH7DGtymQAAOr_vtOHpZWOq3hvNiPbbm1MU6KPFl1t6be_34/s1536/aa-1.jpg" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="200" data-original-height="864" data-original-width="1536" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTdWl3dyU9ebTCAMlftS7PTfHC_ZKwumQ48m72UP5rZOJNuJxve4Qy2fQ-9RKOY-lZzfRg4MnN7V4syO7p5dCuHJch_lbyvlr7hd1Mf0UlL1XqeGSKN8hYZwL1NIAfJE3QNgwLyNCOH7DGtymQAAOr_vtOHpZWOq3hvNiPbbm1MU6KPFl1t6be_34/s200/aa-1.jpg"/></a></div>
<div style="overflow:scroll;height:500px"><pre class='code'>
<span class="Identifier">$exportFolder</span> = <span class="String">"d:\bcp\2023-01-20"</span>
<span class="Identifier">$server</span> = <span class="String">"DBSERVER110"</span>
<span class="Identifier">$database</span> = <span class="String">"BizTalkMgmtDB"</span>
<span class="Identifier">$apps</span> = @(
<span class="String">"App1"</span>
,<span class="String">"App2"</span>
,<span class="String">"App3"</span>
)
<span class="Identifier">$bp</span>=<span class="String">"D:\Program Files (x86)\Microsoft BizTalk Server 2013 R2"</span>
<span class="Repeat">foreach</span> (<span class="Identifier">$app</span> <span class="Keyword">in</span> <span class="Identifier">$apps</span>)
{
<span class="Statement">Write-Host</span> <span class="String">"===== Application: $($app) ==== "</span>
<span class="Conditional">if</span> (<span class="Identifier">$app</span> -ne <span class="String">"BizTalk.System"</span>) <span class="Comment"># avoid error trying to export this app </span>
{
<span class="Identifier">$fmtDateTime</span> = $(<span class="Statement">get-date</span> -f yyyy_MM_dd__HH_mm_ss)
<span class="Identifier">$bindingsDestFilename</span> = <span class="String">"${exportFolder}\$($app).xml"</span> <span class="Comment"># _$fmtDateTime </span>
<span class="Identifier">$msiAppDestFilename</span> = <span class="String">"${exportFolder}\$($app).msi"</span> <span class="Comment"># _$fmtDateTime</span>
<span class="Statement">write-host</span> <span class="Identifier">$bindingsDestFilename</span>
<span class="Identifier">$allArgs</span> = @(<span class="String">"ExportBindings"</span>, <span class="String">"/Destination:$bindingsDestFilename"</span>, <span class="String">"/ApplicationName:$($app)"</span>
<span class="String">"/Server:$server"</span>, <span class="String">"/Database:$database"</span>)
<span class="Conditional">if</span> (<span class="Identifier">$app</span> -eq <span class="String">"BizTalk EDI Application"</span>)
{
<span class="Comment">#just backup the parties one time with this one app </span>
<span class="Identifier">$allArgs</span> += <span class="String">"/GlobalParties"</span>
}
<span class="Statement">write-host</span> <span class="String">"Args=$allArgs"</span>
& <span class="String">"$bp\BTSTask.exe"</span> <span class="Identifier">$allArgs</span>
<span class="Identifier">$allArgs</span> = @(<span class="String">"ExportApp"</span>, <span class="String">"/Package:$msiAppDestFilename"</span>, <span class="String">"/ApplicationName:$($app)"</span>,
<span class="String">"/Server:$server"</span>, <span class="String">"/Database:$database"</span>)
<span class="Statement">write-host</span> <span class="String">"Args=$allArgs"</span>
& <span class="String">"$bp\BTSTask.exe"</span> <span class="Identifier">$allArgs</span>
}
}
</pre></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1925608428350815323.post-1395529146732343262015-07-01T10:29:00.002-07:002015-07-01T10:30:54.953-07:00How to receive email notification when biztalk receive location is suspended<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-eRgEMYICJUd5WvuZMZHmOScHqJfWY6GMCUCrLl3ucPeHWyyG7CO9qyXl6Tlzv2VZVXXdp1l2XbPMTXornrp1rBmnDuLl8fjCyImphW6T8PqmFS7vukb8BEbJ7urve4CmZZPvR0KeF0A/s1600/4fbd0403c38b428460a0f36ca7c964f5.png" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-eRgEMYICJUd5WvuZMZHmOScHqJfWY6GMCUCrLl3ucPeHWyyG7CO9qyXl6Tlzv2VZVXXdp1l2XbPMTXornrp1rBmnDuLl8fjCyImphW6T8PqmFS7vukb8BEbJ7urve4CmZZPvR0KeF0A/s320/4fbd0403c38b428460a0f36ca7c964f5.png" /></a>
<p>
Following stored procedure has been created:
</p>
<pre class="code">
<span class="Special">IF</span> <span class="Statement">EXISTS</span> (<span class="Statement">SELECT</span> <span class="String">'*'</span> <span class="Special">FROM</span> sysobjects <span class="Special">WHERE</span> id = object_id(N<span class="String">'[dbo].[BiztalkRecieveLocationNotification]'</span>))
<span class="Statement">DROP</span> <span class="Special">PROCEDURE</span> [dbo].[BiztalkRecieveLocationNotification]
GO
<span class="Statement">CREATE</span> <span class="Special">PROCEDURE</span> [dbo].[BiztalkRecieveLocationNotification]
<span class="Comment">/**********************************************************************************************************</span>
<span class="Comment">-- DESCRIPTION: Email list of suspended receive locations </span>
<span class="Comment">--</span>
<span class="Comment">-- DATE AUTHOR
<span class="Comment">-- CREATED:
<span class="Comment">-- MODIFIED: </span>
<span class="Comment">-- </span>
<span class="Comment">**********************************************************************************************************/</span>
<span class="Special">AS</span>
<span class="Special">BEGIN</span>
DECLARE @xml NVARCHAR(MAX)
DECLARE @body NVARCHAR(MAX)
<span class="Special">if</span> <span class="Statement">EXISTS</span> (<span class="Statement">SELECT</span> *
<span class="Special">FROM</span> BizTalkMgmtDb.dbo.adm_ReceiveLocation <span class="Special">AS</span> RL <span class="Special">WITH</span>(READPAST, ROWLOCK)
INNER JOIN BizTalkMgmtDb.dbo.bts_receiveport <span class="Special">AS</span> RP <span class="Special">WITH</span>(READPAST, ROWLOCK)
<span class="Special">ON</span> RL.ReceivePortId = RP.nID
INNER JOIN BizTalkMgmtDb.dbo.bts_application <span class="Special">AS</span> APP <span class="Special">WITH</span>(READPAST, ROWLOCK)
<span class="Special">ON</span> RP.nApplicationID = APP.nID
<span class="Special">where</span> APP.nvcName =<span class="String">'MyBiztalkApp'</span> <span class="Statement">AND</span>
Disabled=<span class="Number">-1</span>
)
<span class="Special">BEGIN</span>
<span class="Statement">SET</span> @xml = CAST((
<span class="Statement">SELECT</span>
APP.nvcName <span class="Special">AS</span> <span class="String">'td'</span>,<span class="String">''</span>
,RP.nvcName <span class="Special">AS</span> <span class="String">'td'</span>,<span class="String">''</span>
,RL.InboundTransportURL <span class="Special">AS</span> <span class="String">'td'</span>,<span class="String">''</span>
,RL.Name <span class="Special">AS</span> <span class="String">'td'</span>,<span class="String">''</span>
<span class="Special">FROM</span> BizTalkMgmtDb.dbo.adm_ReceiveLocation <span class="Special">AS</span> RL <span class="Special">WITH</span>(READPAST, ROWLOCK)
INNER JOIN BizTalkMgmtDb.dbo.bts_receiveport <span class="Special">AS</span> RP <span class="Special">WITH</span>(READPAST, ROWLOCK)
<span class="Special">ON</span> RL.ReceivePortId = RP.nID
INNER JOIN BizTalkMgmtDb.dbo.bts_application <span class="Special">AS</span> APP <span class="Special">WITH</span>(READPAST, ROWLOCK)
<span class="Special">ON</span> RP.nApplicationID = APP.nID
<span class="Special">where</span> APP.nvcName =<span class="String">'MyBiztalkApp'</span> <span class="Statement">AND</span>
Disabled=<span class="Number">-1</span>
<span class="Special">FOR</span> XML PATH(<span class="String">'tr'</span>), ELEMENTS ) <span class="Special">AS</span> NVARCHAR(MAX)
)
<span class="Comment">/* Body as the HTML table */</span>
<span class="Statement">SET</span> @body =<span class="String">'<html><body><H3>Biztalk Suspended Receive locations:</H3></span>
<span class="String"> <table border = "2" align="center" > </span>
<span class="String"> <tr></span>
<span class="String"> <th> Application Name </th> <th> Port Name </th> <th> Adapter URI </th><th> Location Name </th></tr>'</span>
<span class="Statement">SET</span> @body = @body + @xml +<span class="String">'</table></body></html>'</span>
<span class="Comment">/*Execute the Stored Proc to send us the Mail using the Parameters */</span>
EXEC msdb.dbo.sp_send_dbmail @recipients=<span class="String">'my@email.com'</span>,
@copy_recipients =<span class="String">'my@email.com'</span>,
@subject = <span class="String">'Biztalk recieve location suspended'</span>,
@body = @body,
@body_format = <span class="String">'HTML'</span> ;
<span class="Special">END</span>
<span class="Special">END</span>
</span></span></pre>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1925608428350815323.post-24807958152640246472015-05-27T13:15:00.001-07:002015-07-01T10:17:10.901-07:00Error into Disassembler component: The published message could not be routed because no subscribers were found. <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpQp3i5NbMl3PToCe6aaJ1jjlWeZBUEOqdAA_oCUWbQ2PWSkcIhx4cbWRJf2MaUfUgViRruyCbQknAsN_wWJKBzPn9cvVR2TgzZ0wVmGUDpdNT-xHaCygAOdc8f_p8mSR2e9Q3rW3Eks4/s1600/ToniStark.jpg" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpQp3i5NbMl3PToCe6aaJ1jjlWeZBUEOqdAA_oCUWbQ2PWSkcIhx4cbWRJf2MaUfUgViRruyCbQknAsN_wWJKBzPn9cvVR2TgzZ0wVmGUDpdNT-xHaCygAOdc8f_p8mSR2e9Q3rW3Eks4/s320/ToniStark.jpg" /></a>
<p>
This error happens if in disassembler component you missed outgoing message type specification.<br />
This could be fixed by following code:
</p>
<br />
<pre class='code'>
<span class="Comment">// this schema is required to have routing working correctly.</span>
outMsg.Context.Promote(<span class="String">"MessageType"</span>,
<span class="String">"<a href="http://schemas.microsoft.com/BizTalk/2003/system-properties">http://schemas.microsoft.com/BizTalk/2003/system-properties</a>"</span>,
<span class="String">"<a href="http://SampleImport.InternalSampleImportSchema#Root">http://SampleImport.InternalSampleImportSchema#Root</a>"</span>);
outMsg.Context.Promote(<span class="String">"SchemaStrongName"</span>,
<span class="String">"<a href="http://schemas.microsoft.com/BizTalk/2003/system-properties">http://schemas.microsoft.com/BizTalk/2003/system-properties</a>"</span>,
<span class="String">"SampleImport.dll"</span>);
</pre>Unknownnoreply@blogger.com0