SAP Knowledge Base Article - Preview

2191530 - 'Your query is blocked because it tried to start a transaction in the XXX database which is in a quiesced state' - SAP ASE

Symptom

  • When executing updates in a database, a session was hung.
  • ASE returned the following message:

    Your query is blocked because it tried to start a transaction in the XXX database which is in a quiesced state. Your query will proceed after the DBA performs a QUIESCE/PREPARE DATABASE RELEASE.
  • Error which may be seen in the ASE errorlog:

    QUIESCE DATABASE command with tag tag_XXX is being executed by process 4294969191.
    Process 1895 successfully executed QUIESCE DATABASE with HOLD option for tag tag_XXX.
    Processes trying to issue an I/O operation on the quiesced database(s) will be suspended until the user executes a QUIESCE DATABASE command with the RELEASE option.
    Your query is blocked because it tried to write and database 'XXX' is in a quiesced state. Your query will proceed after the DBA performs QUIESCE/PREPARE DATABASE RELEASE.
    QUIESCE DATABASE command with tag mytag is being executed by process 779.
    Error: 2233, Severity: 16, State: 1
    QUIESCE DATABASE Error: Database XXX is already quiesced or it is currently being quiesced by another process.

  • 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 all versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

hanging, QUIESCE, PREPARE, AGENT, "QUIESCE PREPARE AGENT", tag , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.