Getting an run time exception when data type changes in Microsoft Excel

Question

Hi,I am building data driven tests cases, I am facing problem when values changes in the column.&nbsp;This is line entering client id in the systemAliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys.DDT.CurrentDriver.Value("ClientId")&nbsp;In the excel sheet there is column calledClientIdA04540930&nbsp;Testcomplete enters the first client (A045) successfully but throws Microsoft VB Script runtime error with Type mismatch for second client (40390)&nbsp;The format of this column in MS Excel is General , I also tried other text option. Also tried to give different format general/text to A045 and number to 40930.&nbsp;If I run the clients other way roundClientId40930A045It runs first client (40930) then throws exception for the next one.&nbsp;Any ideas or solution for this?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

ryan_moran · Answer

Can you post a bit more of your script?

irisqateam · Answer

Hi Ryan,Thanks for your reply. Here is the code.&nbsp;'&nbsp; 'Saving Personal Tax Forms &amp; Reports&nbsp; '&nbsp; Sub SavePersonalTaxExternalIssuesReports&nbsp;&nbsp;&nbsp;&nbsp; Set Driver = DDT.ExcelDriver("C:\IRISAutomation\IRISExternalIssues\IRISExternalIssues.xls" ,"SavePeronalTaxIssuesReports")&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Appending the log&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; Log.AppendFolder("Saving Reports For Personal Tax External Issues Clients") &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Start of Do Loop&nbsp;&nbsp; &nbsp;Do&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Call selectClientAndTaxYear&nbsp;&nbsp;&nbsp; Call ExtraSmallDelay&nbsp;&nbsp;&nbsp; Call SelectClientAndTaxYear&nbsp;&nbsp;&nbsp; 'If report type is Tax Computations&nbsp;&nbsp;&nbsp;&nbsp; If(Driver.Value("ReportType")="TaxComputation") Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Call ExtraSmallDelay&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Call TaxComputation&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Loop until EOF&nbsp;&nbsp;&nbsp; Call Driver.Next&nbsp;&nbsp;&nbsp; Loop Until Driver.EOF&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Pop log folder in test log&nbsp;&nbsp;&nbsp; Log.PopLogFolder()&nbsp;&nbsp; End Sub&nbsp; '&nbsp; 'Selecting the client &amp; tax year&nbsp; ' &nbsp;&nbsp; Sub SelectClientAndTaxYear&nbsp;&nbsp;&nbsp;&nbsp; 'Appending the log&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; Log.AppendFolder("Select Client &amp; Tax Year " + DDT.CurrentDriver.Value("Description"))&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Select Client|Select&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndIWINPTAX.MainMenu.Click("Client|Select")&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Select Search By Combobox&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndClientBrowser.cmbSearchBy.ClickItem("by Client ID")&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Enter Client Identifier and select client&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Click&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys("^a")&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys("[BS]")&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set&nbsp; Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys(DDT.CurrentDriver.Value("ClientId"))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Click Select button&nbsp;&nbsp;&nbsp; Call VerySmallDelay&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndClientBrowser.btnSelect.Click&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Click Leave button in No Client Tax Data Entered&nbsp;&nbsp;&nbsp; If(Aliases.PersonalTaxObjectMap.wndNoClientTaxDataEntered.Exists)Then&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aliases.PersonalTaxObjectMap.wndNoClientTaxDataEntered.btnLeave.Click&nbsp;&nbsp;&nbsp; End If&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Select the tax year &nbsp;&nbsp;&nbsp;&nbsp; Set enterTaxYear = Aliases.PersonalTaxObjectMap.wndIWINPTAX.ToolbarWindow32.cmbTaxYear&nbsp;&nbsp;&nbsp; enterTaxYear.ClickItem(DDT.CurrentDriver.Value("TaxYear"))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 'Pop log folder in test log&nbsp;&nbsp;&nbsp; Log.PopLogFolder()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; End Sub&nbsp;&nbsp;It is getting exception on the second client.I also performed debugging, for first time it brings correct values, for second it bring null value.&nbsp;Regards,Zeeshan

