Included page: .FrontPage.QA.Archive.ServiceAutomation.NRARollUp.2020.SetUp (edit)

import
TBOT.Generic.Database

!*****> Setup
ddt: SetUp
key value
ConnectionString Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100
BytesColumn DataObject
FileExtension zip
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\NRA-new
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\NRA-new\DataFiles
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\NRA-new
TargetDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\NRA-new\DataFiles
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\NRA-new
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\NRA-new\DataFiles
CompareResultDir \FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\NRA-new
ignorePathValidations false
DeleteFile true
NewYearFlag false
skipIgnorePatterns true
|

Queue Compute Jobs

ddt: DynamicQuery -- get Trust and PAN Details| WAITFOR DELAY '00:00:05' DECLARE @AccountNumber nvarchar(20) = '{{AccountNumber}}' DECLARE @TrustNumber nvarchar(20) = '{{TrustNumber}}' DECLARE @TaxYear int = {{TaxYear}} DECLARE @ProductCd nvarchar(30) = '{{ProductCode}}' DECLARE @ProductOpt nvarchar(20) = '{{ProductOption}}' EXEC AUTOTESTING.[dbo].[QueueCompute] @AcctNo=@AccountNumber, @TrustNo=@TrustNumber, @Year=@TaxYear, @ProductCode=@ProductCd, @ProductOption=@ProductOpt ,@UseTestForms=1
Comments# AccountNumber TrustNumber TaxYear ProductCode ProductOption ComputeStatus?
Fed&State 312G 1042BELGBO3 2020 Tax return Federal and state Success
Fed&State 312G 1042BELGBO3II 2020 Tax return Federal and state Success
Fed&State 312G 1042BXLBK 2020 Tax return Federal and state Success
Fed&State 312G 1042BXLBO3 2020 Tax return Federal and state Success
Fed&State 312G 1042LONDONBO3 2020 Tax return Federal and state Success
Fed&State 312G G236092 2020 Tax return Federal and state Success
Fed&State 312G G237684 2020 Tax return Federal and state Success
Fed&State 312G G362972 2020 Tax return Federal and state Success
Fed&State 312G G638164 2020 Tax return Federal and state Success
Fed&State 312G G015274 2020 Tax return Federal and state Success
Fed&State 312G 1042LUXBO3 2020 Tax return Federal and state Success
Fed&State 312G G160953 2020 Tax return Federal and state Success
Fed&State 312G G768300 2020 Tax return Federal and state Success
Fed&State 312G G112266 2020 Tax return Federal and state Success
Fed&State 312G G436397 2020 Tax return Federal and state Success
Fed&State 312G 1042NEW 2020 Tax return Federal and state Success
Fed&State 312G G015010 2020 Tax return Federal and state Success
Fed&State 312G G179980 2020 Tax return Federal and state Success
Fed&State 312G G179984 2020 Tax return Federal and state Success
Fed&State 312G G179986 2020 Tax return Federal and state Success
Fed&State 312G G189506 2020 Tax return Federal and state Success
Fed&State 312G G236762 2020 Tax return Federal and state Success
Fed&State 312G G247649 2020 Tax return Federal and state Success
Fed&State 312G G249069 2020 Tax return Federal and state Success
Fed&State 312G G249953 2020 Tax return Federal and state Success
Fed&State 312G G305945 2020 Tax return Federal and state Success
Fed&State 312G G479601 2020 Tax return Federal and state Success
Fed&State 312G G859254 2020 Tax return Federal and state Success
Fed&State 312G G865120 2020 Tax return Federal and state Success
Fed&State 312G G106112 2020 Tax return Federal and state Success
Fed&State 312G G107504 2020 Tax return Federal and state Success
Fed&State 312G G108001 2020 Tax return Federal and state Success
Fed&State 312G G109561 2020 Tax return Federal and state Success
Fed&State 312G G253010 2020 Tax return Federal and state Success

Queue Compute Jobs for CIF=538J

ddt: DynamicQuery -- get Trust and PAN Details| DECLARE @AccountNumber nvarchar(20) = '{{AccountNumber}}' DECLARE @TrustNumber nvarchar(20) = '{{TrustNumber}}' DECLARE @TaxYear int = {{TaxYear}} DECLARE @ProductCd nvarchar(30) = '{{ProductCode}}' DECLARE @ProductOpt nvarchar(20) = '{{ProductOption}}' EXEC AUTOTESTING.[dbo].[QueueCompute] @AcctNo=@AccountNumber, @TrustNo=@TrustNumber, @Year=@TaxYear, @ProductCode=@ProductCd, @ProductOption=@ProductOpt, @CIF ='538J',@UseTestForms=1
Comments# AccountNumber TrustNumber TaxYear ProductCode ProductOption ComputeStatus?
Fed&State 312G 1042BEBK 2020 Tax return Federal and state Success
Fed&State 312G 1042BEBO3 2020 Tax return Federal and state Success
Fed&State 312G 1042S-BK 2020 Tax return Federal and state Success
Fed&State 312G 1042S-BK-1 2020 Tax return Federal and state Success
Fed&State 312G G814977 2020 Tax return Federal and state Success
Fed&State 312G G768300 2020 Tax return Federal and state Success
Fed&State 312G G788075 2020 Tax return Federal and state Success

Queue Compute Jobs for CIF=967T

ddt: DynamicQuery -- get Trust and PAN Details| DECLARE @AccountNumber nvarchar(20) = '{{AccountNumber}}' DECLARE @TrustNumber nvarchar(20) = '{{TrustNumber}}' DECLARE @TaxYear int = {{TaxYear}} DECLARE @ProductCd nvarchar(30) = '{{ProductCode}}' DECLARE @ProductOpt nvarchar(20) = '{{ProductOption}}' EXEC AUTOTESTING.[dbo].[QueueCompute] @AcctNo=@AccountNumber, @TrustNo=@TrustNumber, @Year=@TaxYear, @ProductCode=@ProductCd, @ProductOption=@ProductOpt, @CIF ='967T',@UseTestForms=1
Comments# AccountNumber TrustNumber TaxYear ProductCode ProductOption ComputeStatus?
Fed&State 312G G192371 2020 Tax return Federal and state Success
Fed&State 312G G636617 2020 Tax return Federal and state Success
Fed&State 312G G037773 2020 Tax return Federal and state Success
Fed&State 312G G536285 2020 Tax return Federal and state Success
Fed&State 312G G238863 2020 Tax return Federal and state Success
Fed&State 312G G563149 2020 Tax return Federal and state Success
Fed&State 312G G973450 2020 Tax return Federal and state Success
Fed&State 312G G881916 2020 Tax return Federal and state Success
Fed&State 312G G897800 2020 Tax return Federal and state Success
Fed&State 312G G015045 2020 Tax return Federal and state Success
Fed&State 312G G987145 2020 Tax return Federal and state Success
Fed&State 312G G963361 2020 Tax return Federal and state Success
Fed&State 312G G107504 2020 Tax return Federal and state Success
Fed&State 312G G999790 2020 Tax return Federal and state Success
Fed&State 312G G015050 2020 Tax return Federal and state Success
Fed&State 312G G017175 2020 Tax return Federal and state Success