1

Using the following in PS1 script:

Import-Module SitecoreInstallFramework
$prefix = "bc2018"
$PSScriptRoot = "D:\resourcefiles"
$XConnectCollectionService = "$prefix.xconnect"
$xConnectCertName = "$prefix.xconnect_client"
$SqlServer = "BCCMPTLCD4DB"
$SqlAdminUser = "Admin"
$SqlAdminPassword="sp20019!"
$SiteName = "$prefix.xconnect.org"

Install client certificate for xconnect

$certParams = @{
  Path = "$PSScriptRoot\xconnect-createcert.json"
  CertificateName = "$prefix.xconnect_client"
}

Install-SitecoreConfiguration @certParams -Verbose<br />

Deploy xconnect instance

$xconnectParams = @{
   Path = "$PSScriptRoot\xconnect-xp1-collection.json"
   Package = "$PSScriptRoot\Sitecore 9.0.2 rev. 180604 (OnPrem)_xp1collection.scwdp.zip"
   LicenseFile = "D:\resourcefiles\license.xml"
   Sitename = $SiteName
   XConnectCert = $xConnectCertName
   SqlDbPrefix = $prefix
   SqlServer = $SqlServer
   SqlAdminUser = $SqlAdminUser
   SqlAdminPassword = $SqlAdminPassword
}

Install-SitecoreConfiguration @xconnectParams -Verbose<br />

It gets to the follow spot in the script and then just stalls:

enter image description here

4
  • Try waiting a bit, in 9.0.2 it takes more time than 9.0.1. Check this for easy install isaadansari.wordpress.com/2018/05/01/… Sep 19 '18 at 9:21
  • I waited an hour an nothing happened. Sadly the company I work for has all wordpress sites blocked. Sep 19 '18 at 14:31
  • sad to know. you can try this one. it is WIP/migration though, isaadansari.com/… Sep 20 '18 at 8:48
  • To be on the same page, I am installing the xp scaled version to a production environment. Almost all of the information I have gleaned from the net is for xp single installs. Sep 20 '18 at 16:52
1

We have found that Database Change audit stalls the database. In order to solve this issue we had to turn off that audit. Here is what we did (our database is called DB_Changes):

  1. Create new query against master database:

    ALTER SERVER AUDIT DB_Changes WITH (STATE = OFF)

  2. Run the Powershell script for xConnect.

  3. After script completes run the following query to re-enable audits:

    ALTER SERVER AUDIT DB_Changes WITH (STATE = ON)

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.