Data driven test failed if executed from Test List or Test View

4 posts, 1 answers
  1. Usman
    Usman avatar
    9 posts
    Member since:
    Jun 2010

    Posted 18 Aug 2010 Link to this post

    I databind 3 tests to an Excel sheet. 2 tests use Sheet1 and 1 test uses Sheet2.
    If I run any of the test using Quick Execute it works fine.
    But when I try to run the test using Test List or Test view it fails with error below.
    All the tests have their DataType set to Excel and they are pointing to correct Datasource and DataTableName (sheet in the Excel workbook)
    And the DataConnectionString is blank


    *****************************************************************************************************
    Overall Result: Fail
    --------------------------------------------------
    '18/08/2010 02:00:34 PM' - Unexpected exception during execution.
    '18/08/2010 02:00:34 PM' - System.Data.OleDb.OleDbException (0x80040E37): The Microsoft Office Access database engine could not find the object 'Sheet1$'.  Make sure the object exists and that you spell its name and the path name correctly.
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
       at ArtOfTest.Common.Design.Data.ExcelDataSource.GetData(DataInfo testBindingInfo)
       at ArtOfTest.WebAii.Design.Execution.DataContext.InitializeDataSource(String outDirectory)
       at ArtOfTest.WebAii.Design.Execution.ExecutionContext.SetCurrentTestAndData(Test test)
       at ArtOfTest.WebAii.Design.Execution.TestExecuteProxy.ExecuteTest(Test test, Settings settings, String deploymentFolder, ExecutionType exeType)
    --------------------------------------------------
    '18/08/2010 02:00:34 PM' - Overall Result: Fail
    --------------------------------------------------

  2. Usman
    Usman avatar
    9 posts
    Member since:
    Jun 2010

    Posted 18 Aug 2010 Link to this post

    Some more info:
    I'm using Web UI Developer Edition and VS 2010.
  3. Answer
    Konstantin Petkov
    Admin
    Konstantin Petkov avatar
    1911 posts

    Posted 18 Aug 2010 Link to this post

    Hello Usman,

    Thank you for posting this question!

    I was able to reproduce the error quite easy. It seems the problem occurs due to the disabled deployment in VS 2010 by default. Please follow the steps from this blog post to resolve the problem and let us know if you need further assistance or this works fine for you too.

    Kind regards,
    Konstantin Petkov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. Usman
    Usman avatar
    9 posts
    Member since:
    Jun 2010

    Posted 18 Aug 2010 Link to this post

    It solved the problem :)
    Thank you very much for your quick response.

    Usman
Back to Top