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 for Me (Login required).

Search for additional results

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