Replication User pass

[Former Member]

Hello,

I´ve Replication user that it was created during slt connection but is locked each time.

Where can I change this password? During configuration of SLT via LTR tcode I can see the administration user and after this configuration is made the Connection_name is used to create the user name and schema.

[Former Member · Accepted solution]

I´ve followed the next steps:

1-ALTER USER <user> DEACTIVATE USER NOW

2-ALTER USER <user> PASSWORD <password>

3-ALTER USER <user> DISABLE PASSWORD LIFETIME

4-ALTER USER <user> RESET CONNECT ATTEMTPS

5-Activate the user again via Hana Studio

After that I've updated the password of user on DBCO and after that I get this:

Could not open connection HA1_ECCACC_PPDCLNT500          .

sql error        416  occured:

user is locked; try again later: lock time is 1 minutes; user is locked until 2014-04-28 09:17:47.3380000 (given in UTC) [1,2014-04-28 09:17:47.3380000]

The problem is solved changing the DBCO on both sides.

[Former Member · Accepted solution]

Ruben,

The problem is solved changing the DBCO on both sides.--What do you mean by both sides?

You have changed the password of DBCO in SLT..Rt?What do you mean by both sides then?

[Former Member · Accepted solution]

ERP and SLT sides.

[Former Member · Accepted solution]

Why there should be a DBCO in ECC side??ECC should be speaking to SLT through RFC..Rt?

Is your ERP & SLT Databases are different?

[Former Member]

Hi Ruben,

You can follow the below steps:

Step1- Change the password of this user in HANA through HANA Studio

Step2: Then change the password of this user in tcode -DBCO.We need to change it here as it is the secondary database connection by which SLT is connected to HANA.

[Former Member]

Hello Joydeep,

Yes, these are the steps that I'm following, but the user is getting locked...

The user used appears on HANA studio like as Deactivated

I´ve followed the next steps:

1-ALTER USER <user> DEACTIVATE USER NOW

2-ALTER USER <user> PASSWORD <password>

3-ALTER USER <user> DISABLE PASSWORD LIFETIME

4-ALTER USER <user> RESET CONNECT ATTEMTPS

5-Activate the user again via Hana Studio

After that I've updated the password of user on DBCO and after that I get this:

Could not open connection HA1_ECCACC_PPDCLNT500          .

sql error        416  occured:

user is locked; try again later: lock time is 1 minutes; user is locked until 2014-04-28 09:17:47.3380000 (given in UTC) [1,2014-04-28 09:17:47.3380000]