SAP Knowledge Base Article - Preview

3690098 - monOpenDatabases.LastBackupFailed is set 1 for master database even dump database success - SAP ASE

Symptom

The LastBackupFailed field of monOpenDatabases for master database is set to 1 even you performed dump database master successfully.

1> select * from master..monOpenDatabases where DBID=1
2> go
 DBID        InstanceID BackupInProgress LastBackupFailed TransactionLogFull SuspendedProcesses AppendLogRequests AppendLogWaits PRSUpdateCount PRSSelectCount PRSRewriteCount DBName                         BackupStartTime                 LastCheckpointTime              LastTranLogDumpTime             QuiesceTag                     BackupEndTime                   LastTranLogEndDumpTime
 ----------- ---------- ---------------- ---------------- ------------------ ------------------ ----------------- -------------- -------------- -------------- --------------- ------------------------------ ------------------------------- ------------------------------- ------------------------------- ------------------------------ ------------------------------- -------------------------------
           1          0                0                1                  0                  0             73757              0              0              0               0 master                                                    NULL             Dec  2 2025  2:32AM                            NULL NULL                                                      NULL                            NULL

(1 row affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.1

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.1

Keywords

LastBackupFailed, monOpenDatabases, master, dump , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.