Biztalk Map Runtime Error: Error converting data type nvarchar to numeric

this Error is quite cryptic because it doesnt say which field failed.  After a long struggle I figured out that it was because of mapping a string element to a decimal element in xml. it was trying to insert empty string “” into a decimal field. The way i resolved this was to put a…

0

Biztalk Build Error ‘System.String’ must be Xml serializable to be a message part type

hi I encountered this error today while building an Orchestration Error 9 ‘System.String’ must be Xml serializable to be a message part type — check event log for more information C:\asa\sds\oresCanonical.odx    the Only solution I have is to restart visual studio every time i get this error any Ideas to resolve this.

2

Msbuild Biztalk Add Resources, Add Application

<Project xmlns=”http://schemas.microsoft.com/developer/msbuild/2003” DefaultTargets=”AddBtResx;”> <PropertyGroup > <BTServerName></BTServerName> <BTServerDatabase></BTServerDatabase> <MsgFailed>Failed Adding Resource for </MsgFailed> <MsgSuccess>success Adding Resource for </MsgSuccess> <ResxAppName>Finance</ResxAppName> <Locn>”c:\Program Files\Microsoft\Bin\Microsoft.Talk.Adapter.Schemas.dll”</Locn> </PropertyGroup> <Target Name=”AddBtResx” > <Exec Command=’btstask AddApp -A:$(ResxAppName) -Server:$(BTServerName) -Database:$(BTServerDatabase)’/> <Exec Command=’btstask AddResource -A:$(ResxAppName) -T:”System.BizTalk:BizTalkAssembly” -OverWrite -Server:$(BTServerName) -Database:$(BTServerDatabase) -Source:$(Locn)’/> <Message Importance =”high” Text =”$(MsgSuccess) : $(ResxAppName)” ContinueOnError =”true” ></Message> <OnError ExecuteTargets =”HandleErr”/> </Target> <Target Name=”HandleErr”…

2

Msbuild Send Email SMTP Server

<Project xmlns=“http://schemas.microsoft.com/developer/msbuild/2003“ DefaultTargets =“EmailIt“> <Import Project=“c:\sdc\Microsoft.Sdc.Common.Tasks“ /> <PropertyGroup > <MsgFailed>Failed Email for </MsgFailed> <MsgSuccess>success Email for </MsgSuccess> </PropertyGroup> <Target Name=“EmailIt“ > <Email MailTo=“abc@ms.com“ MailFrom=“sundar@ms.com“ SmtpServer=“EmailSMTPServer.ms.com or Ip address of the server“ Subject=“ Build status Today“ Body=“Hi All,&lt;BR/&gt; Today’s Daily Build and Deployment Completed:&lt;BR/&gt;&lt;BR/&gt;   Format=“HTML“ Attachments=“$(ResultsItem)$(BuildLogZip)“ /> <OnError ExecuteTargets =“HandleErr“/> </Target> <Target Name=“HandleErr“ > <Message…

2

Msbuild Archive Files Unique Zip file Name

this Explains how to use Msbuild to zip some log files. the zipfilename is generated from date time information, hence unique.  <Project xmlns=“http://schemas.microsoft.com/developer/msbuild/2003“ DefaultTargets =“ZipLogs“> <Import Project=”c:\sdc\Microsoft.Sdc.Common.Tasks” /> <PropertyGroup > <MsgFailed>Failed Email for </MsgFailed> <BuildLogZip>buildlogs.zip </BuildLogZip> </PropertyGroup> <Target Name=”ZipLogs” > <Time.GetTime Format=”yyyyMMMdd-hh-mm” > <Output TaskParameter=”Time” PropertyName=”ResultsItem” /> </Time.GetTime> <Message Text=”$(ResultsItem)” ></Message> <Zip.AddFile pathToZipFile=”$(ResultsItem)$(BuildLogZip)” pathToFile=”Summary1.log” /> <Zip.AddFile…

1

Msbuild Biztalk Start Host Instances

