value for adhoc attribute is updated via OIS and is correct in comanage database:

select * from cm_ad_hoc_attributes where co_person_role_id in ('176666','176664','663708')

but if I run the following query against the SQL Provisioner database, it still shows the old value for 2 out of 3 of the roles alongside the new values.

select * from sp_ad_hoc_attributes where co_person_role_id in ('176666','176664','663708')

So from the UI and comanage database perspective, it is correct, but the SQL Provisioned database is incorrect and the old values are not being deleted.