FormatException when using DBQueryStep

Dec 4, 2007 at 6:54 PM
I'm trying to use DBQueryStep and I keep getting a FormatException. (See below). I think it's something silly with my syntax but I'm not sure. Any help is appreciated. Thanks!

<TestStep assemblyPath="" typeName="Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBQueryStep">
<DelayBeforeCheck>5</DelayBeforeCheck>
<ConnectionString>Persist Security Info=False;Integrated Security=SSPI;database=DATA_011;server=omega;Connect Timeout=30</ConnectionString>

<SQLQuery>
<RawSQLQuery>
select qtyonhand from iminvloc_sql
where loc = '701'
and item_no = '990219'
</RawSQLQuery>
</SQLQuery>

<Rows>
<Columns>
<qtyonhand>1190.0000</qtyonhand>
</Columns>
</Rows>
</TestStep>

<![CDATA[ System.FormatException : Input string was not in a correct format.
]]>
</message>
- <stack-trace>
- <![CDATA[ at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ToInt32(Object value)
at Microsoft.Services.BizTalkApplicationFramework.BizUnit.Context.ReadConfigAsInt32(XmlNode config, String xPath) in C:\Kevin\Code-Projects\BizUnit\BizUnit2.2\Src\BizUnit\Context.cs:line 374
at Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBExecuteNonQueryStep.Execute(XmlNode testConfig, Context context) in C:\Kevin\Code-Projects\BizUnit\BizUnit2.2\Src\BizUnit\TestSteps\DBExecuteNonQueryStep.cs:line 92
at Microsoft.Services.BizTalkApplicationFramework.BizUnit.BizUnit.ExecuteSteps(XmlNodeList steps) in C:\Kevin\Code-Projects\BizUnit\BizUnit2.2\Src\BizUnit\BizUnit.cs:line 608
at Microsoft.Services.BizTalkApplicationFramework.BizUnit.BizUnit.Setup() in C:\Kevin\Code-Projects\BizUnit\BizUnit2.2\Src\BizUnit\BizUnit.cs:line 449
at Microsoft.Services.BizTalkApplicationFramework.BizUnit.BizUnit.RunTest() in C:\Kevin\Code-Projects\BizUnit\BizUnit2.2\Src\BizUnit\BizUnit.cs:line 438
at Tests.TestInventoryXfer.Test11() in C:\01Dev\BurtsBees.RedPrairie\Tests\TestInventoryXfer.cs:line 17
Dec 10, 2007 at 9:36 PM
You're getting that message when it's trying to pick up one of the parameters from your test case. Perhaps it doesn't like the decimal point in 1190.0000?

Perhaps add the bizunit project into your solution and add some debug code in the DBQueryStep code..?