Applications with similar names resulting in a SQL error

Products

• CA API Developer Portal

Issue/Introduction

There were 2 sets of Apps with similar names created in the Portal.
From what I can see the Portal is case sensitive while SQL is not and it was seeing them as duplicate entries.

2020-04-27T02:27:10.597-0700 WARNING 186 com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since Duplicate entry 'ORG-1' for key 'uk_oc_name_org'
2020-04-27T02:27:11.065-0700 WARNING 186 com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since Duplicate entry 'ORG-2' for key 'uk_oc_name_org'  

I have changed the names but we need a solution to avoid these errors in the Future.
Is there a way of changing the portal to case insensitive or vice versa?

Environment

Release : 4.4

Component : API PORTAL

Cause

DE464537

Resolution

Sustaining informed this defect will be fixed on Portal v5.0 version