2621230 - online database fails for standby_access - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2621230 - online database fails for standby_access - SAP ASE

Symptom

  • Dump database <database_name> to "/<path>/<database>.dmp"
  • Load database <database_name> from "/<path>/<database>.dmp"
  • ONLINE DATABASE <database_name> for standby_access
    Started estimating recovery log boundaries for database '<database_name>'.
    Database '<database_name>', checkpoint=(19447, 100), first=(19447, 100), last=(19447, 102).
    Completed estimating recovery log boundaries for database '<database_name>'.
    Started ANALYSIS pass for database '<database_name>'.
    Completed ANALYSIS pass for database '<database_name>'.
  • Msg 12512, Level 16, State 1:
    Server 'SAP SYBASE', Line 1:
    Database '<database_name>' (dbid YY): has incomplete transactions. ONLINE DATABASE FOR STANDBY_ACCESS cannot be completed successfully.
  • Msg 12542, Level 16, State 1:
    Server 'SAP SYBASE', Line 1:
    Load the next transaction log in the load sequence, or use ONLINE DATABASE with no options to end the load sequence.
    ASE could not bring database '<database_name>' online.
  • Roll back transaction "$rep_xact_for_dumpdb' -- was aborted
  • There is no open transaction to begin with

Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

$rep_xact_for_dumpdb, sp_setreptable, sp_setrepproc, dbcc gettrunc , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

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