Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

[Warm-Standby] master replication problem

Hi.

I established warm standby replication for master database:

Replicating the master database in a warm standby environment for ASE

For most actions like: adding login (or db user), role grants it works fine.

There is one problem which I cannot resolve.

On my Active site I have configured  a password policy (each login MUST change password after first logon) - it is expired by default.

On my Standby site I have identical master..syslogins table (so all logins are also expired by default).

When someone changes his password on ACTIVE site, DSI thread goes down:

E. 2015/09/10 11:29:21. ERROR #13045 DSI EXEC(125(1) clininet_standby.master) - seful\cm.c(3784)

        Failed to connect to server 'clininet_standby' as user 'test'. See CT-Lib and/or server error messages for more information.

I. 2015/09/10 11:29:21. Message from server: Message: 4022, State 1, Severity 10 -- 'The password has expired, but you are still allowed to log in. You must change your password before you can continue. If a login trigger is set, it will not be executed.

'.

I. 2015/09/10 11:29:21. Message from server: Message: 5701, State 2, Severity 10 -- 'Changed database context to 'master'.

'.

E. 2015/09/10 11:29:21. ERROR #1028 DSI EXEC(125(1) clininet_standby.master) - seful\cm.c(3784)

        Message from server: Message: 7742, State 3, Severity 16 -- 'You must change your password using the sp_password system stored procedure before you can continue.

DSI is shutdown becouse of Message: 4022.

I tried to resolve this by:

1. Adding custom error class and binding it to my STANDBY connection

2. Assigning action WARN for errors.

Replication Server/15.6/EBF 20155 ESD#3/X64/Windows

Error still occurs.

Maybe someone knows how to solve this. Without proper password replication there is no point to replicate master database at all.

I would be grateful for any information.

Best regards.

--

Marcin

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question