SAP Knowledge Base Article - Preview

3288780 - Materialization failing with Error: " Message from server: Message: 924, State 1, Severity 14 -- 'Database '<database>' is already open and can only have one user at a time. " - SRS

Symptom

  • HADR materialization is failing.
     
  • Standby Rep server log:


    ...
        CI memory threshold was changed from 958503315 to 1119564585, global pool capacity from 731 to 853, global pool init size from 365 to 426.
    I. 2022/01/20 14:18:04. User 'DR_admin' writes: '*******************************************************************************'
    I. 2022/01/20 14:18:04. User 'DR_admin' writes: '** HADR operation: sap_materialize auto, HOST1, HOST2, <database>,'
    I. 2022/01/20 14:18:04. User 'DR_admin' writes: '** Message: is starting'
    I. 2022/01/20 14:18:04. User 'DR_admin' writes: '*******************************************************************************'
    ...
    I. 2022/01/20 14:18:53. User 'DR_admin' writes: '*******************************************************************************'
    I. 2022/01/20 14:18:53. User 'DR_admin' writes: '** HADR operation: sap_materialize auto, HOST1, HOST2, <database>,'
    I. 2022/01/20 14:18:53. User 'DR_admin' writes: '** Message: failed'
    I. 2022/01/20 14:18:53. User 'DR_admin' writes: '*******************************************************************************'
    ...
    E. 2022/01/20 14:21:23. ERROR #1028 DSI EXEC(193(3) XXX_HOST2.<database>) - /generic/useful/cm.c(5376)
        Message from server: Message: 924, State 1, Severity 14 -- 'Database '<database>' is already open and can only have one user at a time.
    '.
    E. 2022/01/20 14:21:23. ERROR #13045 DSI EXEC(193(3) XXX_HOST2.<database>) - /generic/useful/cm.c(5380)
        Failed to connect to server 'XXX_HOST2' as user 'DR_maint'. See CT-Lib and/or server error messages for more information.
    ....

    • Standby RMA log:


    ...
    2022-01-20 14:18:30 [ERROR] [Thread-40570:42588][RMA] - [GetPathStatus            ] - Message: 'Database '<database>' is already open and can only have one user at a time.' Cause: ''.

    ...
       


    ' is already open and can only have one user at a time. " - SRS"> Read more...

    Environment

    • SAP Replication Server (SRS) 16.0 SP03 PL12
    • SAP Replication Server (SRS) 16.0 SP04 PL02

    Product

    SAP Adaptive Server Enterprise all versions ; SAP Replication Server 16.0

    Keywords

    CR827532, CR827532, CR827532, sybase, Error 924 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Known Error

    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.