Deleting record with unique Key
Hi Guys,
I had a record with name field has a uniqueKeyIndex, so because I couldn't change and update the name description using SQL, I went and changed the name description in the Globals and removed the Index on name with old description, but now I wanted to create a new record with the old description that I removed from Globals but I'm getting UniqueIndex error, which means the old description is still somewhere in one of the globals, but I can't find that record anywhere in both data or index globals ?
thanks
Product version: Ensemble 2014.1