SAP Knowledge Base Article - Preview

1983761 - Error 9275 "Could not locate the before image for the INSERT log record..." hit by RepAgent in ASE - SRS

Symptom

  • SAP Adaptive Server Enterprise (ASE) Replication Agent (RepAgent) is processing the log records of a MERGE command leading to multiple operations (deletes, updates and inserts).
     
  • RepAgent fails with Error 9275:

Error: 9275, Severity: 20, State: 1
RepAgent (4): Could not locate the before image for the INSERT log record at (120847,14).
Shutting down Rep Agent for database, 'PDB' (dbid = 4).

  • When RepAgent restarts, it fails with the same error again:

Started Rep Agent on database, 'PDB' (dbid = 4)
Error: 9275, Severity: 20, State: 1
RepAgent (4): Could not locate the before image for the INSERT log record at (120847,14).
Rep Agent Thread for database 'PDB' (dbid = 4) terminated abnormally with error. (major 92, minor 75)

  • When running under the ASE diagserver binary, additional assertion failures are seen:

Assertion (rxact->raxct_flags & RAXCT_UPD_IMG_VALID) failed in file  /remote/pajaro_bld1/asecepheus/SMP/porttree/svr/sql/generic/source/repl/ra_scan.c line 11968
Assertion (!xlm_isemptymarker(&rxact->raxct_upd_img_xlm)) failed in file /remote/pajaro_bld1/asecepheus/SMP/porttree/svr/sql/generic/source/repl/ra_scan.c line 11969
Assertion (rxact->raxact_upd_cnt > 0) failed in file /remote/pajaro_bld1/asecepheus/SMP/porttree/svr/sql/generic/source/repl/ra_scan.c line 11970


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) versions 15.7 and 16.0
  • SAP Replication Server (SRS)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server all versions

Keywords

CR757531, 757531,  traceflag, tarce, flag, 9211, "DBCC LOG", xstat, xstat2 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.