SAP Knowledge Base Article - Preview

2773865 - Materialization of master fails with singal 11 on primary ASE server - SAP ASE and SRS

Symptom

Running the following command to materialize master database fails as below

1> sap_materialize auto,<Site1_name>, <Site2_name>, master
2> go

1> sap_status task
2> go
TASKNAME TYPE VALUE
---------------------------- ----------------------------- -----------------------------------------------------------------------------------------------------------------------------------
Status Start Time <time>
Status Elapsed Time 00:00:03
Materialize Task Name Materialize
Materialize Task State Error
Materialize Short Description Materialize database
Materialize Long Description Starting materialization of the master database from source 'Site1_name' to target 'Site2_name'.
Materialize Task Start <time>
Materialize Task End <time>
Materialize Hostname ***
PerformMasterMaterialization Task Name Materialize the Master database
PerformMasterMaterialization Task State Error
PerformMasterMaterialization Short Description Materializes the Master database by using a bulk copy utility to copy necessary tables.
PerformMasterMaterialization Long Description !PerformMasterMaterialization.FIXUP_PREPARE_STAGE_PRIMARY!
PerformMasterMaterialization Failing Command sp_rep_masterdbsetup 'extract primary data'
PerformMasterMaterialization Failing Command Return Code 0
PerformMasterMaterialization Failing Command Error Message !FAILED_FIXUP_PREPARE_STAGE_WITHSQLCODE!
PerformMasterMaterialization Failing Exception Message: 'JZ0SG: A CallableStatement did not return as many output parameters as the application had registered for it.' Cause: ''.
PerformMasterMaterialization Current Task Number 1
PerformMasterMaterialization Total Number of Tasks 14
PerformMasterMaterialization Hostname ***

(20 rows affected)


There is following signal 11 with stack trace in primary ASE errorlog,

**********************************************************************************

** HADR operation: sap_materialize auto, Site1_name, Site2_name, master,

** Message: is starting

**********************************************************************************

Current process (0x534f0425) infected with signal 11 (SIGSEGV)

Address 0x0x0000000001ccb8a3 (result+0x573), siginfo (code, address) = (1, 0x0x0000000000000019)

......


************************************
SQL causing error : sp_rep_masterdbsetup 'extract primary data'
Current Procedure: sp_aux_repmasterdbcapture
Current statement number: 1 Current line number: 41
************************************
SQL Text: sp_rep_masterdbsetup 'extract primary data'

With following routines,

result

pre_aggview

s_preprocess

s_compile

hdl_stack

s_handle


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL06 HF1

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sap_materialize, master, CR 818877, signal 11, result , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.