Recently, I have installed and setup Sitecore 9.3 on another machine. I faced similar/same kind of issues which I faced earlier. Thought, it would be helpful to the Sitecore Community if I capture and document them along with resolution steps I which took and be successful in settting up.
Here are few of them I could document them.
1. Failed to start service 'Sitecore Marketing Automation Engine - sitecore93xconnect.dev.local-MarketingAutomationService (sitecore93xconnect.dev.local-MarketingAutomationService)'.
Solution: This issue occurs because of non-self-signed certificates, hence please follow the below steps to resolve your issue. Execute below PowerShell script to find out if there are any non-self-signed certificates: 1. Open the PowerShell Console (Admin mode recommended) 2. Execute below command Get-Childitem cert:\LocalMachine\root -Recurse | Where-Object {$_.Issuer -ne $_.Subject} 3. If it shows any results listing any non-self-signed certificates 4. Execute below command Get-Childitem cert:\LocalMachine\root -Recurse | Where-Object {$_.Issuer -ne $_.Subject} | Move-Item -Destination Cert:\LocalMachine\CA 5. Above command will move non-self-signed certificates into the Intermediate Certification Authorities store 6. Execute #2 command again to make sure it will not list any non-self-signed certificates
2. Failed to start the newly setup site and failed to complete the 92nd step with the below error
[-------- SitecoreXP0_UpdateSolrSchema : SitecoreUrl -------------------------] [SitecoreXP0_UpdateSolrSchema]:[Authenticating] https://sc93sc.dev.local/sitecore/admin/PopulateManagedSchema.aspx?indexes=all Error requesting https://sc93sc.dev.local/sitecore/admin/PopulateManagedSchema.aspx?indexes=all: The underlying connection was closed: The connection was closed unexpectedly. [TIME] 00:10:06 Error requesting https://sc93sc.dev.local/sitecore/admin/PopulateManagedSchema.aspx?indexes=all: The underlying connection was closed: The connection was closed unexpectedly.
Solution: Check browser proxy settings. If you are behind a corporate proxy or any other proxy settings. uncheck the settings. i. Open Internet explorer -> Internet Options -> Connection Tab ii. For Settings and LAN settings, Check Automatically detect settings and remove any other checks to remove proxy
4.ErrorCode: ERROR_SQL_EXECUTION_FAILURE
More Information: An error occurred during execution of the database script. The error occurred between the following lines of the script: "1" and "43".
Solution: When I was looking for a solution to this error, I read that this is bug reported to Sitecore ( I couldn't find that article again). As suggested in that article, I have set my SQL Server user password i.e sa password to something weak without special characters. It worked for me.
5. [WebDeploy]:[Path] C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe
Error: .Net SqlClient Data Provider: Msg 12809, Level 16, State 1, Line 5 You must remove all users with password before setting the containment property to NONE. Error: Script execution error. The executed script: IF EXISTS (SELECT 1 FROM [master].[dbo].[sysdatabases] WHERE [name] = N'$(DatabaseName)') BEGIN ALTER DATABASE [$(DatabaseName)] SET CONTAINMENT = N ONE WITH ROLLBACK IMMEDIATE; END
Solution: This happens whenever you are trying to re-install Sitecore 9+ setup multiple times due to failure. In my case, I logged into SQL Server and deleted all the Sitecore 9.3 related databases and re-installed.
Here are few of them I could document them.
1. Failed to start service 'Sitecore Marketing Automation Engine - sitecore93xconnect.dev.local-MarketingAutomationService (sitecore93xconnect.dev.local-MarketingAutomationService)'.
Solution: This issue occurs because of non-self-signed certificates, hence please follow the below steps to resolve your issue. Execute below PowerShell script to find out if there are any non-self-signed certificates: 1. Open the PowerShell Console (Admin mode recommended) 2. Execute below command Get-Childitem cert:\LocalMachine\root -Recurse | Where-Object {$_.Issuer -ne $_.Subject} 3. If it shows any results listing any non-self-signed certificates 4. Execute below command Get-Childitem cert:\LocalMachine\root -Recurse | Where-Object {$_.Issuer -ne $_.Subject} | Move-Item -Destination Cert:\LocalMachine\CA 5. Above command will move non-self-signed certificates into the Intermediate Certification Authorities store 6. Execute #2 command again to make sure it will not list any non-self-signed certificates
2. Failed to start the newly setup site and failed to complete the 92nd step with the below error
[-------- SitecoreXP0_UpdateSolrSchema : SitecoreUrl -------------------------] [SitecoreXP0_UpdateSolrSchema]:[Authenticating] https://sc93sc.dev.local/sitecore/admin/PopulateManagedSchema.aspx?indexes=all Error requesting https://sc93sc.dev.local/sitecore/admin/PopulateManagedSchema.aspx?indexes=all: The underlying connection was closed: The connection was closed unexpectedly. [TIME] 00:10:06 Error requesting https://sc93sc.dev.local/sitecore/admin/PopulateManagedSchema.aspx?indexes=all: The underlying connection was closed: The connection was closed unexpectedly.
Solution: Check browser proxy settings. If you are behind a corporate proxy or any other proxy settings. uncheck the settings. i. Open Internet explorer -> Internet Options -> Connection Tab ii. For Settings and LAN settings, Check Automatically detect settings and remove any other checks to remove proxy
3. Sitecore 9.3 installation 503 error while requesting http://xp0.sc/sitecore/admin/PopulateManagedSchema.aspx?indexes=all
Solution: In my case, I observed that this was due to missing ASP component (ASP, ASP.net 3.5 and ASP.net 4.7 or later) on the IIS. I installed the ASP component under the Internet Information Services > World Wide Web Services > Application development features.
Make sure all ASP, ASP.Net 3.5 and ASP.Net 4.7 or ASP.Net 4.8
Solution: In my case, I observed that this was due to missing ASP component (ASP, ASP.net 3.5 and ASP.net 4.7 or later) on the IIS. I installed the ASP component under the Internet Information Services > World Wide Web Services > Application development features.
Make sure all ASP, ASP.Net 3.5 and ASP.Net 4.7 or ASP.Net 4.8
More Information: An error occurred during execution of the database script. The error occurred between the following lines of the script: "1" and "43".
Solution: When I was looking for a solution to this error, I read that this is bug reported to Sitecore ( I couldn't find that article again). As suggested in that article, I have set my SQL Server user password i.e sa password to something weak without special characters. It worked for me.
5. [WebDeploy]:[Path] C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe
Error: .Net SqlClient Data Provider: Msg 12809, Level 16, State 1, Line 5 You must remove all users with password before setting the containment property to NONE. Error: Script execution error. The executed script: IF EXISTS (SELECT 1 FROM [master].[dbo].[sysdatabases] WHERE [name] = N'$(DatabaseName)') BEGIN ALTER DATABASE [$(DatabaseName)] SET CONTAINMENT = N ONE WITH ROLLBACK IMMEDIATE; END
Solution: This happens whenever you are trying to re-install Sitecore 9+ setup multiple times due to failure. In my case, I logged into SQL Server and deleted all the Sitecore 9.3 related databases and re-installed.
Comments
Post a Comment