While upgrading from 20.3.1370.0 to 21.4.600.0, received below error. i.e. Numerous errors for each user data,
2022-03-15 12:21:31,341 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter - Violation of UNIQUE KEY constraint 'usr_username_uc'. Cannot insert duplicate key in object 'dbo.usr'. The duplicate key value is (testuser1).
We've not received these type of "Violation of UNIQUE KEY constraint primary data source" error when we did Appian upgrade / HF in the past.Not sure, if this is part of Appian Product Issue. We're using the recent 21.4.600.0 HF released on 11th Mar 2022 - hope this is stable HF ver. and Appian not aware of any such "UNIQUE KEY constraint primary data source" issue?
Just curious to know if anyone received this error when Appian upgrade...Any suggestions / guidance to handle this type of error please? - Thanks.
Discussion posts and replies are publicly visible
I recommend to contact Appian support.
Thanks Steve, sorry. I don't have access to Appian support portal for now. That's the main reason, trying to get some help/clarifications here if this is known issue and anyone handled this type of error while upgrading Appian. thanks again.
I think most people here are not sys admins, but Appian designers.
Try to send an email to support@appian.com.
Great, thanks Steve.