---
title: "Stored Procedure Error - Transaction Count mismatch"  
description: "Stored Procedure Error - Transaction Count mismatch"  
author: "Anonymous User"  
published: 2015-01-21  
updated: 2015-01-21  
canonical: https://www.mindstick.com/forum/12886/stored-procedure-error-transaction-count-mismatch  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 2 minutes  

---

# Stored Procedure Error - Transaction Count mismatch

I've been doing this [stored procedure](https://www.mindstick.com/articles/803/using-stored-procedure-in-asp-dot-net), however when I [execute](https://www.mindstick.com/interview/49/how-can-i-execute-a-php-script-using-command-line) the stored procedure, I get an [infinity](https://answers.mindstick.com/qa/42270/is-gamora-dead-in-avengers-infinity-war-or-she-will-return-in-the-infinity-war-2) execution. This cause a deadlock.

```
ALTER PROCEDURE [dbo].[spMaterialReceivingCreateItemRequirements]   @DomainSite nvarchar(8),   @ItemNo nvarchar(18),   @tReceiving_id integer,   @SampleRequired integer,   @UserName nvarchar(50)ASBEGIN   Declare @ErrorNo integer = '',           @New_JobNo integer,           @Status nvarchar(50) = 'InProcess',           @SPName nvarchar(max) = '',           @intSampleNo integer =1,           @ErrorMessage nvarchar(max) = ''     begin transaction t1    Begin try        BEGIN            --Generate 1 sample for item requirements            set @SampleRequired = 1             WHILE (@intSampleNo <= @SampleRequired)            BEGIN                insert into tItemRequirements                   select                        domainSite, @tReceiving_id, @ItemNo,                       WorkCenter, tStationsType_id,                       tSpecTestParameters_descriptions_id,                       --row_number() OVER (ORDER BY ID) AS CurrentSet,                       1 AS CurrentSet,                       @intSampleNo, 1, 'InComplete', getdate(), @UserName                    from                        tspectestparameters                   where                        itemno = @ItemNo                  set @intSampleNo = @intSampleNo +1            end        END        END TRY        Begin catch             SELECT                  @ErrorNo = ERROR_NUMBER(),                 @SPName = ERROR_PROCEDURE(),                 @ErrorMessage = ERROR_MESSAGE();                  rollback transaction t1        end catchEND
```

## Replies

### Reply by Anonymous User

BEGIN TRANSACTION t1

```
BEGIN TRY    BEGIN        --Generate 1 sample for item requirements        SET @SampleRequired = 1         WHILE (@intSampleNo <= @SampleRequired)        BEGIN            INSERT INTO
tItemRequirements            SELECT
domainSite                , @tReceiving_id                , @ItemNo                ,
WorkCenter                ,
tStationsType_id                ,
tSpecTestParameters_descriptions_id                ,                --row_number() OVER (ORDER BY ID) AS CurrentSet,                1 AS CurrentSet                , @intSampleNo                , 1                , 'InComplete'                ,
getdate()                , @UserName            FROM tspectestparameters            WHERE itemno = @ItemNo             SET @intSampleNo= @intSampleNo + 1        END    ENDCOMMITEND TRY BEGIN CATCH    SELECT @ErrorNo =ERROR_NUMBER()        , @SPName =ERROR_PROCEDURE()        , @ErrorMessage= ERROR_MESSAGE();     ROLLBACK TRANSACTION
t1END CATCH
```


---

Original Source: https://www.mindstick.com/forum/12886/stored-procedure-error-transaction-count-mismatch

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.