• Foreign Key Constraint Issue on Inserts

    Description When making updates to Episerver you get an error "The INSERT statement conflicted with the FOREIGN KEY constraint". Resolution This is generally caused by either multiple web sites or multiple web environments (development, staging, integration, production, etc.) pointing to the same database. This setup is not a proper or supported setup. If you are hosting multiple sites or have multiple environments you will need to have a single database for each sit...

  • Pardot Credentials Disappear on DxC

    Description This article describes an issue with Pardot in a DxC environment. It is observed that on a deploy or some time after the deploy that the credentials are wiped from the DDS. Resolution The recommendation is to upgrade to these packages:EPiServer.ConnectForMarketingAutomation.4.3.0EPiServer.MarketingAutomationIntegration.Pardot.3.1.0We have added an additional method of encrypting connector credentials (AES encryption with an SHA256 computed hash based on the value ...

  • Legacy Subscription Job does not work correctly with UTC dates

    Description This article describes an issue with the SubscriptionJob not generating subscription emails after having applied the Episerver UTC update. Subscription is a legacy system in Episerver from version 4 (back in 2004). Subscription allows website visitors to subscribe by e-mail to website content of their choice. Selected content pages, for instance news or event pages, can be made available to be included in the subscription scheduled job that is set up.  Steps To Reproduce: E...

  • Database upgrade error Episerver CMS 9 to CMS 10

    Description Upgrade from CMS 9 to CMS 10 but you get an error upgrading the database: Update-EPiDatabase -Verbose:$trueC:\..\packages\EPiServer.Framework.10.10.4\tools\epideploy.exe -a sql -s C:\..\.. -p C:\..\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\* -c EPiServerDBFound location C:\..\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\config with 0 files of type SqlProcessing C:\..\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.8.0.sqlScript validation: 0 - A...

  • Episerver Content Import Fails In DXC With FOREIGN KEY Constraint Error

    Description This article describes an issue where importing content from one DXC environment to another you get the following type of errors below and the import fails. The following errors have occurred: [Importing content 21006_26699] Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblWorkContentProperty_tblPropertyDefinition". The conflict occurred in database "epicms", table "dbo.tblPropertyDefinition", column 'pkID'. Impo...

  • How to Determine your Episerver Database Version

    In certain circumstances, such as a deployment, you may want to verify that you have the correct Episerver database version for your CMS package. Here are the steps for that. Resolution 1) Run the following stored procedure. declare @ver intexec @ver=sp_DatabaseVersionprint @ver 2) Use the following utility to match the database version with the corresponding CMS.Core package version. http://nuget.episerver.com/en/Comparedatabase/

  • Empty Recycle Bin - Episerver 6

    If you run into an issue with the recycle bin not emptying in Episerver 6 this query may help. Resolution Please only run this if you have exhausted all other options Run the following query against the database -EXEC editDeleteChilds @PageID =2 @ForceDelete = 1) //where 2 is the ID of recycle bin. Please backup the database before running above query. Also please make a backup copy of the database and restore it locally and perform this operation. Once confirmed to so...

  • Determining largest tables within a database

    DescriptionAt times Support may ask for verification on the largest tables in a database either when investigating a performance issue or when investigating various functionalities of a site. The below steps detail how to verify what tables are taking up the most amount of space wihtin a database, and are not specific to a particular CMS. These steps are specific to SQL management studio, so if another product is leveraged for database managment these steps might not yield the same results.R...

  • A network-related or instance-specific error occurred while establishing a connection to SQL Server on EPIServer installation

    When installing an installation of EPIServer on a local machine the following error message is thrown by the site on compilation. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. V...