Issue with NumberOfRowsAffected property for DBExecuteNonQueryStep

Mar 9, 2010 at 1:41 PM

 

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 BizUnit.Context.ReadConfigAsInt32(XmlNode config, String xPath) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\Context.cs:line 787
at BizUnit.DBExecuteNonQueryStep.Execute(XmlNode testConfig, Context context) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\TestSteps\DBExecuteNonQueryStep.cs:line 120
at BizUnit.BizUnitOM.BizUnitTestStepWrapper.Execute(Context ctx) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\BizUnitOM\BizUnitTestStepWrapper.cs:line 140
at BizUnit.BizUnit.ExecuteTestStep(BizUnitTestStepWrapper stepWrapper, TestStage stage) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\BizUnit.cs:line 981Hi 

I am having an issue when I leave the NumberOfRowsAffected property blank in the DBExecuteNonQueryStep step.   Has anyone else had this issue?  I believe the property is optional.

 

Here is my code...it does work if I specify a NumberOrRowsAffected, the problem is this number can change which is why I would like it optional.

 

<TestStep assemblyPath="" typeName="BizUnit.DBExecuteNonQueryStep">

<DelayBeforeExecution>1</DelayBeforeExecution>

<NumberOfRowsAffected></NumberOfRowsAffected>

<ConnectionString>Password=Schrute57;Persist Security Info=True;User ID=btsdsapp;Initial Catalog=ELMER_DEV;Data Source=CTDAYSQL14</ConnectionString>

<SQLQuery>

<RawSQLQuery>EXECUTE admin.uspAdminDeleteOutboundInvoice '015208419002','W',null</RawSQLQuery>

</SQLQuery>

</TestStep>

 

 

And here is the stack trace:

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 BizUnit.Context.ReadConfigAsInt32(XmlNode config, String xPath) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\Context.cs:line 787

at BizUnit.DBExecuteNonQueryStep.Execute(XmlNode testConfig, Context context) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\TestSteps\DBExecuteNonQueryStep.cs:line 120

at BizUnit.BizUnitOM.BizUnitTestStepWrapper.Execute(Context ctx) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\BizUnitOM\BizUnitTestStepWrapper.cs:line 140

at BizUnit.BizUnit.ExecuteTestStep(BizUnitTestStepWrapper stepWrapper, TestStage stage) in C:\Program Files\BizUnit\BizUnit 3.1\Src\BizUnit\BizUnit.cs:line 981