API Gateway: How to remove read-only flag for an OTK policy

Products

• CA API Gateway

Issue/Introduction

Customer upgrade from otk 3.6 to otk 4.X, they have customization on 'OTK Client Authentication' which is read-only on otk 4.X.
Customer needs to remove the read-only flag on the policy to re-do the customization

Environment

Release:
Component: APIGTW

Resolution

1. login mysql database 
mysql ssg 

2. get the id of the policy 
select lower(hex(goid)) from policy where name = 'OTK Client Authentication'; 

For example, it returns id as 'e001cfd0c1c1ffaa18e187b5e72fd90a'. 

3. update the read-only flag to 0 
update solution_kit_meta set read_only=0 where entity_id = 'e001cfd0c1c1ffaa18e187b5e72fd90a'; 

4. restart gateway 
service ssg restart 

5. login policy manager to modify the policy. 

6. if  want to revert back the read-only flag, set it as 1 and restart gateway to take effect. 

Additional Information

NOTE when the OTK is upgrade the changes made will be overwritten