Databases
StackOverflow2013
Postsdbo
POCurrent transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCurrent transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
    primarykey
    data
    text
    <p>I know that there are other questions with the exact title as the one I posted but each of them are very specific to the query or procedure they are referencing.</p> <p>I manage a Blackboard Learn system here for a college and have direct database access. In short there is a stored procedure that is causing system headaches. Sometimes when changes to the system get committed errors are thrown into logs in the back end, identifying a stored procedure known as <code>bbgs_cc_setStmtStatus</code> and erroring out with <code>The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.</code></p> <p>Here is the code for the SP, however, I did not write it, as it is a stock piece of "equipment" installed by Blackboard when it populates and creates the tables for the application.</p> <pre><code>USE [BBLEARN] GO /****** Object: StoredProcedure [dbo].[bbgs_cc_setStmtStatus] Script Date: 09/27/2013 09:19:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[bbgs_cc_setStmtStatus]( @registryKey nvarchar(255), @registryVal nvarchar(255), @registryDesc varchar(255), @overwrite BIT ) AS BEGIN DECLARE @message varchar(200); IF (0 &lt; (SELECT count(*) FROM bbgs_cc_stmt_status WHERE registry_key = @registryKey) ) BEGIN IF( @overwrite=1 ) BEGIN UPDATE bbgs_cc_stmt_status SET registry_value = @registryVal, description = @registryDesc, dtmodified = getDate() WHERE registry_key = @registryKey; END END ELSE BEGIN INSERT INTO bbgs_cc_stmt_status (registry_key, registry_value, description) VALUES (@registryKey, @registryVal, @registryDesc); END SET @message = 'bbgs_cc_setStmtStatus: Saved registry key [' + @registryKey + '] as status [' + @registryVal + '].'; EXEC dbo.bbgs_cc_log @message, 'INFORMATIONAL'; END </code></pre> <p>I'm not expecting Blackboard specific support, but I want to know if there is anything I can check as far as SQL Server 2008 is concerned to see if there is a system setting causing this. I do have a ticket open with Blackboard but have not heard anything yet.</p> <p>Here are some things I have checked:</p> <p>tempdb system database:</p> <p>I made the templog have an initial size of 100MB and have it auto grow by 100MB, unrestricted to see if this was causing the issue. It didn't seem to help. Our actual tempdb starts at 4GB and auto grows by a gig each time it needs it. Is it normal for the space available in the tempdb to be 95-985 of the actual size of the tempdb? For example, right now tempdb has a size of 12388.00 MB and the space available is 12286.37MB.</p> <p>Also, the log file for the main <code>BBLEARN</code> table had stopped growing because it reached its maximum auto grwoth. I set its initial size to 3GB to increase its size.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGreg Sansom
    1. USChristopher Bruce
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCurrent transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThat error can be generated by bbgs_cc_log storage procedure. Can you show bbgs_cc_log?
      singulars
      1. POCurrent transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
      1. USsqlint
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload