We have faced a lot of issues and we are looking for exact fix for these issues listed below: -
Release : 5.0.2
Attached a portal gateway bundle will be part of 220.127.116.11
otk-patch-api-key-sync-1.0.0.zip fixes the race-condition experienced during API key deployments due to the use of a shared OTK oracle DB. The bundle updates the 'Portal API Key Storage Sync' policy in OTK and adds an additional JDBC assertion that executes a merge query that attempts to check if the record exists and update if it doesn't and insert if it does.
Since this query can still fail due to concurrent inserts, it is followed by an additional update query doing the same thing ensuring success.
The two related defects that are also included in 18.104.22.168”
- DE546663: Delete key fix (22.214.171.124)
- DE547726: Large API key update message fix (126.96.36.199)