TSTCheck.bat fails

Nov 2, 2011 at 1:17 PM

Hey guys,

just downloaded T.S.T. and wanted to take it for a spin now. Installed it successfully, at least that is what it claimed, via the TST.bat Skript.

Then I ran the TSTCheck.bat, but 18 out of 27 Tests from the "Transaction" Test Suite failed and I don't have a clue why. I hope it'll be obvious from the log, which I'll attach to the very end of this post, what the problem is! :-)

All other tests were successful... I have restarted the SQL Server already. SQL Server Management Studio has been connected/not connected/off during three attempts.

Thank you!!

Sandro

    Suite: Transaction. Tests: 27. Passed: 9. Failed: 18
        Test: SQLTest_Transaction#Proc_Setup_TranNewTransaction. Failed
            Failure: Assert.IsLike failed. [Log Message #2 for SProc 'SQLTest_Proc_Setup_TranBegin#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndBeginTranS1%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_SETUP_Proc_Setup_TranBegin]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 2. Procedure: InsertTestEntryAndBeginTranS1. Line: 0'
        Test: SQLTest_Transaction#Proc_Setup_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Proc_Setup_TranRollback#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndRollbackS1%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_SETUP_Proc_Setup_TranRollback]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 0. Procedure: InsertTestEntryAndRollbackS1. Line: 0'
        Test: SQLTest_Transaction#Proc_Setup_TranRollbackSRDisabled. Passed
        Test: SQLTest_Transaction#Proc_Teardown_TranNewTransaction. Failed
            Failure: Assert.IsLike failed. [Log Message #4 for SProc 'SQLTest_Proc_Teardown_TranBegin#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndBeginTranT1%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_TEARDOWN_Proc_Teardown_TranBegin]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 2. Procedure: InsertTestEntryAndBeginTranT1. Line: 0'
        Test: SQLTest_Transaction#Proc_Teardown_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Proc_Teardown_TranRollback#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndRollbackT1%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_TEARDOWN_Proc_Teardown_TranRollback]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 0. Procedure: InsertTestEntryAndRollbackT1. Line: 0'
        Test: SQLTest_Transaction#Proc_Teardown_TranRollbackSRDisabled. Passed
        Test: SQLTest_Transaction#Proc_Test_Multi_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Proc_Test_Multi_TranRollback#TestB'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndRollback3%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Proc_Test_Multi_TranRollback#TestB]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 0. Procedure: InsertTestEntryAndRollback3. Line: 0'
        Test: SQLTest_Transaction#Proc_Test_Multi_TranRollbackSRDisabled. Passed
        Test: SQLTest_Transaction#Proc_Test_SavePointTransaction. Passed
        Test: SQLTest_Transaction#Proc_Test_TranCommit. Passed
        Test: SQLTest_Transaction#Proc_Test_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Proc_Test_TranRollback#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndRollback1%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Proc_Test_TranRollback#Test]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 0. Procedure: InsertTestEntryAndRollback1. Line: 0'
        Test: SQLTest_Transaction#Proc_Test_TranRollbackSRDisabled. Passed
        Test: SQLTest_Transaction#Test_NoTransaction. Passed
        Test: SQLTest_Transaction#Test_TranNewTransaction. Failed
            Failure: Assert.IsLike failed. [Log Message #3 for SProc 'SQLTest_Proc_Test_TranBegin#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndBeginTran1%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Proc_Test_TranBegin#Test]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 2. Procedure: InsertTestEntryAndBeginTran1. Line: 0'
        Test: SQLTest_Transaction#Test_TranNewTransactionSRDisabled. Failed
            Failure: Assert.IsLike failed. [Log Message #3 for SProc 'SQLTest_Proc_Test_TranBeginSRDisabled#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.%InsertTestEntryAndBeginTran2%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Proc_Test_TranBeginSRDisabled#Test]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 0, aktuelle Anzahl = 1. Procedure: InsertTestEntryAndBeginTran2. Line: 0'
        Test: SQLTest_Transaction#Trigger_Setup_Multi_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Trigger_Setup_Multi_TranRollback#TestA'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_SETUP_Trigger_Setup_Multi_TranRollback]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Setup_Multi_TranRollbackSRDisabled. Failed
            Failure: Assert.IsLike failed. [Log Message #2 for SProc 'SQLTest_Trigger_Setup_Multi_TranRollbackSRDisabled#TestA'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_SETUP_Trigger_Setup_Multi_TranRollbackSRDisabled]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Teardown_Multi_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Trigger_Teardown_Multi_TranRollback#TestA'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_TEARDOWN_Trigger_Teardown_Multi_TranRollback]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Teardown_Multi_TranRollbackSRDisabled. Failed
            Failure: Assert.IsLike failed. [Log Message #4 for SProc 'SQLTest_Trigger_Teardown_Multi_TranRollbackSRDisabled#TestA'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_TEARDOWN_Trigger_Teardown_Multi_TranRollbackSRDisabled]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Test_Multi_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Trigger_Test_Multi_TranRollback#TestB'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Trigger_Test_Multi_TranRollback#TestB]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Test_Multi_TranRollbackSRDisabled. Failed
            Failure: Assert.IsLike failed. [Log Message #3 for SProc 'SQLTest_Trigger_Test_Multi_TranRollbackSRDisabled#TestB'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Trigger_Test_Multi_TranRollbackSRDisabled#TestB]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Test_NoTransaction. Passed
        Test: SQLTest_Transaction#Trigger_Test_TranBegin. Failed
            Failure: Assert.IsLike failed. [Log Message #3 for SProc 'SQLTest_Trigger_Test_TranBegin#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing%InsertTestEntryTriggerTransactionBegin%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Trigger_Test_TranBegin#Test]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 2. Procedure: InsertTestEntryTriggerTransactionBegin. Line: 0'
        Test: SQLTest_Transaction#Trigger_Test_TranBeginSRDisabled. Failed
            Failure: Assert.IsLike failed. [Log Message #3 for SProc 'SQLTest_Trigger_Test_TranBeginSRDisabled#Test'] Test value: '%Error: 266, Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing%InsertTestEntryTriggerTransactionBegin%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Trigger_Test_TranBeginSRDisabled#Test]'. Error: 266, Die Transaktionsanzahl nach EXECUTE deutet auf eine nicht �bereinstimmende Anzahl von BEGIN- und COMMIT-Anweisungen hin. Vorherige Anzahl = 1, aktuelle Anzahl = 2. Procedure: InsertTestEntryTriggerTransactionBegin. Line: 0'
        Test: SQLTest_Transaction#Trigger_Test_TranCommit. Passed
        Test: SQLTest_Transaction#Trigger_Test_TranRollback. Failed
            Failure: Assert.IsLike failed. [Log Message #1 for SProc 'SQLTest_Trigger_Test_TranRollback#Test'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted.%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Trigger_Test_TranRollback#Test]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'
        Test: SQLTest_Transaction#Trigger_Test_TranRollbackSRDisabled. Failed
            Failure: Assert.IsLike failed. [Log Message #3 for SProc 'SQLTest_Trigger_Test_TranRollbackSRDisabled#Test'] Test value: '%Error: 3609, The transaction ended in the trigger. The batch has been aborted%InsertTestEntryTriggerTransactionRollback%'. Actual value: 'An error occured during the execution of the test procedure '[TSTCheckTran].[dbo].[SQLTest_Trigger_Test_TranRollbackSRDisabled#Test]'. Error: 3609, Die Transaktion endete mit dem Trigger. Der Batch wurde abgebrochen. Procedure: InsertTestEntryTriggerTransactionRollback. Line: 7'

Coordinator
Nov 2, 2011 at 8:04 PM
Edited Nov 2, 2011 at 8:10 PM

The failures you see are the result of a limitation in TSTCheck only (TST works just fine). TSTCheck only works on an English system. If you look at the error messages you can see that TST tries to compare two versions of the same message – one in English and one in German. .
This limitation is only for TSTCheck. TST does not have this limitation, you can use TST for writing your own tests on a localized (German or otherwise) SQL Server just fine.

Unless you want to change the TST system don’t worry about TSTCheck. The purpose of TSTCheck is to verify the TST system itself. I use it during the development of TST to make sure that I do not introduce regressions in the existing features and that the new TST features are working correctly. The only reason I included TSTCheck in the deployed package is to support people that may want to change/adapt TST for themselves.

 

Nov 2, 2011 at 10:31 PM
Awesome, thanks! :-)

If you need anything from the German system here to make it more universal, let me know!

Best,
Sandro

2011/11/2 lmolnar <notifications@codeplex.com>

From: lmolnar

The failure that you see is the result of a limitation in TSTCheck: it only works on an English system. If you look at the error messages you can see that TST tries to compare two versions of the same message – one in English and one in German. .
This limitation of TSTCheck will have no impact on your ability of using TST, you can use TST for writing your own tests on a localized SQL Server just fine.

Unless you want to change the TST system don’t worry about TSTCheck. The purpose of TSTCheck is to verify the TST system itself. I use it during development to make sure that I do not introduce regressions in the existing features and that the new features are working correctly. The only reason I included TSTCheck in the deployed package is to support people that may want to change/adapt TST for themselves.

Read the full discussion online.

To add a post to this discussion, reply to this email (TST@discussions.codeplex.com)

To start a new discussion for this project, email TST@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com


Coordinator
Nov 3, 2011 at 10:11 PM

Hello Sandro,

Much appreciated. If you don’t mind I’ll send you a private copy of the new release in a few days. If you could run TSTCheck on that and check for me – that’d be great.

Thanks

Coordinator
Nov 5, 2011 at 1:51 AM

Hello Sandro,
 
I attached a pre-release package for TST V1.8. See under the tab "Issue Tracker", the item called "TSTCheck.bat fails on a localized SQL Server". That item has n attachment: TST_1_8.zip. If you could install that on a German server and run TSTCheck - I'd appreciate it.

Nov 6, 2011 at 1:15 PM

You got it in the issue tracker! :-)

Coordinator
Nov 6, 2011 at 11:08 PM


Thank you Sandro. Really appreciated. I added more comments on the issue. For ppl who only look at this discussion, here is the current state:

TSTCheck.BAT has two parts.
- The first part is running TST validation on the TST itself. Thanks to your feedback I was able to fix that part – at this point it will work on a localized SQL Server.
- The second part is validating the TXT and XML output of TST. This part still has issues on a localized SQL Server. It would take more work to fix this. 

Since TSTCheck.BAT is meant to help people who want to modify TST itself, making this run on a localized version of the SQL Server is low priority. This limitation of TSTCheck.BAT in no way impacts TST.BAT which works fine on a localized server. Making TSTCheck.BAT run on a localized server is not at this point on my radar.