<Project xmlns=“http://schemas.microsoft.com/developer/msbuild/2003“ DefaultTargets =“StartHosts“> <Import Project=”c:\sdc\Microsoft.Sdc.Common.Tasks” /> <PropertyGroup > <MsgFailed>Failed StartHosts for </MsgFailed> <MsgSuccess>success StartHosts for </MsgSuccess> <BTServerName></BTServerName> <BTServerDatabase></BTServerDatabase> <HostInst>Your Host Instance Name</HostInst> </PropertyGroup>   <Target Name =“StartHosts“ > <WriteLinesToFile File=“$(HighLevelErrFile)“ Lines=“Starting BizTalk Host …“ Overwrite=“false“/> <Message Text =“Starting BizTalk Host $(HostInst)“></Message> <BizTalk2004.Host.Start DisplayName=“$(HostInst)“ Server=“$(BTServerName)“ Database=“$(BTServerDatabase)“ /> <OnError ExecuteTargets =“HandleErr“/> </Target> <Target Name=“HandleErr“ > <Warning…

1

Msbuild Biztalk Start Biztalk Applications

<Project xmlns=“http://schemas.microsoft.com/developer/msbuild/2003“ DefaultTargets =“StartBizTalkApplication“> <Import Project=”c:\sdc\Microsoft.Sdc.Common.Tasks” />  <PropertyGroup > <MsgFailed>Failed StartApp for </MsgFailed> <MsgSuccess>success StartApp for </MsgSuccess> <BTServerName></BTServerName> <BTServerDatabase></BTServerDatabase> <AppName>xyz</AppName> </PropertyGroup> <Target Name=“StartBizTalkApplication“ >   <BizTalk2006.Application.Start Application=“$(AppName)“ Server=“$(BTServerName)“ Database=“$(BTServerDatabase)“ /> <OnError ExecuteTargets =“HandleErr“/> </Target> <Target Name=“HandleErr“ > <Message Importance =“high“ Text =“$(MsgFailed) : $(AppName)“ ContinueOnError =“true“ ></Message> </Target> </Project>

1

Msbuild Publish WebServices

<Project xmlns=“http://schemas.microsoft.com/developer/msbuild/2003“ DefaultTargets =“PublishSite“> <Import Project=”c:\sdc\Microsoft.Sdc.Common.Tasks” /> <PropertyGroup > <MsgFailed>Failed PublishWebSite for </MsgFailed> <MsgSuccess>success PublishWebSite for </MsgSuccess> <AppPoolName>DefaultAppPool</AppPoolName> <WebSiteName>Default Web Site</WebSiteName> <WebSiteHost>mymachinename</WebSiteHost>   <WebService Include=“MyWebService“> <WebSitePath>C:\Inetpub\wwwroot\SampService</WebSitePath> <TFSPath> C:\Development\Store\SampWebService\</TFSPath> </WebService> </PropertyGroup> <Target Name=“PublishSite“ > <Web.WebSite.DeleteVirtualDirectory VirtualDirectoryName=“$(WebService)“ MachineName=“$(WebSiteHost)“ WebSiteName=“$(WebSiteName)“/> <AspNetCompiler Clean =“true“ PhysicalPath =“$(TFSPath)“ TargetPath =“$(WebSitePath)“ VirtualPath =“/$(WebService)“ Updateable =“false“ Force=“true“ ></AspNetCompiler> <Web.WebSite.CreateVirtualDirectory VirtualDirectoryName=“$(WebService)“ Path=“$(WebSitePath)“ MachineName=“$(WebSiteHost)“ AppPoolID=“$(AppPoolName)“ WebSiteName=“$(WebSiteName)“…

0

Msbuild Biztalk Import Bindings

<Project xmlns=“http://schemas.microsoft.com/developer/msbuild/2003“ DefaultTargets=“AddReferences;ImportBindings“> <Import Project=”c:\sdc\Microsoft.Sdc.Common.Tasks” /> <PropertyGroup > <MsgFailed>Failed Binding for </MsgFailed> <MsgSuccess>success Binding for </MsgSuccess> <BTServerName></BTServerName> <BTServerDatabase></BTServerDatabase> <AppName>Customer</AppName> <BindingDir>x.xml</BindingDir> </PropertyGroup> <Target Name=“AddReferences“ > <BizTalk2006.Application.AddReferences Application=“$(AppName)“ ReferenceApplications=“$(RefApplication)“ Server=“$(BTServerName)“ Database=“$(BTServerDatabase)“ /> </Target> <Target Name=“ImportBindings“ > <Exec Command=‘Btstask.exe ImportBindings -Source:”$(BindingDir)” -A:$(AppName) -Server:$(BTServerName) -Database:$(BTServerDatabase)‘ /> <Message Importance =“high“ Text =“$(MsgSuccess) : $(AppName)“ ContinueOnError =“true“ ></Message> <WriteLinesToFile File=“$(HighLevelErrFile)“ Lines=“$(MsgSuccess)…

1