4

The installation for Sitecore 9.1.0 is stuck at step number 50. This is what I get in the System Event Logs as 3 separate errors.

Errors were encountered in the procedure 'dbo.__DeleteAllReportingData' during compilation of the object. Either the containment option of the database 'xp901_Reporting' was changed, or this object was present in model db and the user tried to create a new contained database.

Errors were encountered in the procedure 'dbo.ReduceMetricsTable' during compilation of the object. Either the containment option of the database 'xp901_Reporting' was changed, or this object was present in model db and the user tried to create a new contained database.

Errors were encountered in the procedure 'dbo.ReduceSegmentMetrics' during compilation of the object. Either the containment option of the database 'xp901_Reporting' was changed, or this object was present in model db and the user tried to create a new contained database.

Previously, I have installed Sitecore 9.0.1 and 9.0.2 on the same machine. Any pointers?

The PowerShell script is stuck at this point

[ShardingTool - Create]:[Path] C:\inetpub\wwwroot\xp910.xconnect\App_Data\collectiondeployment\Sitecore.Xdb.Collection.Database.SqlShardingDeploymentTool.exe
        *** Welcome to Sitecore xDB Collection SQL Sharding Deployment Tool ***
        Tool was run with the following configuration:
        Operation: create
        SQL server connection:
        Server name: DESKTOP\SQLEXPRESS
        User: sa
        Integrated security: False
        Connect Timeout: 15
        Database edition: Basic
        Shard map manager database name: xp901_Xdb.Collection.ShardMapManager
        Shard map names: ContactIdShardMap, DeviceProfileIdShardMap, ContactIdentifiersIndexShardMap
        Shard number: 2
        Shard name prefix: xp910_Xdb.Collection.Shard
        Shard name suffix:
        Dacpac file path: C:\inetpub\wwwroot\xp901.xconnect\App_Data\collectiondeployment\Sitecore.Xdb.Collection.Database.Sql.dacpac
        Creating database xp910_Xdb.Collection.ShardMapManager
        Created Shard Map Manager
Improve this question
5
  • 1
    This is a long shot but is it possible you installed Sitecore 9.0.1 previously with the name "xp910" and then deleted it without deleting the databases?
    – Mark Gibbons
    Jan 20 '19 at 3:38
  • I don't have such database before and I always delete before installing fresh version.
    – Naveed Ahmad
    Jan 22 '19 at 19:10
  • What version of SQL are you on?
    – Chris Auer
    Feb 2 '19 at 1:10
  • SQL Server 2016 SP 2 - version -> 13.0.5026.0
    – Naveed Ahmad
    Feb 5 '19 at 2:03
  • I've started getting this on my machine as well, did you ever figure out a solution?
    – Jason
    Apr 8 '19 at 5:59
1

Sitecore 9.1 requires you to enable contained database authentication.

You just need to run the following command on your SQL Server Management Studio:

sp_configure ‘contained database authentication’, 1;
GO

RECONFIGURE;
GO
Improve this answer
1
  • I have run this several times but no progress
    – Naveed Ahmad
    Feb 5 '19 at 2:03
1

Looking at the file path for the Dacpac, you might be pointing to 9.0.1 files on the 9.1.0 installation. Can you double-check this?

Also, 9.0.1 and 9.0.2 use SIF 1 I think, while 9.1 uses SIF 2. It might be you're using the wrong version of SIF to install?

Improve this answer
2
  • That's not possible as the Sitecore.Xdb.Collection.Database.SqlShardingDeploymentTool.exe is deployed / extracted during the installation process. I am using SIF 2
    – Naveed Ahmad
    Feb 15 '19 at 4:24
  • Looking at your error message there's a configuration for SqlShardingDeploymentTool.exe. Dacpac file path: C:\inetpub\wwwroot\xp901.xconnect\App_Data\collectiondeployment\Sitecore.Xdb.Collection.Database.Sql.dacpac The path you're running it from is C:\inetpub\wwwroot\xp910.xconnect\ They do not match.
    – Trayek
    Feb 15 '19 at 9:17
0

According to Sitecore compatibility table, Sitecore 9.1 can only be installed on SQL 2016 sp2 and above, Sitecore 9.0 can only be installed on SQL 2016 sp1 and under. Make sure your SQL server version meet the 9.1 requirement. https://kb.sitecore.net/articles/087164

Improve this answer
1
  • I do have SQL 2016 SP2 installed, this didn't work.
    – Naveed Ahmad
    Jan 24 '19 at 14:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.