ARERR[552] The SQL database operation failed

Version 2

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    Cloud Lifecycle Management


    BMC Cloud Lifecycle Management



    Environment: BMC Cloud Lifecycle Management 2.1


    When we try to open the Cloud My Services Console we get the error message "The SQL database operation failed. : The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) (ARERR 552) "

    We checked the database servers for itsm and cdb - they have enough disk space - so they are not out of space. We restarted the ARS mid-tier, itsm, cdb and both corresponding database servers and started them again.
    the issue is still the same.
    We also flushed the mid-tier cache - no change in the issue.




    Legacy ID:KA369652


    1: Check if transaction log for database 'ARSystem' is full.


    2: To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.

    3: Connect to the database and pull out the "sys.databases" table and get it check by DBA if it has an entry which says that the DB is full.

    4: Modify this value to get it reuse.


    Contact Support if issue still persists.

    Related Products:  
    1. BMC Cloud Lifecycle Management


    Article Number:


    Article Type:

    Solutions to a Product Problem

      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles