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
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.
SAP Knowledge Base Article - Preview