[AWA] Cannot save a VARA if two keys differ only in case of upper and lower case.

Document ID : KB000115844
Last Modified Date : 04/10/2018
Show Technical Document Details

In AWI version 12.0 and v12.1, you cannot save a VARA if two keys differ only in case (i.e. same characters where the only difference is the case).
Even with Oracle DB which is case sensitive.

The behavior is different in AWI and Java UI:

- In Java UI, you can save the VARA and 2 keys when using Java UI.
Below warning appears, but you still can save the VARA:
Warning: U05000028 WARNING: Scope 'File' already exists. Case-insensitive databases
(Microsoft SQL Server) replace the first entry by the second. Save anyway?

- In AWI, we can't save the VARA. there is a warning icon next to the duplicate key: "No duplicate keys allow"
This defect has been found and fixed in:
AWI v12.0.7, planned released date: Jan. 27th 2019
AWI v12.1.4, planned released date: Jan 28th 2019
AWI v12.2.1, planned released date: Oct. 23rd 2018
AWI v12.3.0, planned released date: Feb. 28th 2019

We also updated the documentation:
Case-sensitive keys are supported.
Example: Add the keys "test" and "TEST". If your database is case sensitive, it will save both keys, otherwise, the second entry will replace the first one.