Cannot change password for user 1

[BobT56]

Using Livelink V9.7.0
For a single user only, user cannot change the password. The user can log on, but cannot change password. Livelink admin cannot change password either. This is new behavior, until a month ago, this worked for user.

Error when user or LL admin tries changing password:
---> Error Stack
---> 1) E675414018:Oracle reported error.:ORA-00001: unique constraint (LIVELINK.OLDPASSWORDS_PRIMARY) violated.
---> 2) E675086352:Could not execute cursor.:
---> 3) E675086344:Error executing an Sql statement.

Any ideas?
Bob

 

[jjlang]

You have your server configured so that new passwords must be different from the old passwords. The user is trying to use a password that they used before.

Either change the system setting that requires new passwords, or change the length of time that the list of old passwords are kept, or use a new password.

 

[BobT56]

This sounded like the right answer, but was not. This user cannot change his password to anything. The same error message is generated.

Is there a setting that monitors how often a password is changed? Or how many times? In the past, this user changed his password often. Do I need to flush all the old passwords from the database? If so, how?

Thanks,
Bob

 

[jjlang]

You could do a

delete from OldPasswords where UserID=XXXX

where XXXX is the userID for the user having the problems. See if that corrects the problem. If not, you will need to check the SQL logs for more errors.

 

[BobT56]

Deleting the user's entry from the OldPassword did it!

Thanks jjlang!

 

[otovb]

Fetch the Category information of a document

Hi all,
I am writing a java program for creating a category and attributes and finally associating this category with a document that is also being created through this code. Now once this document gets created,i want to fetch the category that i assigned to it. But i am unable to do so. kindly suggest some solution. Any code snippet will be appreciated.
thnks
otovb