Upgrade of OTK 4.5 failed

Products

• CA API Gateway

Issue/Introduction

Attempted to upgrade the OTK in our sandbox environment from 4.4 to 4.5 but it failed on a JDBC connection. I removed the connection and attempted to upgrade again but it failed the second time. Below is the initial JDBC error. Please provide next steps.

2022-03-22T15:46:37.729-0500 WARNING 42 com.l7tech.external.assertions.gatewaymanagement.server.ServerRESTGatewayManagementAssertion: 9050: Error processing management request: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
2022-03-22T15:46:37.830-0500 WARNING 42 com.l7tech.server.solutionkit.SolutionKitManagerImpl: Unable to install bundles due to mapping errors:
                <l7:Mapping action="NewOrExisting" errorType="InvalidResource" srcId="4432207d16a1b505e8a6ed59993eaa24" targetId="c1c0ce581a0c4babe1503594dfa08801" type="JDBC_CONNECTION">
                        <l7:Property key="ErrorMessage">
                <l7:Mapping action="NewOrExisting" errorType="InvalidResource" srcId="4432207d16a1b505e8a6ed59993eaa24" targetId="c1c0ce581a0c4babe1503594dfa08801" type="JDBC_CONNECTION">
                        <l7:Property key="ErrorMessage">

Environment

Release : 10.1

Component : API GATEWAY

Cause

JDBC connection was named otkdb this was the reason for the failure 

Based on documentation the name must be OAuth 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-management-oauth-toolkit/4-5/installation-workflow/create-database-connections.html

 

Resolution

Renaming the JDBC connections to OAuth allowed the upgrade to be successful