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
API Developer Portal 5.2.1
This may be due to the missing application for certain pending requests.
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');
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.