Hello, I’ve added a lot of dictionary terms and trying to import the new dictionary through console but I see “sailpoint.tools.GeneralException: org.hibernate.exception.ConstraintViolationException: could not execute statement”
I switched the following. Are there any other characters I have to modify?
< to <
& to &
-TIA
Welcome back @ravinekkanti - Are you using the ‘import action=“merge”’ on your XML file?
Generally I see the ‘ConstraintViolationException’ in IdentityIQ when dealing with duplicate records. If you are using the merge action and including dictionary terms that already exist in your configuration I could see this potentially happening.
Do you see any other log messages that make you think that this is an invalid character issue?
Thanks @adam_creaney! yes, I’m using ‘import action=“merge”. when I split the file into smaller files I no longer see ‘ConstraintViolationException’.
I was able to import a term successfully but I see java.util.regex.PatternSyntaxException: Unmatched closing ')' near index 7** **.*abcdef).* when I try to reset an identity’s AD password. so I tried replacing with abcdef\\) but still getting the same error.
I tried to escape(\\) these special characters [ ] { } ( ) \ ^ $ . | ? * +.
Yeah looks like its not escaping correctly still. Crazy suggestion - what if you use four \\ characters to escape? Its been awhile since i’ve worked with java regex but seem to recall there were occasional instances where I needed to escape the escape char for things to work correctly.
@adam_creaney single backslash \ worked.