SAP Knowledge Base Article - Preview

3323176 - primary ASE indicate Standby Mode and report error 968 - SRS

Symptom

After restarting the database, primary ASE indicate Standby Mode and cannot logon to force it to Primary.

cannot logon through isql using users "sa", "sapsa", "DR_admin" or "sapsso" with message:

Login failed. Adaptive Server is running in 'Standby' mode. You do not have the
necessary role or privilege to login while the server is running in this mode
and login redirection cannot occur since there is no Active Primary.

 

From ASE errorlog:

background task error 968: Database 'database 'master' (1)' is not upgraded and hence is not available for access. Please retry your query after database has been upgraded.
background task error 4001: Cannot open default database 'master'.
background task error 968: Database 'database 'master' (1)' is not upgraded and hence is not available for access. Please retry your query after database has been upgraded.
background task error 4002: Login failed.
remote HADR server XXXXXX is UNREACHABLE
local server is now Standby


Read more...

Environment

Adaptive Server Enterprise/16.0 SP04 PL01 HF2/EBF 30225 SMP/P/AMD64/Windows 2012 R2/ase160sp04pl01x/0/64-bit/FBO/Thu Feb 10 01:08:49 2022

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.