[APIM 4.2.0] Remove AM_API_URL_MAPPING THROTTLING_TIER NULL Update Query

[Hamool-Nizar]

Problem

Hi Team,

We are trying to deploy a multi-region APIM deployment with Postgresql datababase, but while performing database replication we noticed errors due to that during APIM start-up APIM is running update SQL queries on the AM_API_URL_MAPPING table therefore, is a way to remove or avoid this AM_API_URL_MAPPING update SQL queries during APIM start-up.

Solution

We need to eliminate the query and verify if the throttling tier is NULL in the codebase during all SELECT operations on AM_API_URL_MAPPING. We should handle the NULL value appropriately in the code (if NULL, set it to Unlimited or the value configured in tenant-conf).

Affected Component

APIM

Version

4.2.0

Implementation

No response

Related Issues

No response

Suggested Labels

No response

[hisanhunais]

Fixed via an update for APIM 4.2.0. Public fix done via wso2/carbon-apimgt#12527