ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Applications with similar names resulting in a SQL error
Article ID: 194916
CA API Developer Portal
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?
Release : 4.4
Component : API PORTAL
Sustaining informed this defect will be fixed on Portal v5.0 version