Applications with similar names resulting in a SQL error

book

Article ID: 194916

calendar_today

Updated On:

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 'SNOW-US-US' 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 'SALESFORCE-US-US' 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?


Cause

DE464537

Environment

Release : 4.4

Component : API PORTAL

Resolution

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