Migration from legacy Portal failing callback_url is not migrated

Products

• CA API Developer Portal

Issue/Introduction

We are having issue with the  portal data migration. and the callback_url is not migrated from portal 3.5 cr19 to portal 5.02.x using the 3.5 migration tool.

Environment

Release : 5.0.2

Component :

Resolution

We created a workaround to migrate the missing callback url from the 3.5 mysql database after the initial migration .

see the procedure below

--

From Classic Portal’s database server to generate and export applications UUIDs and Callback URLs into a SQL file:

mysql> CREATE TABLE temptable AS SELECT uuid, oAuthCallbackUrl FROM lrsapplication;

mysqldump lrs temptable > temp.sql;

mysql> DROP TABLE temptable;

 

Transfer the SQL file into the Target Portal's database server

Import into the table portal.APPLICATION_API_KEY

mysql -u admin -p portal < temp.sql

mysql> ALTER TABLE temptable CONVERT TO character set utf8mb4 collate utf8mb4_0900_ai_ci;

mysql> UPDATE APPLICATION_API_KEY t2, temptable t1 SET t2.OAUTH_CALLBACK_URL = t1.oAuthCallbackUrl WHERE t2.APPLICATION_UUID = t1.uuid;

mysql> DROP TABLE temptable;

 

Call following endpoint to trigger a bulk application deployment on a specific proxy:

POST ${tenantUrl}/api/${tenantId}/deployments/internal/proxies/${proxyUuid}/api-keys?forceDeploy=true