-8047: Password required 

Explanation:

You tried to use a SET statement to activate a role which requires you to specify a password.

User Action:

Repeat the SQL statement, specifying the password this time.