Jump to content

Error Creating Shared Password Lists IF user policy E2=X

Recommended Posts



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.


Link to comment
Share on other sites



This issue relates to SQL Server not being able to insert a record into the DB. We've only seen this before when customers are using SQL Server Transactional Replication, and the High Availabilit instance of Passwordstate was not set to be passive i.e. read only.


Is this your setup? If so, if you go to the screen Administration -> Authorised Web Servers, are the roles for your servers set correctly?


If so, please contact us via the following page, as we will need to check your database schema to ensure it is correct - https://www.clickstudios.com.au/support.aspx

You can provide us a copy of your schema by following this article - https://www.clickstudios.com.au/documentation/generate-database-schema.aspx 


Version 9 also required .NET Framework 4.7.2 or higher, but we do not believe this is your issue.


Click Studios

Link to comment
Share on other sites



Thanks for the script, and we will take a look at get back to you.


Can you confirm if you are using more than one Passwordstate web server? If so, can you also send screenshots of the Authorised Web Servers screen in Passwordstate, and also let us know what SQL Server Replication you are using?


Click Studios

Link to comment
Share on other sites

  • 2 months later...


Sorry for the delay.
Im using a primary website that is listed as Authorised in the Authorized Web Servers section.
This instance uses a simple MSSQL Server 2016 Core without replication.

I can confirm after upgrading from 8995 to 9xxx and when using the E2 policy that applies permissions to the created Shared Password List is enabled and applied this error occors only. (On two instances)

If we take a look at the result of the applied policy when creating a Shared Password List permissions are copied from the Password List Template: PermissionX as set.
But there is a small detail here:
Take a look at this checkbox that is applied as a default when E2 is enabled. During the process of applying permissions to a not selected Password List or Template and that's why i recieve an SQL error when the DB try to link the attribute to a NULL variable (none existing)


Wordkaround 1:
If i chose a Shared Password List or Template when this checkbox is applied i recieve no error and the Shared Password List is created since the DB have an attribute to apply to.

Wordkaround 2:
If i uncheck the box below to not execute a linking the Shared Password List is created without an error as well.

How can i disable this prefered Linking for Shared Password Lists while using E2?
I have recreated Password List Templates and policies, changed all attributes in Settings and relogged everytime without success.

I also have this setting in: Settings\Password List Settings: which not seames to work since it's prechecked when E2 is used.

Can you assist me on this part? Since i experience it's a prechecked setting and have to be deselected each time a password list is created if E2 is enabled. I have two separate instances that experiance this after upgradeing from 8550 to 9xxx.

Thanks in advance


Link to comment
Share on other sites

Hi Tony,


Thanks for the information, and we'll use your screenshots to and do some testing to see if we can reproduce this. In theory, if you do not have a Password List selected for copying settings in the User Account Policy, then we should ignore that System Settings for linking the Password List to the Template.


It does sound like a bug, and we'll need to work on a fix for the next release.

Thanks again.


Click Studios

Link to comment
Share on other sites

Hi Support,


I agree on that point and think that if E2 policy or some of these system settings > password list options i sent to you over mail is activated while upgrading from 8995 to 9x version this bug occurs. Shout if you need an example of settings since i have a saved backup of them that always (7/7 migrations) ended up with this error after the upgrade process.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...