You may need to finish the quest with Peavey and Quincy. Then Rodney should sit at his desk for the remainder of his time.

My Divinity II: Ego Draconis FAQ/Guide
My Divinity II: The Dragon Knight Saga FAQ/Guide