WSO2 APIM 3.2.0 | Unable to load APIs in developer portal

-

Hello guys, I'll be sharing my another experience in WSO2 API Manager for one of the use cases I faced issue.

Environment: WSO2 APIM 3.2.0, RHEL8.x

Problem: The developer portal is unable to load the list of APIs as default. Although, it can load the APIs if I filter out the APIs via tag. Below is the screenshot of the same-
Further I tried to investigate wso2carbon logs to see the error/exception and I found below relevant logs for the same-
================================================================================
ERROR - ApisApiServiceImpl Error while retrieving API : 07b6c6a7-eaa6-42be-a687-e04dd40a1ee6
org.wso2.carbon.apimgt.api.APIManagementException: Unable to find the API: admin-test001-1.0.0 in the database
at org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.getAPIID_aroundBody310(ApiMgtDAO.java:7148) ~[org.wso2.carbon.apimgt.impl_6.7.206.168.jar:?]
at org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.getAPIID(ApiMgtDAO.java:7117) ~[org.wso2.carbon.apimgt.impl_6.7.206.168.jar:?]
at org.wso2.carbon.apimgt.impl.utils.APIUtil.getAPIForPublishing_aroundBody10(APIUtil.java:652) ~[org.wso2.carbon.apimgt.impl_6.7.206.168.jar:?]
at org.wso2.carbon.apimgt.impl.utils.APIUtil.getAPIForPublishing(APIUtil.java:643) ~[org.wso2.carbon.apimgt.impl_6.7.206.168.jar:?]
================================================================================

Going forward, I checked the API test001 in publisher portal. The api was listed in the APIs but when I clicked on the same to see the details, it just keeps loading the screen and nothing happened as shown below-


Cause: The API test001 v1.0.0 has been somehow partially deleted or corrupted that caused partial search in developer portal and failed with exception "Unable to find the API: admin-test001-1.0.0 in the database" and the same way API details wasn't available in the publisher portal.

Solution: We need to remove all the metadata of the API and it needs to be created again. Follow the steps below to delete the metadata of the api test001.
  1. Login to the carbon console
  2. Navigate to Metadata section from left navigation panel and click on APIs. 
  3. This will show the list of all APIs. Carefully see the api test001 and delete the same with confirmation popup. 
  4. Now the API metadata has been successfully been deleted. Verify the same again in the APIs list here.
  5. Open the developer portal, it should now load all the APIs
Caution: Deleting the API metadata will delete all the details of the API. If required, please download the metadata from carbon console > metadata > apis > test001 > download



Comments

  1. Get It SMSJuly 8, 2022 at 10:17 AM

    Great post. I was checking continuously this blog and I am impressed! Very useful info specifically the last part :) I care for such info much. I was looking for this certain information for a very long time. Thank you and best of luck

    Are you looking for WhatsApp API Service Provider? Do you want to raise your customer’s support for your brand? Do you want your company to lead in the market of India? Do you need your business to grow faster and lead the position of your business in the market of India by using WhatsApp API Service Provider? then you are in the right place. Start today with India’s most trusted WhatsApp Business API Service Provider that provides you with great deals, better services, and opportunities that your business is seeking, to be successful.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle SOA Suite- Implementing Email Notification

-
Image
In this post, I am going to show how to implement email notifications in Oracle SOA Suite using BPEL process. So let's get started- Implementing email notification in Oracle SOA Suite consists of below steps: Environment- IDE- Oracle jDeveloper 11g Weblogic Server 12c Oracle SOA Suite 12c High Level Steps Keep ready email server settings. Configure & enable usermessagingdriver-email for target SOA servers via console. Setting up Email driver (usermessagingdriver-email )with email server settings via enterprise manager. Enable notifications for SOA workflows(make sure either All or EMail option is selected).. Create SOA composite application Deploy it on SOA server. Testing & done. 1. Keep ready email server settings. Keep ready your below email server settings: Outgoing Mail Server          : smtp.domain.com Outgoing Mail Server Port   : xxx Default From Address         : username@doamin.com Outgoing Username            : actualemailid@doma
Read more

Oracle SOA Suite 12c- PKIX path building failed & unable to find valid certification path to requested target

-
Image
Hi Everyone, in this blog I'll be writing one of the strange issue that has been encountered while working with a Oracle SOA composite running in Oracle IDAM environment and trying to invoke a SSL based remote service where SSL certification based exception has been thrown during the service invocation. Environment Oracle SOA Suite 12c  (HA Mode) Oracle IDAM 12c (HA Mode) Oracle Linux 7 External Web Service (SOAP Service) Problem Below is the exception thrown when trying to invoke an external webservice (SSL Based) via BPEL process- <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Unable to invoke endpoint URI "https://idam.uppclonline.com/soa-infra/services/default/DefaultOperationalApproval!5.12*soa_69e4734b-d8fe-4edf-b44e-e287f61c2ddf/SMSNotification%23ApprovalProcess/SMSNotification" succe
Read more

Migration of Oracle SOA Suite Composite from 11g to 12c

-
Image
Recently I have came across a scenario where I have a business requirement of  migration of Oracle SOA Suite 11g(11.1.1.7.0) to 12c(12.1.3.0). Below are the different mechanisms I have tried to do, few of them failed and one succeeded. Working in Oracle SOA Suite 11g is completely different from 12c. In 11g, we need to install the jDeveloper(11.1.1.7) then SOA extension separately to be installed either via offline file  (download available at  https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/156082.xml ) or through jDeveloper top menu >>  Help >> Check for Updates >> SOA Extension.  While working with 12c doesn't involves such tedious job. Only single installer is required for jDeveloper/SOA/Weblogic and is available as QuickStart Installer(download available at https://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html). Approach 1- Compress(Zip) SOA composite code of 11g version (11.1.1.7.0) and unzip to a differe
Read more