SDLC TESTING PHASE

SDLC TESTING PHASE - SAMPLES

All Content is for Demo Use Only

** Please Note: All samples found on this site are sanitized snippets of actual
work products that are only intended to convey breadth of experience and are
not intended to be accurate nor complete work products.
* Actual work product samples can be viewed in person upon request.

*** Defect Analysis – Some (Sample) MS T-SQL Database Event Log Queries used to Retrieve/Analyze data during Unit Testing & QA for Identifying / Reporting Application Errors (Defects) [Created in 2009]

select top 10 * from message..msg_store where msg_process_date > '4/21/09' and msg_type = BatchInv'

and msg_body like '%<BatchName>AALBATCH%'

msg_nbr	msg_id	msg_type	msg_queue_date	msg_process_date	msg_error_date	msg_complete_date	msg_body
136293	48BB2755-0D0C-4C18-98DD-786D8A5A0131	BatchInv	36:54.7	36:54.7	36:56.3	NULL	<BatchRequest xmlns="http://xxxxxx.com/AutoSolutions/2008/07" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><CreditUserActivity><ActivityId>9d0e03a9-d3fd-4ba9-8427-ae2471158b5e</ActivityId><ActivityType>Oltp</ActivityType><Culture>en-US</Culture><DomainName>Domain</DomainName><SystemNbr>9</SystemNbr><UserId>tfsoca</UserId><CenterNbr>999</CenterNbr><CompanyNbr>105</CompanyNbr></CreditUserActivity><BatchName>Common</BatchName><InterfaceName>BatchLetter</InterfaceName><InterfaceRestartFlag>false</InterfaceRestartFlag></BatchRequest>	DF9C7039-0BB6-47B5-9D54-0D91B5BD4DC4	105	NULL

select * from TRM..MESSAGE_LOG where log_date > '4/21/09 14:00' AND comp_nbr= '101'

606

54:

42.8

<AssemblyName>Xxxxxx.Base. Common.Batch.dll

</AssemblyName><ClsName>Xxxxxx.

Base.Common.Batch.Broker</ClsName>

</DotNetClassAdapter> ==> Failed to create SqlDatabase ->

The requested database Company0 is not defined in configuration.

Service

Xxxxxx.Framework.Core -> Microsoft.Practices. EnterpriseLibrary.Common

at Xxxxxx.Framework.Data.SqlAccess..ctor(Activity userActivity) in d:\P4\SCMKOP_DotNet_Builds_Msg\V50\DEV\B11\Src\Services\Xxxxxx

\Framework\Common\Data\SqlAccess.cs:line 120 at Xxxxxx.Base.Common.Batch.Broker.InitializeBatchProcess() in

C:\P4\V50\DEV\B11\Src\Services\Xxxxxx\Base\Common\Batch\Broker.cs:line 206 at Xxxxxx.Base.Common.Batch.Broker.Xxxxxx.Framework.Messaging.IWorker.Execute(MessageContext messageContext) in C:\P4\V50\DEV\B11\Src\Services\Xxxxxx\Base\Common\Batch\Broker.cs:line 164 at Xxxxxx.Framework.Messaging.Adapter.DotNetClassAdapter.Execute(MessageContext msgContext) in d:\P4\SCMKOP_DotNet_Builds_Msg\V50\DEV\B11\Src\Services\Xxxxxx

\Framework\Messaging\Adapter\DotNetClassAdapter.cs:line 88 => at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.

BuildUp[T](IReadWriteLocator locator, ILifetimeContainer lifetimeContainer, String id,

IConfigurationSource configurationSource) at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.

EnterpriseLibraryFactory.BuildUp[T](String id, IConfigurationSource configurationSource)

at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.

ObjectBuilder.NameTypeFactoryBase`1.Create(String name) at Microsoft.Practices.

EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(String name)

at Xxxxxx.Framework.Data.SqlAccess..ctor(Activity userActivity) in d:\P4\SCMKOP_DotNet_Builds_Msg\V50\DEV\B11\Src\Services\Xxxxxx\Framework

\Common\Data\SqlAccess.cs:line 92

T BuildUp[T](Microsoft.Practices. ObjectBuilder2.IReadWriteLo

DEV10

101

12517721-A576-4C49-

AE70-7676AA0CB450

Xxxxxx.Framework. Messaging.Engine.exe

Error

3896

C:\V5\Services\bin\Xxxxxx.

Framework.Messaging.Engine.exe

*** Some (Sample) MS T-SQL Manual Queries used to Retrieve/Analyze/Modify data during Testing & Support Phases [Created in 2009]

*** Functional Testing – Test Objective Definition, Test Script Definition & Test Result Reporting (Sample) [Created in 2006-2009]

	*** Issue Tracking log - User Acceptance Testing (Sample) [Created in 2006]
04

*** Defect Tracking & Reporting – Functional Testing [Created in 2007]

	*** Quality Assurance (QA) - Test Script Creation, Data Selection, Manual Test Script Execution [Created in 2007]
06

	*** Quality Assurance (QA) - Test Planning & Tracking [Created in 2007]
07

	***
08

	***
09

	***
10