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 ONE Support launchpad (Login required).

Search for additional results

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