SAP Knowledge Base Article - Preview

2498432 - Task Materialize the Master database - Failed performing command - sp_rep_masterdbsetup 'prepare': SRS

Symptom

The following error is reported in the DRagent log after ASE has been upgraded:

[TRACE] [Materialize] - Creating connection to pool: primary_host_4901_DR_admin_1f80e146df6ad5dc52e47e917c6729 (s/r/a/t/o) (103/0/0/0/0)

[TRACE] [Materialize] - Allocated connection: 1752798720(com.sybase.jdbc4.jdbc.SybConnection@74cb09c7) pool: primary_host_4901_DR_admin_1f80e146df6ad5dc52e47e917c6729 (s/r/a/t/o) (104/0/1/1/0)
[TRACE] [Materialize] - use tempdb
[TRACE] [Materialize] - sp_rep_masterdbsetup 'prepare'
[ERROR] [Materialize] - Task Materialize the Master database - Failed performing command - sp_rep_masterdbsetup 'prepare'
[WARN ] [Materialize] - Missing key 'FAILED_FIXUP_PREPARE_STAGE_WITHSQLCODE' in resource bundle file.
[ERROR] [Materialize] - Task Materialize the Master database - Failed with error message - !FAILED_FIXUP_PREPARE_STAGE_WITHSQLCODE!
[ERROR] [Materialize] - Task Materialize the Master database - Failed with Exception - SQL ERROR -- Message: 'Stored procedure 'sp_rep_masterdbsetup' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).' SQLState: 'ZZZZZ'  Remote Code: '2812' Cause: ''.
[TRACE] [Materialize] - Task Materialize the Master database - Failed with Stack Trace - Stored procedure 'sp_rep_masterdbsetup' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
com.sybase.jdbc4.jdbc.SybSQLException: Stored procedure 'sp_rep_masterdbsetup' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).


Read more...

Environment

  • SAP Replication Server (SRS) 15.7.1
  • SAP Adaptive Server Eneterprise (ASE) 15.7.1

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server 15.7

Keywords

Materialize sp_rep_masterdbsetup Master materialization hadr , 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.