Sitecore XC 9.2- Fix for Install-SitecoreConfiguration : The service cannot accept control messages at this time. (Exception from HRESULT: 0x80070425)

Error details -
[------------ StoreFront-PreconfigureInstance_StartAppPool : ManageAppPool -------------------------------------------]
[StoreFront-PreconfigureInstance_StartAppPool]:[Start] SC921sc.dev.local
VERBOSE: Performing the operation "Start-WebAppPool" on target "SC921sc.dev.local".
VERBOSE: Checking state of App Pool 'SC921sc.dev.local'
VERBOSE: Starting App Pool 'SC921sc.dev.local'
Install-SitecoreConfiguration : The service cannot accept control messages at this time. (Exception from HRESULT:
0x80070425)
At C:\deploy\SIF.Sitecore.Commerce.3.0.28\Deploy-Sitecore-Commerce.ps1:95 char:1
+ Install-SitecoreConfiguration @params -Verbose *>&1 | Tee-Object "$PS ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-SitecoreConfiguration

[TIME] 00:03:14
Invoke-ManageAppPoolTask : The service cannot accept control messages at this time. (Exception from HRESULT:
0x80070425)
At C:\Program
Files\WindowsPowerShell\Modules\SitecoreInstallFramework\2.1.0\Public\Install-SitecoreConfiguration.ps1:641 char:25
+                         & $entry.Task.Command @paramSet | Out-Default
+                         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-ManageAppPoolTask

`FIx - I think there was issue in service, they it cannot accept control messages at this time. I have restarted the system and it worked for me.

Sitecore XC 9.2 - Mulitenant Adding a new tenant is very easy.

It's very simple to configure multiple tenants in Sitecore XC - Here is the link for more details - Details

I have followed a few steps here and watched the video, It's very easy and straightforward.


Good work Sitecore!

Sitecore XC 9.2- Fix for Install- MERGE statement attempted to UPDATE or DELETE

Today, I was trying to install XC again to refresh an existing instance and found below error -

msdeploy.exe : Error: .Net SqlClient Data Provider: Msg 8672, Level 16, State 1, Line 2 The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A

MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

At C:\Program Files\WindowsPowerShell\Modules\SitecoreInstallFramework\2.1.0\Public\Tasks\Invoke-CommandTask.ps1:31 char:13

+             & $Path $Arguments | Out-Default

+             ~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : NotSpecified: (Error: .Net Sql...he source rows.:String) [], RemoteException

    + FullyQualifiedErrorId : NativeCommandError

Error: Script execution error.  The executed script:

BEGIN TRANSACTION;

CREATE TABLE #Blobs (

    BlobId  UNIQUEIDENTIFIER NOT NULL,

    [Index] INT              NOT NULL,

    Data    IMAGE            NOT NULL,

    Created DATETIME         NOT NULL

);

CREATE TABLE #Items (

    ID         UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,

    Name       NVARCHAR (256)   COLLATE database_default NOT NULL,

    TemplateID UNIQUEIDENTIFIER NOT NULL,

    MasterID   UNIQUEIDENTIFIER NOT NULL,

    ParentID   UNIQUEIDENTIFIER NOT NULL,

    Created    DATETIME         NOT NULL,

    Updated    DATETIME         NOT NULL

Fix - you must remove the reference to the "ModuleHabitatImages" from the Includes section of the Master_SingleServer.json file