SYBASE: sap_materialize

[former_member248810]

Hi Guys,

We did a switchover to standby and SAP was able to connect to the standby server.

One of the follow-up steps is to do run sap_materialize and it ends with an error.

ConfigureConnection Failing Exception Message: 'Failed to alter connection 'AS1_Site1.AS1' to set 'hide_maintuser_pwd' on as validation of authentication method for the connection failed. Please make sure the maintenance user login of the connection is valid and the data server authentication method is set to 'ASE'.' Cause: ''.

Has anyone come across this error before?

Regards,

Ankit

[former_member248810]

The issue was resolved upon running the below command on standby

sapasedb /sybase/AS1% isql -UDR_admin -Ssapasedb:4905 -w1000 -PChangeme12

1> configure replication server

2> set hide_maintuser_pwd to 'on'

3> go

Config parameter 'hide_maintuser_pwd' is modified.

1> exit

Fault manager reports healthy status now:

sapase:as1adm 59> ./sybdbfm.sapAS1_ASCS01 status pf=/sapmnt/AS1/profile/SYBHA.PFL

fault manager running, pid = 21686, fault manager overall status = OK, currently executing in mode PAUSING

*** sanity check report (36)***.

node 1: server sapasedb, site Site1.

db host status: OK.

db status OK hadr status STANDBY.

node 2: server sapasedb1, site Site2.

db host status: OK.

db status OK hadr status PRIMARY.

replication status: SYNC_OK.

failover prerequisites fulfilled: YES.

Regards,

Ankit

[katrinhelm]

Hello Ankit,

just for the understanding: you did a "normal" failover from primary to standby host?

And you want to re-setup now the replication due to any reason? Normally there is no re-materializing needed after a failover, that's why I'm asking here.

Thanks and best regards,
Katrin

[former_member248810]

Thank you Katrin for responding!!

I did an unplanned failover using the below command:

sap_failover Site1,Site2,10,unplanned

sap_status path shows as below:

Site2.Site1.AS1 State Defined Path is defined and ready for materialization.

Regards,

Ankit