CA API Gateway OTK Soloution Kit fails to upgrade to 4.5.1 getting conflict and solution kit does not allow overriding this mapping.

Products

• CA API Gateway

Issue/Introduction

When trying to upgrade the CA OTK Oauth Solution Kit we are getting a lot of Conflicts or unresolved entities.

and receiving this error:

"This Solution Kit does not allow overriding of this mapping.

  This mapping requires the property “SK_AllowMappingOverride” be set to true by the .skar file author."

Environment

Upgrading from Oauth OTK from 4.3 version to 4.5.1

Resolution

Reviewing the ssg_* log we can see errors like,

<l7:Mapping action="Ignore" actionTaken="Ignored" srcId="SomeID" targetId="SomeID" type="SERVICE"/>
2024-01-15T09:56:03.333+0000 ERROR   43 org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Cannot delete or update a parent row: a foreign key constraint fails (`ssg`.`policy`, CONSTRAINT `policy_folder` FOREIGN KEY (`folder_goid`) REFERENCES `folder` (`goid`))
2024-01-15T09:56:03.333+0000 WARN    43 org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 1451, SQLState: 23000
2024-01-15T09:56:03.311+0000 ERROR   43 

What you can note from these errors is that after a service entry a Database error occurred on folder_goid. The folder_goid/name can be determined by hitting the local restman service

https://somehost:8443/restman/1.0/policies 

You can also query policies with /policies?key=value

Valid Keys are,

name, guid, type, soap, parentFolder.id, securityZone.id, sort, order

Once you determine the parent_folder you can enter that in restman OR policy manager. And there should be a foreign entity that needs removal or deletion. In this instance we had to remove old out of box policies,

OTK Authenticate Oauth 1.0 Parameter

OTK OAuth 1.0 Context Variables

OTK Require Oauth 1.0 Token

After removing these 3 entities no unexpected solution kit mapping errors.