ryan_moran · Answer

Hmm..Can you try this and see if it still errors?&nbsp;'
  'Saving Personal Tax Forms &amp; Reports
  '
  Sub SavePersonalTaxExternalIssuesReports
 
    Set Driver = DDT.ExcelDriver("C:\IRISAutomation\IRISExternalIssues\IRISExternalIssues.xls" ,"SavePeronalTaxIssuesReports")
    
     'Appending the log    
    Log.AppendFolder("Saving Reports For Personal Tax External Issues Clients")  
     
    'Start of Do Loop
    Do
    
    'Call selectClientAndTaxYear
    Call ExtraSmallDelay
    Call SelectClientAndTaxYear

'If report type is Tax Computations
     If(Driver.Value("ReportType")="TaxComputation") Then  
        Call ExtraSmallDelay
        Call TaxComputation    
     End If    
    
    'Loop until EOF
    Call Driver.Next
    Loop Until Driver.EOF
    
    'Pop log folder in test log
    Log.PopLogFolder()
 
  End Sub

'
  'Selecting the client &amp; tax year
  '  
  Sub SelectClientAndTaxYear
 
    'Appending the log    
    Log.AppendFolder("Select Client &amp; Tax Year " + DDT.CurrentDriver.Value("Description"))
    
    'Select Client|Select
    Aliases.PersonalTaxObjectMap.wndIWINPTAX.MainMenu.Click("Client|Select")
    
    'Select Search By Combobox
    Aliases.PersonalTaxObjectMap.wndClientBrowser.cmbSearchBy.ClickItem("by Client ID")
    
    'Enter Client Identifier and select client    
    Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Click
    Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys("^a")
    Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys("[BS]")
              
    Aliases.PersonalTaxObjectMap.wndClientBrowser.txtClientId.Keys(DDT.CurrentDriver.Value("ClientId"))
        
    'Click Select button
    Call VerySmallDelay
    Aliases.PersonalTaxObjectMap.wndClientBrowser.btnSelect.Click
    
    'Click Leave button in No Client Tax Data Entered
    If(Aliases.PersonalTaxObjectMap.wndNoClientTaxDataEntered.Exists)Then
        Aliases.PersonalTaxObjectMap.wndNoClientTaxDataEntered.btnLeave.Click
    End If
         
    'Select the tax year  
    Set enterTaxYear = Aliases.PersonalTaxObjectMap.wndIWINPTAX.ToolbarWindow32.cmbTaxYear
    enterTaxYear.ClickItem(DDT.CurrentDriver.Value("TaxYear"))
        
    'Pop log folder in test log
    Log.PopLogFolder()         
 
  End Sub&nbsp;

irisqateam · Answer

Hi Ryan,I tried that but still getting that run time exception.&nbsp;&nbsp;

marsha_r · Answer

I had something like this where the comparison worked fine when it was in a keyword test but when I converted to script I started getting the runtime errors. &nbsp;What ended up working for me is trimming all the strings. &nbsp;&nbsp;This is my comparison of&nbsp;a grid value to an Excel value (of type General).&nbsp;While aqString.Trim(itemlotattributes_browse.wValue(AttributeIndex, "Attribute ID")) &lt;&gt; aqString.Trim(Project.Variables.POAttributes.Value("name"))&nbsp;&nbsp;

Forum Discussion

Getting an run time exception when data type changes in Microsoft Excel

5 Replies

Recent Discussions

ADO Pipeline Execution Fail issue after TC\TE upgrade

RuntimeError: The object does not exist

Fields data to compare?

Related Content

Am getting SAAJ exception

Getting : ERROR: Exception in request: java.net.SocketException: Connect

why i am getting Microsoft Jscript runtime error