Harvest Admin account locked

Products

• CA Harvest Software Change Manager

Issue/Introduction

The harvest admin account has been locked.

Tried executing the script HUsrUnlk.sql, but did not help. How can the account be unlocked?

Environment

CA Harvest Software Change Manager 13.0.3 and higher

Resolution

The following update sentence can be used to update the record on the database:

update haruserdata set failures = 0 where usrobjid = 1;

commit;

Additional Information

Note:

1. this query will unlock your account only...it does not reset your password.

2. this query applies to both Oracle and SQL databases.