Intermittent 504 timeout error

Products

• CA API Developer Portal

Issue/Introduction

When browsing the portal pages, the 504 request failed error message shows up even when there was no change requested on the page.

Environment

API Portal 5.2.1

Cause

API_VIEW table on the portal DB taking more than 60 seconds to return the results

Resolution

Run the following SQL query against the API_VIEW table on the portal DB and see how long it takes.

• SELECT * FROM API_VIEW WHERE UUID = '<API_UUID>';
• Use the API UUID if you see the error on the portal for this API
• If not use any API UUID

If it takes more than 60 seconds then run this SQL query to optimize this table.

CREATE OR REPLACE VIEW API_VIEW AS SELECT
  `API`.`TENANT_ID` AS `TENANT_ID`,
  `API`.`UUID` AS `UUID`,
  `API`.`NAME` AS `NAME`,
  `API`.`DESCRIPTION` AS `DESCRIPTION`,
  `API`.`PRIVATE_DESCRIPTION` AS `PRIVATE_DESCRIPTION`,
  `API`.`PORTAL_STATUS` AS `PORTAL_STATUS`,
  `API`.`ACCESS_STATUS` AS `ACCESS_STATUS`,
  `API`.`PUBLISHED_BY_PORTAL` AS `PUBLISHED_BY_PORTAL`,
  `API`.`API_EULA_UUID` AS `API_EULA_UUID`,
  `API`.`VERSION` AS `VERSION`,
  `API`.`SSG_SERVICE_TYPE` AS `SSG_SERVICE_TYPE`,
  `API`.`SSG_URL` AS `SSG_URL`,
  `API`.`POLICY_TEMPLATE_UUID` AS `POLICY_TEMPLATE_UUID`,
  `API`.`SPEC_FILENAME` AS `SPEC_FILENAME`,
  `API`.`SPEC_FILESIZE` AS `SPEC_FILESIZE`,
  `API`.`TRANSACTION_PHASE` AS `TRANSACTION_PHASE`,
  `API`.`CREATE_TS` AS `CREATE_TS`,
  `API`.`MODIFY_TS` AS `MODIFY_TS`,
  `API`.`CREATED_BY` AS `CREATED_BY`,
  `API`.`MODIFIED_BY` AS `MODIFIED_BY`,
  `API`.`PUBLISHED_TS` AS `PUBLISHED_TS`,
  `API`.`ORG_UUID` AS `ORG_UUID`,
  `API`.`POLICY_BUNDLE_UUID` AS `POLICY_BUNDLE_UUID`,
  `API`.`TYPE` AS `TYPE`,
  0 AS `APPLICATION_USAGE`,
  0 AS `ORGANIZATION_USAGE`,
  0 AS `ENTITIES_COUNT`,
  `API`.`NAME` AS `SSG_NAME`,
  `API`.`API_LOCATION_URL` AS `API_LOCATION_URL`,
  `API`.`AUTHENTICATION_TYPE` AS `AUTHENTICATION_TYPE`,
  `API`.`AUTHENTICATION_PARAMETERS` AS `AUTHENTICATION_PARAMETERS`,
  0 AS `PENDING`,
  0 AS `SERVICE_DISRUPTION`,
  0 AS `IN_SYNC`,
  `API_ORGANIZATIONS_VIEW`.`ORGANIZATIONS` AS `ORGANIZATIONS`
FROM (`API` left join `API_ORGANIZATIONS_VIEW` on(((`API`.`TENANT_ID` = `API_ORGANIZATIONS_VIEW`.`TENANT_ID`) and (`API`.`UUID` = `API_ORGANIZATIONS_VIEW`.`UUID`))));

Additional Information

 DE588482: This should be fixed in 5.3