This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

When running the Registration Wizard, an error is presented:


Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.HelpLink.ProdName : Microsoft SQL Server HelpLink.ProdVer : 12.00.5590 HelpLink.EvtSrc : MSSQLServer HelpLink.EvtID : 512 HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink HelpLink.LinkId : 20476

Image

Symptoms

When looking at the K2 Hostserver log files, you may find these errors:


Error Marshalling SourceCode.Security.Claims.ClaimsManagement.AddRealm, Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Troubleshooting Steps

It's possible you may have a duplicate within one of your Identity.Claims* tables.

Have a look at your Identity.Claims* tables, and make sure there are no duplicates within your Identity.ClaimRealm table. If you do find a duplicate, please contact K2 Support to remove the duplicate in the correct manner.

Please note

  • Do not modify any database definition or database content unless specifically instructed to do so by K2.
  • No changes to the K2 Database definition or content are supported unless specifically instructed by K2.
  • Please contact K2 Support if you require further assistance as database modification is not supported.