Included page: .FrontPage.QA.BalanceDue.2024.QA.SetUp (edit)

import

TBOT.Generic.Database

variable defined: ENV=QA
variable defined: QA=http://10.184.7.166:9510/
variable defined: SAT=http://10.184.73.99:9510/
variable defined: URL=http://10.184.7.166:9510/

ddt: SetUp
key	value
ConnectionString	Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue
DownloadPath	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue\Actuals
SourceDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue\Actuals
TargetDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\OTTDataQA\TrustElf\acks\EFTPS\incoming
CompareResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue
ExpectedDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue
ActualDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue\Actuals
ResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue
Debug	TRUE
ignorePathValidations	false
DeleteFile	true

Execute BTMDB..Package

ddt: KeywordFixture	SELECT DB_NAME , LTRIM(RTRIM(Server)) as Server, AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number from BTMDB..Package where AcctNo='{{PAN}}'
Comments#	PAN	TaxYear	SeqNumber	WorkingDayStartCount	DB_NAME?	Server?	AcctNo?	Tax_Year?	Seq_Number?	GETNEXTWORKINGDAY?
Test0001	5010	2024	1	1	$DBName1=	$Server1=	$AcctNo1=	$Tax_Year1=	$Seq_Number1=	$SetDate1=

Execute spUpdInsBatchWIP

ddt: DynamicQuery	DECLARE @Dt datetime,@batchID bigint set @Dt=GETDATE() exec {{DataBaseName}}.BANKDB_P.spUpdInsBatchWIP @BatchType_Cd='M',@AcctNo='{{PAN}}',@Status_Cd='Q', @Start_Dt=@Dt,@AddedIni='@AJ',@BatchOpt=146,@Quarter={{SeqNumber}},@Year={{TaxYear}}
Comments#	PAN	TaxYear	SeqNumber	DataBaseName	BatchID?
Test0001	$AcctNo1	$Tax_Year1	$Seq_Number1	$DBName1	$BatchID1=

Execute JCSQueueProcess

ddt: DynamicQuery	DECLARE @jobId numeric(29,0) exec BTMJOBSDB.BTMJOBSDB_P.JCSQueueProcess @JobIDParent=default,@ReqComputer=NULL,@ReqUserName='@AJ', @ReqSessionId=0,@ReqPathMode='PRD',@ReqPriority=1,@ReqSuperId=0,@ReqAcctNo='{{PAN}}', @ReqTrustNo=default, @ReqServer='{{ServerName}}',@ReqDatabase='{{DataBaseName}}', @ReqKeyField={{BatchID}}, @JobParm='$ACCT={{PAN}}$YEAR={{TaxYear}}$SEQ={{SeqNumber}}$L=@AJ$FTP=Y$EDI=P$DEBUG=N$PRODOPT=107$BATCHOPT=124$SDT={{SettilementDate}}$DB={{DataBaseName}}$PCODE=F$ST=MA$A=PRD BID={{BatchID}}',@ProcessCode=1056,@JobGroupID=1,@JobHold=0,@JobDisposition=0,@JobID=@jobId output
Comments#	SettilementDate	PAN	TaxYear	SeqNumber	BatchID	ServerName	DataBaseName
Test0001	$SetDate1	$AcctNo1	$Tax_Year1	$Seq_Number1	$BatchID1	$Server1	$DBName1

Checking Batch QueueStatus[?]

ddt: DynamicQuery	WAITFOR DELAY '00:00:15'; declare @BatchQueue nvarchar(100) IF (select count(*) FROM {{DataBaseName}}.dbo.BatchWIP where Batchid={{BatchID}} and Status_Cd='E') > 0 select @BatchQueue = 'Batch is not queued' ELSE select @BatchQueue = 'Batch queued sucessfully' select @BatchQueue as BatchQueue
Comments#	DataBaseName	BatchID	BatchQueue?
Test0001	$DBName1	$BatchID1	Batch queued sucessfully