Group Users cannot update the client credentials for the Applications after Applying the fix

[chethan1999]

Description

No response

Steps to Reproduce

Hi team,

When we test the provided solution we faced an issue and following are the steps to recreate the issue. Please check this and let us know what could cause this issue.

1. Create a role called "test" and add two users named "testuser1" and "testuser2" with required permission to use devportal.

2. Login as "testuser1" to the devporta and create an application

3. Provide keys for one of the third party key managers using the option "Provide Existing OAuth Keys"

4. Login as "testuser2" to the devportal and remove the keys on the above application by navigating to the related third party key manager.

5. Now try to provide new keys using "Provide Existing OAuth Keys" option inside the related third party key manager

6. Above step fails with following error in the carbon console.

[2025-01-17 10:34:09,184] ERROR - ApiMgtDAO Error while inserting record to the AM_APPLICATION_KEY_MAPPING table, error is = Referential integrity constraint violation: "CONSTRAINT_AFF: PUBLIC.AM_APPLICATION_KEY_MAPPING FOREIGN KEY(APPLICATION_ID) REFERENCES PUBLIC.AM_APPLICATION(APPLICATION_ID) (0)"; SQL statement:

INSERT INTO AM_APPLICATION_KEY_MAPPING (APPLICATION_ID,CONSUMER_KEY,KEY_TYPE,STATE,CREATE_MODE,KEY_MANAGER,UUID) VALUES (?,?,?,?,?,?,? [23506-210]

org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "CONSTRAINT_AFF: PUBLIC.AM_APPLICATION_KEY_MAPPING FOREIGN KEY(APPLICATION_ID) REFERENCES PUBLIC.AM_APPLICATION(APPLICATION_ID) (0)"; SQL statement:

INSERT INTO AM_APPLICATION_KEY_MAPPING (APPLICATION_ID,CONSUMER_KEY,KEY_TYPE,STATE,CREATE_MODE,KEY_MANAGER,UUID) VALUES (?,?,?,?,?,?,? [23506-210]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:527) ~[h2-engine_2.1.210.wso2v1.jar:?]

Regards,
Chethan

Version

wso2am-4.2.0.127

Environment Details (with versions)

No response