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]

01


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

<DotNetClassAdapter><CompanyNbr>101</CompanyNbr>

<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

0

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]

02

 

 

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

03

 

 

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

04

 

 

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

05

 

 

*** 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