Sitecore 9 Additional Publishing Target

Sitecore 9 Additional Publishing Target You are usually adding new publishing targets in Sitecore because of different geographic regions or databases in different data centers where you are hosting these web databases.

For a long time, for Sitecore 7 and 8, process for creating new publishing target was more or less the same. You have created new entry in ConnectionStrings.config, added new entry in web.config and added new definition item in master database under “/sitecore/system/Publishing targets” node.

In Sitecore 9 process has been slightly changed. You are not changing web.config anymore but Sitecore.config and 2 additional steps are now involved for adding new publishing target. These two more steps are adding and elements in Sitecore.config.

In my example below, I will use “web_secondary” as name of publishing target database. I will use “QA” as name of publishing target.

Steps to add new publishing target in Sitecore 9:

  • Create new target database in ConnectionStrings.config where you want content to be published:

  • Add new entry in master database under “/sitecore/system/Publishing targets” node.




[caption id="attachment_157" align="aligncenter" width="656"]publishing targets publishing targets[/caption]

  • Create a patch file under C:inetpubwwwrootinstancenameApp_ConfigIncludeProject or any other folder based on your setup. I have named my patch config file “PublishingTargets.config” and this is it’s content (you can just copy it and change web_secondary based on name of your secondary web database specified in ConnectionStrings.config):


Download the Publishing Target Patch File






    • After applying these changes, you can see now pretty new publishing target in publishing dialog in Sitecore 9:




 

[caption id="attachment_158" align="aligncenter" width="504"]publishing targets publishing targets[/caption]



    • Finally the newly added database must be created manually in SQL Server else Sitecore won’t start and will give you otherwise this nice exception:





Server Error in ‘/’ Application.


One or more exceptions occurred while processing the subscribers to the ‘property:changed’ event.


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.AggregateException: One or more exceptions occurred while processing the subscribers to the ‘property:changed’ event.

Source Error:






An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:







[AggregateException: One or more exceptions occurred while processing the subscribers to the 'property:changed' event.]

   Sitecore.Events.EventSubscribers.RaiseEvent(String eventName, Object[] parameters, EventResult result) +1849

   Sitecore.Events.Event.RaiseEvent(String eventName, Object[] parameters) +422

   Sitecore.Data.Properties.PropertyStore.RaiseEvent(String name, Object[] parameters) +85

   Sitecore.Web.Authentication.DefaultTicketManager.IsTicketExpired(Ticket ticket, Boolean useProlongation) +357

   Sitecore.Web.Authentication.DefaultTicketManager.GetTicket(String ticketId, Boolean returnExpired) +118

   Sitecore.Web.Authentication.DefaultTicketManager.IsTicketValid(String ticketId) +49

   Sitecore.Shell.Web.ShellPage.IsLoggedIn(Boolean returnAfterLogin) +314

   Sitecore.Shell.Web.UI.SecurePage.OnLoad(EventArgs e) +22

   System.Web.UI.Control.LoadRecursive() +154

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4088


 



Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.2623.0 https://xchangesitecore.com/sitecore-9-additional-publishing-target/ Vikash Raaj

Comments

Post a Comment

Popular posts from this blog

Handling Disaster Recovery Plan

Image
Handling Disaster Recovery Plan We all are interested in knowing how to make the disaster or backup production environment which can help to reduce the downtime in real world. We need to setup the servers in different regions. mirror the database to each region from live environment load balancer should be configured to route the request to other environment if the server reachable or alive test page doesn't respond or its 404 bad response. Intimate the network and IT team about failures. Once the original environment is up, request can be sent to the original servers and the mirroring regions can be kept alive and as cold stand by. https://xchangesitecore.com/handling-disaster-recovery-plan/ Vikash Raaj
Read more

Sitecore Media Library

Image
Sitecore Media Library Controlling File Upload and Deny Execute Permissions on the Upload Folder You can strengthen the sitecore installation by restricting the access to the files that are begin uploaded by users. If you allow users to modify the content of /upload in website root folder then you also give them permission to place the scripts and executable programs. Executing these scripts and programs can cause an unexpected behavior on the server. You must therefore prevent an uploaded file from being executed on the server side when a user attempts to download it. We recommend that you deny permissions to run scripts and executable files in the /upload folder Note: You only need to perform this step if your configuration allows content authors to place files directly to the /upload folder. For example, if you use a shared directory or FTP server, content authors can quickly place a lot of media in the media library. Denying Execute Permission in IIS yo...
Read more

Sitecore Aliases for Multi Site

Image
Sitecore Aliases for Multi Site Are you having multi site environment and want to make use of Aliases in different for each site and\or share the Aliases for couple of sites? Yes we can do with the help of the custom plugin that was built to extend the feature of the Aliases Aliases for Multi-Site Environment https://xchangesitecore.com/sitecore-aliases-for-multi-site/ Vikash Raaj
Read more