Access problem after migrating OpenIAM

Problem:

You have just migrated the pre-production environment of a client from version 3.6.1 to version 4.2.1.2, it went well, but when entering the administration console, you create the content provider and when going to redirect, the message appears: Challenge response questions feature has been disabled by your administrator.

Solution:

1. Enable security questions via DB, answer them and login after.

2. Make sure that in DB you have:

select * from POLICY_DEF_PARAM where NAME in('CUSTOM_QUEST_COUNT','QUEST_COUNT');
select * from POLICY_ATTRIBUTE where DEF_PARAM_ID in (select DEF_PARAM_ID from POLICY_DEF_PARAM where NAME in('CUSTOM_QUEST_COUNT','QUEST_COUNT'));

1. If there is no result, update the SQL command.
2. Restart ESB after table updating.

5. Required column value must be 'Yes' (Y).