Requests are not shown after upgrade

Products

• CA API Developer Portal

Issue/Introduction

Post developer portal upgrade from version 5.0.2.6 to version 5.2.1, unable to see the requests. Receive the following error:

{
    "timestamp": 1701724640567,
    "status": 500,
    "error": "Internal Server Error",
    "message": "Unable to find com.layer7.portal.application.dataaccess.entity.ApplicationEntity with id com.layer7.portal.datalayer.CompositeKey@e032f49e",
    "path": "/portal-data/api-management/1.0/requests"
}

The request is:

GET https://example.com/api/developers/api-management/1.0/requests?page=0&requestStatus=PENDING&size=10

Environment

API Developer Portal 5.2.1

Cause

This may be due to the missing application for certain pending requests.

Resolution

Run this select query to GET the UUID.

select * from REQUEST where tenant_id='developers' and request_type = 'APPLICATION' and REQUEST_STATUS = 'PENDING' and entity_uuid not in (select uuid from APPLICATION where tenant_id = 'developers');

*************************** 1. row ***************************
             UUID: c33f35f4-c34b-4659-a7c8-c5d7f70e38b3
     REQUEST_TYPE: APPLICATION
      ENTITY_UUID: 4815d433-edd2-4d51-b51c-c41d9d9f8aa6
ORGANIZATION_UUID: 93700da6-b59f-45f6-8599-fd7962873012
        CREATE_TS: 1692363224520
        MODIFY_TS: 1692363224520
       CREATED_BY: fundacelik
      MODIFIED_BY: fundacelik
   REQUEST_STATUS: PENDING
           REASON: NULL
        USER_UUID: c0d6d250-9868-4f4e-b204-f51daf731565

Now, run UPDATE query.

UPDATE `REQUEST` SET `REQUEST_STATUS` = 'REJECTED' WHERE (`TENANT_ID` = 'developers') and (`UUID` = 'c33f35f4-c34b-4659-a7c8-c5d7f70e38b3');

 

Additional Information

Based on the GET request url that you pasted in the defect, I assume "developers" in the tenant id. if not, replace the tenant id in the query with whatever tenant id they are using.