Adams had reportedly been receiving end-of-life care for the past week, just over six months after he announced his prostate cancer had spread to his bones