search

Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
106 stars 37 forks source link

Unable to run ETL tests from docs #598

Open permind opened 4 years ago

permind commented 4 years ago

Hi, I'm struggling to run even a basic ETL test from docs. Using fresh installation NBi.Framework (1.22). Tests are executed on SQL Server machine. Any hints what could be wrong here?

<test name="Basic package run" uid="0003">
  <system-under-test>
    <execution>
      <etl path="D:\ETLTests\" name="BasicLoad.dtsx" version="SqlServer2016">
      </etl>
    </execution>
  </system-under-test>
  <assert>
    <successful/>
  </assert>
</test>

The error:

NBi.NUnit.Runtime.TestSuite.Basic package run:
System.ArgumentException : Value does not fall within the expected range.
 <test name="Side effects with SSISDB">
  <setup>
    <etl-run
      server="localhost"
      catalog="SSISDB"
      folder="ETLTests"
      project="ETL_Tests_Demo"
      name="BasicLoad.dtsx"
      version="SqlServer2016">
    </etl-run>
  </setup>
  <system-under-test>
   <result-set>
    <query connection-string="Provider=SQLNCLI11;Server=localhost;Database=ETLTest;Trusted_Connection=yes;">
        SELECT * from dbo.srcTestTable
    </query>
   </result-set>
  </system-under-test>
  <assert>
   <equal-to>
    <query connection-string="Provider=SQLNCLI11;Server=localhost;Database=ETLTest;Trusted_Connection=yes;">
        SELECT * from dbo.dstTestTable
    </query>
   </equal-to>
  </assert>
 </test>

The error:

NBi.NUnit.Runtime.TestSuite.Side effects with SSISDB:
Exception during the setup of the test: '<>f__AnonymousType1<NBi.Core.Scalar.Resolver.IScalarResolver<string>,NBi.Core.Scalar.Resolver.IScalarResolver<string>,NBi.Core.Scalar.Resolver.IScalarResolver<string>>' does not contain a definition for 'Etl'
   at CallSite.Target(Closure , CallSite , Object )
   at System.Dynamic.UpdateDelegates.UpdateAndExecute1[T0,TRet](CallSite site, T0 arg0)
   at ActLike_IEtlRunCommandArgs_950c1299fd5546f4ad476872d67e5969.get_Etl()
   at NBi.Core.Decoration.DataEngineering.EtlRunCommand.Execute() in C:\projects\nbi\NBi.Core\Decoration\DataEngineering\Commands\SqlServer\EtlRunCommand.cs:line 17
   at NBi.NUnit.Runtime.TestSuite.ExecuteSetup(SetupXml setup, IDictionary`2 allVariables) in C:\projects\nbi\NBi.NUnit.Runtime\TestSuite.cs:line 175
Seddryck commented 4 years ago

I probably broke something in the latetst releases of NBi related to SSIS. Since the beginning the management of the SQL Server versions has been a pain and I decided to push this to a separate package. I'll take a look to this.

stefaniaa09 commented 2 years ago

Hi, I have the same error in NBi.Framework 1.23.0 (NBi.VisualStudio 1.22.1). It is something broken in this release too?

Thank you!

Seddryck commented 2 years ago

I’m convinced that I broke something earlier and that I never fixed it.

On 23 Aug 2022, at 11:38, stefaniaa09 @.***> wrote:

 Hi, I have the same error in NBi.Framework 1.23.0 (NBi.VisualStudio 1.22.1). Is something broken in this release too?

Thank you!

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.