Sitecore Horizon Authoring and The SSL connection could not be established
Get link
Facebook
X
Pinterest
Email
Other Apps
-
After successfully installing Horizon on Virtual Machine and solving the
Horizon issue due to the URL binding in the IIS. And everything is working
perfectly fine. Now it turns to Horizon URL binding and I have bound with a
new URL name i.e., horizon.abc.com. I opened the new Horizon URL in the
browser and wait there is a new error I am getting, and it is related to the
Authoring and SSL.
If you want to install Horizon and facing some pre-post installation issues
and looking for fixes, then my previous blogs can help you.
Issue 1: When I hit the horizon.abc.com in the browser, it’s redirecting me to
the identity server URL for authentication and but after entering the
credential it does not redirect me to the Horizon page.
Solution:
Go to the Sitecore Identity Server instance and open
Sitecore.IdentityServer.Host.xml file {root directory}\
sc102xmidentityserver.local
\Config\production\Sitecore.IdentityServer.Host.xml
Search <HorizonHttpsCorsOrigin> in the file
<HorizonHttpsCorsOrigin>https:// horizon.sc102xmcm.local
</HorizonHttpsCorsOrigin> It's pointing to the old URL, now
update this URL and point to the new URL which bonded in IIS.
<HorizonHttpsCorsOrigin>https://
horizon.abc.com</HorizonHttpsCorsOrigin>
Issue 2:[ERR] (Sitecore Authoring Host/{ServerName})
[Sitecore.FederatedUI.PageComposer] Failed to render a fragment
"Horizon.App" in region "Shell.Main", with error: "Failed to start
rendering" System.Net.Http.HttpRequestException: The SSL connection
could not be established, see inner exception.
After resolving Issue 1, when I hit again Horizon URL in the browser and enter
credentials it's giving me the below error:
I check the Horizon log for more details and the error log is:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ERR] (Sitecore Authoring Host/EC2AMAZ-9FC5VOM) [Sitecore.FederatedUI.PageComposer] Failed to render a fragment "Horizon.App" in region "Shell.Main", with error: "Failed to start rendering"
System.Net.Http.HttpRequestException: The SSL connection could not be established, see inner exception.
---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..
---> System.Net.Sockets.SocketException (10054): An existing connection was forcibly closed by the remote host.
--- End of inner exception stack trace ---
at System.Net.FixedSizeReader.ReadPacketAsync(Stream transport, AsyncProtocolRequest request)
at System.Net.Security.SslStream.InternalEndProcessAuthentication(LazyAsyncResult lazyResult)
at System.Net.Security.SslStream.EndProcessAuthentication(IAsyncResult result)
at System.Net.Security.SslStream.EndAuthenticateAsClient(IAsyncResult asyncResult)
at System.Net.Security.SslStream.<>c.<AuthenticateAsClientAsync>b__65_1(IAsyncResult iar)
Go to the Sitecore instance and open
Sitecore.Horizon.Integration.config file {root directory}\ sc102xmcm.local\
App_Config\Modules\Horizon\Sitecore.Horizon.Integration.config
Search setting name
Horizon.ClientHost
<setting name="Horizon.ClientHost" value="https://
horizon.sc102xmcm.local" /> It's pointing to the old URL, now update it with the new URL: <setting
name="Horizon.ClientHost" value="https:// horizon.abc.com" />
Go to the Sitecore Horizon instance and open Host.xml file {root directory}\ horizon.sc102xmcm.local \Config\Host.xml
Search <HostBaseUrl> <HostBaseUrl> https:// horizon.sc102xmcm.local" /></HostBaseUrl> Again, it's pointing to the old URL, now update it with the new URL: <HostBaseUrl> https:// horizon.abc.com</HostBaseUrl>
Run the Horizon URL and everything will work fine.
Error: [------- XConnectXP0_StartServices [2] : ManageService -----------------------] [XConnectXP0_StartServices [2]]:[Updating] sc903xconnect.dev.local-MarketingAutomationService Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing ...
In my previous blog , we had discussed Sitecore PowerShell Command and Scripts. In this blog, I am discussing with you about How to Import CSV Data in Sitecore using PowerShell Scripts? To do the same you need to read the CSV file rows and create Sitecore Items into the Content Tree for each row then assign the column values of the row into the respective Item Field. There are two options: Write your own customized PowerShell Script and Import CSV Data. Use the inbuilt Data Importer tool that comes with Sitecore PowerShell Extension . Option 1: Perform the Below steps to Import the CSV Data into Sitecore: First, you will need a CSV file. If you have Excel Sheet, then go to the File Menu and click on Save As option and change the format and save it into CSV format. Suppose you have a CSV file with the number of rows and each row has several columns with predefined values. Here I am taking the below CSV file for an...
While upgradation to Sitecore 10.2, I was to restore the database on the Managed Cloud Service Azure SQL Server. I have connected the Azure SQL server on my local SSMS and started to import the Database using the option Import Data-tier Application. While importing the database using the above option you need a BACPAC file instead of a .bak file. So I was to create a BACPAC file of the database from my local. Go to the database, right-click and select the Export Data-tier Application option under the Task menu. After clicking on the next, while creating the BACPAC file you may get the below error: Solution: Go to the Users in that Database. Your Database => Security => Users Find the user, right click and delete it. If you are unable to delete the user and encountered a new error as below: It means the user you are going to delete owns a schema in the database and owners. First, you need to search which schemas own...
Comments
Post a Comment