Hi,
After updating Passwordstate we are having problem creating Password Lists and a error sign is shown:
When querying the Passwordstate DB it shows the following:
Error Code = The statement has been terminated. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LinkedPasswordLists_PasswordListTemplates". The conflict occurred in database "passwordstate", table "dbo.PasswordListTemplates", column 'PasswordListTemplateID'., StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at (Object ) at Passwordstate.Passwordstate.PasswordList.LinkPasswordListToTemplate(String PasswordListTemplateID, String PasswordListID, String PasswordList, Boolean AddLinkedRecord, Boolean IsPrivate)
The Password List is displayed after hitting F5 in browser and is created in the root of the tree instead of the folder in the tree I created in. When creating in root path the issue is the same.
This error occurs when i have a User Policy set in E2:
The users in E2 all exists and are active and have not been a problem before the upgrade.
If I disable the policy or default E2 value and relogg the policy is applied the users can create their Password Lists.
.
I saw in the release of 9100 there was a fix in this area:
Fixed an issue with setting permissions when creating Password Lists under folders with Advanced Permissions model, where settings and permissions were based off a Template via a User Account Policy
I don't know if i have missed something in the upgrade proccess or if the upgrade didn't apply the fix during the process?
I had to manually install DOT NET 4.7.1 on the core servers via cli before upgrade if that have something to with it.
Thanks