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 ONE Support launchpad (Login required).

Search for additional results

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