Update DB Static role rotation logic to generate new password if retried password fails

Update DB Static role rotation logic to generate new password if retried password fails #49687