7.2.24

Configuring a Development KMIP Server on Windows

If you are planning to use client-side field level encryption with a KMIP compliant key store in MongoDB, you can use PyKMIP. These steps outline the configuration required to setup your dev KMIP server.

Prerequisites

Generate the Certificates

At a Powershell prompt

cd /

mkdir -p csfle/certs

cd csfle/certs

Save all the commands below in a file named create_certs.ps1 and run it from the Powershell prompt ./create_certs.ps1

# Define file paths
$caKeyPath = "ca-key.pem"
$caCertPath = "ca-cert.pem"
$serverKeyPath = "server-key.pem"
$serverCertPath = "server-cert.pem"
$clientKeyPath = "client-key.pem"
$clientCertPath = "client-cert.pem"
$mergedClientPath = "client-key-cert.pem"

# Step 1: Generate CA key and certificate
openssl req -new -x509 -days 365 -nodes -out $caCertPath -keyout $caKeyPath -subj "/CN=MyCA"

# Step 2: Generate server key and certificate signed by the CA
openssl genpkey -algorithm RSA -out $serverKeyPath
openssl req -new -key $serverKeyPath -out server.csr -subj "/CN=localhost"
openssl x509 -req -in server.csr -CA $caCertPath -CAkey $caKeyPath -CAcreateserial -out $serverCertPath -days 365
Remove-Item server.csr

# Step 3: Generate client key and certificate signed by the CA with SAN
openssl genpkey -algorithm RSA -out $clientKeyPath
openssl req -new -key $clientKeyPath -out client.csr -subj "/CN=Client" -addext "subjectAltName=DNS:localhost"
openssl x509 -req -in client.csr -CA $caCertPath -CAkey $caKeyPath -CAcreateserial -out $clientCertPath -days 365
Remove-Item client.csr

# Step 4: Merge client key and certificate into a single file
Get-Content $clientKeyPath, $clientCertPath | Set-Content $mergedClientPath

# Display success message
Write-Host "Certificates and keys generated successfully:"
Write-Host "CA Certificate: $caCertPath"
Write-Host "Server Certificate: $serverCertPath"
Write-Host "Client Certificate: $clientCertPath"
Write-Host "Merged Client Key and Certificate: $mergedClientPath"

#Create a local database to hold the CMKs
cd c:/csfle
New-Item -ItemType File pykmip.sqlite

Install PyKMIP

Run the following commands

pip install cryptography
pip install pykmip
pip install sqlalchemy

Create the PyKMIP configuration

 In the folder c:\csfle\ create a configuration file create_server_conf.ps1  and add the code below. Save and run the file

$configFile = "kmip-server.conf"
Remove-Item $configFile
New-Item -ItemType File -Path $configFile
New-Item -ItemType File -Path server.log

$config= "[server]
hostname=127.0.0.1
port=5696
certificate_path=C:\csfle\certs\server-cert.pem
key_path=C:\csfle\certs\server-key.pem
ca_path=C:\csfle\certs\ca-cert.pem
auth_suite=TLS1.2
policy_path=
enable_tls_client_auth=False
tls_cipher_suites=
logging_level=DEBUG
database_path=C:\cfsfle\pykmip.sqlite

[client]
host=127.0.0.1
port=5696
certfile=C:\csfle\certs\client-cert.pem
keyfile=C:\csfle\certs\client-key.pem
ca_certs=C:\csfle\certs\ca-cert.pem
ssl_version=PROTOCOL_TLSv1_2

Add-Content -Path $configFile -Value $config

Start the Server

From the c:\csfle directory run the following at a prompt:

pykmip-server -f kmip-server.conf -l server.log

Test the Installation

Create a script kmip_client.py and add the the following code:

from kmip.pie import client
from kmip.core import enums


CONFIG_FILE ="C:\csfle\kmip-server.conf"

ALGORITHM=enums.CryptographicAlgorithm.CAST5
with client.ProxyKmipClient(config_file=CONFIG_FILE) as c:
    uid = c.create(algorithm=ALGORITHM,
                   length=128,
                   )
    symmetric_key = c.get(uid)
    print(f"Symmetric Key Value: {symmetric_key.value}")
  print(f"Created {ALGORITHM} key with ID: {uid}")

Check the Server Logs

2024-02-05 12:00:29,148 - kmip.server - INFO - Server successfully bound socket handler to 127.0.0.1:5696
2024-02-05 12:00:29,148 - kmip.server - INFO - Starting connection service...
2024-02-05 12:03:00,198 - kmip.server - INFO - Receiving incoming connection from: 127.0.0.1:51297
2024-02-05 12:03:00,199 - kmip.server - INFO - Dedicating session 00000001 to 127.0.0.1:51297
2024-02-05 12:03:00,202 - kmip.server.session.00000001 - INFO - Starting session: 00000001
2024-02-05 12:03:00,208 - kmip.server.session.00000001 - DEBUG - Request encoding: b'4200780100000120'
2024-02-05 12:03:00,209 - kmip.server.session.00000001 - DEBUG - Request encoding: b'4200770100000038420069010000002042006a0200000004000000010000000042006b0200000004000000020000000042000d0200000004000000010000000042000f01000000d842005c0500000004000000010000000042007901000000c04200570500000004000000020000000042009101000000a8420008010000003042000a070000001743727970746f6772617068696320416c676f726974686d0042000b05000000040000001200000000420008010000003042000a070000001443727970746f67726170686963204c656e6774680000000042000b02000000040000008000000000420008010000003042000a070000001843727970746f67726170686963205573616765204d61736b42000b02000000040000000c00000000'
2024-02-05 12:03:00,210 - kmip.server.session.00000001 - DEBUG - Possible session ciphers: 15
2024-02-05 12:03:00,210 - kmip.server.session.00000001 - DEBUG - ('TLS_AES_256_GCM_SHA384', 'TLSv1.3', 256)
2024-02-05 12:03:00,211 - kmip.server.session.00000001 - DEBUG - ('TLS_CHACHA20_POLY1305_SHA256', 'TLSv1.3', 256)
2024-02-05 12:03:00,211 - kmip.server.session.00000001 - DEBUG - ('TLS_AES_128_GCM_SHA256', 'TLSv1.3', 128)
2024-02-05 12:03:00,212 - kmip.server.session.00000001 - DEBUG - ('AES128-SHA256', 'TLSv1.2', 128)
2024-02-05 12:03:00,212 - kmip.server.session.00000001 - DEBUG - ('AES256-SHA256', 'TLSv1.2', 256)
2024-02-05 12:03:00,213 - kmip.server.session.00000001 - DEBUG - ('DHE-DSS-AES128-SHA256', 'TLSv1.2', 128)



29.5.19

Sitecore Paypal Integration

 Error: Expected a promise for a string order id to be passed to createOrder  
   at Xt.<computed> (https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:50367)  
   at Object.<anonymous> (https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:56621)  
   at JSON.parse (<anonymous>)  
   at o (https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:56481)  
   at sr (https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:56632)  
   at u.on (https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:61395)  
   at wr (https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:61584)  
   at https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:66021  
   at https://www.paypal.com/sdk/js?client-id=AdMShTgTdPzSQVaEfkdbAHrkQCzDOP80fUceD4vqtxcCaPLwMuQBuFj80vQEmgG9PXYEgLEIFu5vDUxA&disable-funding=credit,card:1:66067  

17.5.19

ndx=sitecore_master_index to the index; possible analysis error: cannot change DocValues type from SORTED_NUMERIC to SORTED_SET for field "__standard_values_sm"

An error occurred. [Log message:    400 6    org.apache.solr.common.SolrException java.lang.IllegalArgumentException  Exception writing document id sitecore://master/{648691d1-8abc-4bf7-bad9-cd6713a224b3}?lang=en&ver=1&ndx=sitecore_master_index to the index; possible analysis error: cannot change DocValues type from SORTED_NUMERIC to SORTED_SET for field "__standard_values_sm" 400   ]

Exception writing document id sitecore://master/{2e1a9aab-f7c1-49ee-b032-28b98d3688d6}?lang=en&ver=1&ndx=sitecore_master_index to the index; possible analysis error: cannot change point numBytes from 8 to 4 for field="version_im"

Job started: Index_Update_IndexName=sitecore_master_index|#Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> SolrNet.Exceptions.SolrConnectionException: 



  400
  2


  
    org.apache.solr.common.SolrException
    java.lang.IllegalArgumentException
  
  Exception writing document id sitecore://master/{2e1a9aab-f7c1-49ee-b032-28b98d3688d6}?lang=en&ver=1&ndx=sitecore_master_index to the index; possible analysis error: cannot change point numBytes from 8 to 4 for field="version_im"
  400


 ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
   at System.Net.HttpWebRequest.GetResponse()
   at HttpWebAdapters.Adapters.HttpWebRequestAdapter.GetResponse()
   at SolrNet.Impl.SolrConnection.GetResponse(IHttpWebRequest request)
   at SolrNet.Impl.SolrConnection.PostStream(String relativeUrl, String contentType, Stream content, IEnumerable`1 parameters)
   --- End of inner exception stack trace ---
   at SolrNet.Impl.SolrConnection.PostStream(String relativeUrl, String contentType, Stream content, IEnumerable`1 parameters)
   at SolrNet.Impl.SolrConnection.Post(String relativeUrl, String s)
   at SolrNet.Impl.LowLevelSolrServer.SendAndParseHeader(ISolrCommand cmd)
   at Sitecore.ContentSearch.SolrProvider.SolrBatchUpdateContext.AddRange(IEnumerable`1 group, Int32 groupSize)
   at Sitecore.ContentSearch.SolrProvider.SolrBatchUpdateContext.Commit()
   at Sitecore.ContentSearch.SolrProvider.SolrSearchIndex.PerformRebuild(Boolean resetIndex, Boolean optimizeOnComplete, IndexingOptions indexingOptions, CancellationToken cancellationToken)
   at Sitecore.ContentSearch.SolrProvider.SolrSearchIndex.Rebuild(Boolean resetIndex, Boolean optimizeOnComplete)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Sitecore.Reflection.ReflectionUtil.InvokeMethod(MethodInfo method, Object[] parameters, Object obj)
   at Sitecore.Jobs.JobRunner.RunMethod(JobArgs args)
   at (Object , Object )
   at Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args)
   at Sitecore.Pipelines.DefaultCorePipelineManager.Run(String pipelineName, PipelineArgs args, String pipelineDomain, Boolean failIfNotExists)
   at Sitecore.Pipelines.DefaultCorePipelineManager.Run(String pipelineName, PipelineArgs args, String pipelineDomain)
   at Sitecore.Jobs.Job.DoExecute()
   at Sitecore.Jobs.Job.ThreadEntry(Object state)

24.4.19

Insert Option

Sitecore's insert option in the content tree enables an author to create content for a field. This must be enabled to enable content editing.

23.4.19

Generating a Self-signed certificate for use with Sitecore using Powershell

A successful Sitecore Installation

PS C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration> Install-SitecoreConfiguration -Path 'sitecore-xp0.json'

cmdlet Install-SitecoreConfiguration at command pipeline position 1
Supply values for the following parameters:
(Type !? for Help.)
Package: Sitecore 9.0.0 rev. 171002 (OnPrem)_single.scwdp.zip
LicenseFile: license.xml
SqlDbPrefix: developer2
SolrCorePrefix: developer2
XConnectCert: 12345
Transcript started, output file is C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration\sitecore-xp0.190423 (13).log
                                                                                                    ************************************
                                                                                                         Sitecore Install Framework
                                                                                                               Version - 1.0.2
                                                                                                    ************************************


WorkingDirectory  : C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration
LogPath           : C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration\sitecore-xp0.190423 (13).log
WhatIf            : False
Verbose           : SilentlyContinue
Configuration     : C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration\sitecore-xp0.json
Debug             : SilentlyContinue
WarningAction     : Continue
ErrorAction       : Stop
InformationAction : Continue




[------------------------------------------------------------------------------------------------------- CreatePaths : EnsurePath --------------------------------------------------------------------------------------------------------]
[CreatePaths]:[Create] C:\inetpub\wwwroot\Sitecore

[----------------------------------------------------------------------------------------------------- CreateAppPool : AppPool -----------------------------------------------------------------------------------------------------------]
[CreateAppPool]:[Exists] Sitecore
[CreateAppPool]:[Setting] processModel.identityType => ApplicationPoolIdentity

[----------------------------------------------------------------------------------------------------- CreateWebsite : Website -----------------------------------------------------------------------------------------------------------]
[CreateWebsite]:[Exists] Sitecore
[CreateWebsite]:[Setting] applicationPool => Sitecore
[CreateWebsite]:[Setting] physicalPath => C:\inetpub\wwwroot\Sitecore

[------------------------------------------------------------------------------------------------------- StopWebsite : ManageWebsite -----------------------------------------------------------------------------------------------------]
[StopWebsite]:[Stop] Sitecore
WARNING: Website Sitecore is already Stopped

[------------------------------------------------------------------------------------------------------- StopAppPool : ManageAppPool -----------------------------------------------------------------------------------------------------]
[StopAppPool]:[Stop] Sitecore
WARNING: App Pool Sitecore is already Stopped

[---------------------------------------------------------------------------------------------------- CreateBindings : WebBinding --------------------------------------------------------------------------------------------------------]
[CreateBindings]:[Remove]
protocol bindingInformation sslFlags
-------- ------------------ --------
http     *:80:Sitecore             0



[CreateBindings]:[Add]
Name                           Value
----                           -----
HostHeader                     Sitecore




[-------------------------------------------------------------------------------------------------- CreateHostHeader : HostHeader --------------------------------------------------------------------------------------------------------]
[CreateHostHeader]:[Backup] Created - C:\WINDOWS\system32\drivers\etc\hosts.backup
[CreateHostHeader]:[Exists] 127.0.0.1 => Sitecore

[---------------------------------------------------------------------------------------------------- SetPermissions : FilePermissions ---------------------------------------------------------------------------------------------------]
[SetPermissions]:[Allow] IIS AppPool\Sitecore
[SetPermissions]:[Path] C:\inetpub\wwwroot\Sitecore
[SetPermissions]:[Rights] FullControl
[SetPermissions]:[Inherit] ContainerInherit ObjectInherit
[SetPermissions]:[Propagate] None

[------------------------------------------------------------------------------------------- SetCertStorePermissions : FilePermissions ---------------------------------------------------------------------------------------------------]
[SetCertStorePermissions]:[Allow] IIS AppPool\Sitecore
[SetCertStorePermissions]:[Path] C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys\c6683e207b624313e3b04a9a2ddc3d8d_68cc8dc7-90e3-40c4-8f2b-ee55b9f71246
[SetCertStorePermissions]:[Rights] Read
[SetCertStorePermissions]:[Inherit] None
[SetCertStorePermissions]:[Propagate] None

[-------------------------------------------------------------------------------------------------------- InstallWDP : WebDeploy ---------------------------------------------------------------------------------------------------------]
[WebDeploy]:[Path] C:\Program Files\iis\Microsoft Web Deploy V3\msdeploy.exe
Info: Adding sitemanifest (sitemanifest).
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Core;user id=sa)
Info: Initializing deployment: Pending.
Info: Analyzing deployment plan: Pending.
Info: Updating database: Pending.
Info: Creating deployment plan: Pending.
Info: Verifying deployment plan: Pending.
Info: Deploying package to database: Pending.
Info: Creating deployment plan: Running.
Info: Initializing deployment: Running.
Info: Initializing deployment (Start)
Info: Initializing deployment: Completed.
Info: Initializing deployment (Complete)
Info: Creating deployment plan: Completed.
Info: Verifying deployment plan: Running.
Info: Analyzing deployment plan: Running.
Info: Analyzing deployment plan (Start)
Info: Analyzing deployment plan: Completed.
Info: Analyzing deployment plan (Complete)
Info: Verifying deployment plan: Completed.
Info: Deploying package to database: Running.
Info: Updating database: Running.
Info: Updating database (Start)
Info: Creating developer2_Core...
Info: Creating [aspnet_Membership_BasicAccess]...
Info: Creating [aspnet_Membership_FullAccess]...
Info: Creating [aspnet_Membership_ReportingAccess]...
Info: Creating [aspnet_Personalization_BasicAccess]...
Info: Creating [aspnet_Personalization_FullAccess]...
Info: Creating [aspnet_Personalization_ReportingAccess]...
Info: Creating [aspnet_Profile_BasicAccess]...
Info: Creating [aspnet_Profile_FullAccess]...
Info: Creating [aspnet_Profile_ReportingAccess]...
Info: Creating [aspnet_Roles_BasicAccess]...
Info: Creating [aspnet_Roles_FullAccess]...
Info: Creating [aspnet_Roles_ReportingAccess]...
Info: Creating [aspnet_WebEvent_FullAccess]...
Info: Creating ...
Info: Creating ...
Info: Creating ...
Info: Creating ...
Info: Creating ...
Info: Creating ...
Info: Creating ...
Info: Creating ...
Info: Creating [aspnet_Membership_BasicAccess]...
Info: Creating [aspnet_Membership_FullAccess]...
Info: Creating [aspnet_Membership_ReportingAccess]...
Info: Creating [aspnet_Personalization_BasicAccess]...
Info: Creating [aspnet_Personalization_FullAccess]...
Info: Creating [aspnet_Personalization_ReportingAccess]...
Info: Creating [aspnet_Profile_BasicAccess]...
Info: Creating [aspnet_Profile_FullAccess]...
Info: Creating [aspnet_Profile_ReportingAccess]...
Info: Creating [aspnet_Roles_BasicAccess]...
Info: Creating [aspnet_Roles_FullAccess]...
Info: Creating [aspnet_Roles_ReportingAccess]...
Info: Creating [aspnet_WebEvent_FullAccess]...
Info: Creating [dbo].[AccessControl]...
Info: Creating [dbo].[AccessControl].[IX_AccessControl]...
Info: Creating [dbo].[Archive]...
Info: Creating [dbo].[Archive].[ndx_ItemId]...
Info: Creating [dbo].[ArchivedFields]...
Info: Creating [dbo].[ArchivedFields].[ndx_ArchivalId]...
Info: Creating [dbo].[ArchivedFields].[ndx_VersionId]...
Info: Creating [dbo].[ArchivedItems]...
Info: Creating [dbo].[ArchivedItems].[ndx_ArchivalId]...
Info: Creating [dbo].[ArchivedVersions]...
Info: Creating [dbo].[ArchivedVersions].[ndx_ItemId]...
Info: Creating [dbo].[aspnet_Applications]...
Info: Creating [dbo].[aspnet_Applications].[aspnet_Applications_Index]...
Info: Creating [dbo].[aspnet_Membership]...
Info: Creating [dbo].[aspnet_Membership].[aspnet_Membership_index]...
Info: Creating [dbo].[aspnet_Paths]...
Info: Creating [dbo].[aspnet_Paths].[aspnet_Paths_index]...
Info: Creating [dbo].[aspnet_PersonalizationAllUsers]...
Info: Creating [dbo].[aspnet_PersonalizationPerUser]...
Info: Creating [dbo].[aspnet_PersonalizationPerUser].[aspnet_PersonalizationPerUser_index1]...
Info: Creating [dbo].[aspnet_PersonalizationPerUser].[aspnet_PersonalizationPerUser_ncindex2]...
Info: Creating [dbo].[aspnet_Profile]...
Info: Creating [dbo].[aspnet_Roles]...
Info: Creating [dbo].[aspnet_Roles].[aspnet_Roles_index1]...
Info: Creating [dbo].[aspnet_SchemaVersions]...
Info: Creating [dbo].[aspnet_Users]...
Info: Creating [dbo].[aspnet_Users].[aspnet_Users_Index]...
Info: Creating [dbo].[aspnet_Users].[aspnet_Users_Index2]...
Info: Creating [dbo].[aspnet_UsersInRoles]...
Info: Creating [dbo].[aspnet_UsersInRoles].[aspnet_UsersInRoles_index]...
Info: Creating [dbo].[aspnet_WebEvent_Events]...
Info: Creating [dbo].[Blobs]...
Info: Creating [dbo].[Blobs].[ndxBlobId]...
Info: Creating [dbo].[ClientData]...
Info: Creating [dbo].[ClientData].[ndxID]...
Info: Creating [dbo].[ClientData].[ndxKey]...
Info: Creating [dbo].[Descendants]...
Info: Creating [dbo].[Descendants].[Descendant]...
Info: Creating [dbo].[EventQueue]...
Info: Creating [dbo].[EventQueue].[IX_Stamp]...
Info: Creating [dbo].[History]...
Info: Creating [dbo].[History].[ndxCreated]...
Info: Creating [dbo].[IDTable]...
Info: Creating [dbo].[IDTable].[ndxID]...
Info: Creating [dbo].[IDTable].[ndxPrefixKey]...
Info: Creating [dbo].[Items]...
Info: Creating [dbo].[Items].[ndxID]...
Info: Creating [dbo].[Items].[ndxName]...
Info: Creating [dbo].[Items].[ndxParentID]...
Info: Creating [dbo].[Items].[ndxTemplateID]...
Info: Creating [dbo].[Links]...
Info: Creating [dbo].[Links].[ndxID]...
Info: Creating [dbo].[Links].[ndxSourceItemID]...
Info: Creating [dbo].[Links].[ndxTargetItemID]...
Info: Creating [dbo].[Notifications]...
Info: Creating [dbo].[Properties]...
Info: Creating [dbo].[Properties].[ndxID]...
Info: Creating [dbo].[Properties].[ndxKey]...
Info: Creating [dbo].[PublishQueue]...
Info: Creating [dbo].[PublishQueue].[ndxDate]...
Info: Creating [dbo].[PublishQueue].[ndxID]...
Info: Creating [dbo].[RolesInRoles]...
Info: Creating [dbo].[RolesInRoles].[ndxMembers]...
Info: Creating [dbo].[RolesInRoles].[ndxTarget]...
Info: Creating [dbo].[SharedFields]...
Info: Creating [dbo].[SharedFields].[ndxUnique]...
Info: Creating [dbo].[Tasks]...
Info: Creating [dbo].[Tasks].[ndxID]...
Info: Creating [dbo].[UnversionedFields]...
Info: Creating [dbo].[UnversionedFields].[ndxUnique]...
Info: Creating [dbo].[UserLogins]...
Info: Creating [dbo].[UserLogins].[IX_UserId]...
Info: Creating [dbo].[VersionedFields]...
Info: Creating [dbo].[VersionedFields].[ndxUnique]...
Info: Creating [dbo].[WorkflowHistory]...
Info: Creating [dbo].[WorkflowHistory].[ndxID]...
Info: Creating [dbo].[WorkflowHistory].[ndxItemID]...
Info: Creating unnamed constraint on [dbo].[aspnet_Applications]...
Info: Creating unnamed constraint on [dbo].[aspnet_Membership]...
Info: Creating unnamed constraint on [dbo].[aspnet_Paths]...
Info: Creating unnamed constraint on [dbo].[aspnet_PersonalizationPerUser]...
Info: Creating unnamed constraint on [dbo].[aspnet_Roles]...
Info: Creating unnamed constraint on [dbo].[aspnet_Users]...
Info: Creating unnamed constraint on [dbo].[aspnet_Users]...
Info: Creating unnamed constraint on [dbo].[aspnet_Users]...
Info: Creating [dbo].[DF_Blobs_Id]...
Info: Creating [dbo].[DF_ClientData_ID]...
Info: Creating [dbo].[DF_EventQueue_Created]...
Info: Creating [dbo].[DF_History_AdditionalInfo]...
Info: Creating [dbo].[DF_History_Id]...
Info: Creating [dbo].[DF_History_ItemPath]...
Info: Creating [dbo].[DF_History_TaskStack]...
Info: Creating [dbo].[DF_IDTable_ID]...
Info: Creating [dbo].[DF_Links_ID]...
Info: Creating [dbo].[DF_Links_SourceLanguage]...
Info: Creating [dbo].[DF_Links_SourceVersion]...
Info: Creating [dbo].[DF_Links_TargetLanguage]...
Info: Creating [dbo].[DF_Links_TargetVersion]...
Info: Creating [dbo].[DF_Properties_ID]...
Info: Creating [dbo].[DF_PublishQueue_Action]...
Info: Creating [dbo].[DF_PublishQueue_ID]...
Info: Creating [dbo].[DF_PublishQueue_Language]...
Info: Creating [dbo].[DF_PublishQueue_Version]...
Info: Creating [dbo].[DF_RolesInRoles_Id]...
Info: Creating [dbo].[DF_SharedFields_Id]...
Info: Creating [dbo].[DF_UnversionedFields_Id]...
Info: Creating [dbo].[DF_VersionedFields_Id]...
Info: Creating [dbo].[DF_WorkflowHistory_ID]...
Info: Creating [dbo].[FK_dbo.UserLogins_dbo.aspnet_Users_UserId]...
Info: Creating [dbo].[Fields]...
Info: Creating [dbo].[vw_aspnet_Applications]...
Info: Creating [dbo].[vw_aspnet_MembershipUsers]...
Info: Creating [dbo].[vw_aspnet_Profiles]...
Info: Creating [dbo].[vw_aspnet_Roles]...
Info: Creating [dbo].[vw_aspnet_Users]...
Info: Creating [dbo].[vw_aspnet_UsersInRoles]...
Info: Creating [dbo].[vw_aspnet_WebPartState_Paths]...
Info: Creating [dbo].[vw_aspnet_WebPartState_Shared]...
Info: Creating [dbo].[vw_aspnet_WebPartState_User]...
Info: Creating [dbo].[aspnet_AnyDataInTables]...
Info: Creating [dbo].[aspnet_Applications_CreateApplication]...
Info: Creating [dbo].[aspnet_CheckSchemaVersion]...
Info: Creating [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]...
Info: Creating [dbo].[aspnet_Membership_FindUsersByEmail]...
Info: Creating [dbo].[aspnet_Membership_FindUsersByName]...
Info: Creating [dbo].[aspnet_Membership_GetAllUsers]...
Info: Creating [dbo].[aspnet_Membership_GetNumberOfUsersOnline]...
Info: Creating [dbo].[aspnet_Membership_GetPassword]...
Info: Creating [dbo].[aspnet_Membership_GetPasswordWithFormat]...
Info: Creating [dbo].[aspnet_Membership_GetUserByEmail]...
Info: Creating [dbo].[aspnet_Membership_GetUserByName]...
Info: Creating [dbo].[aspnet_Membership_GetUserByUserId]...
Info: Creating [dbo].[aspnet_Membership_ResetPassword]...
Info: Creating [dbo].[aspnet_Membership_SetPassword]...
Info: Creating [dbo].[aspnet_Membership_UnlockUser]...
Info: Creating [dbo].[aspnet_Membership_UpdateUser]...
Info: Creating [dbo].[aspnet_Membership_UpdateUserInfo]...
Info: Creating [dbo].[aspnet_Paths_CreatePath]...
Info: Creating [dbo].[aspnet_Personalization_GetApplicationId]...
Info: Creating [dbo].[aspnet_PersonalizationAdministration_DeleteAllState]...
Info: Creating [dbo].[aspnet_PersonalizationAdministration_FindState]...
Info: Creating [dbo].[aspnet_PersonalizationAdministration_GetCountOfState]...
Info: Creating [dbo].[aspnet_PersonalizationAdministration_ResetSharedState]...
Info: Creating [dbo].[aspnet_PersonalizationAdministration_ResetUserState]...
Info: Creating [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]...
Info: Creating [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]...
Info: Creating [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]...
Info: Creating [dbo].[aspnet_PersonalizationPerUser_GetPageSettings]...
Info: Creating [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]...
Info: Creating [dbo].[aspnet_Profile_DeleteInactiveProfiles]...
Info: Creating [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]...
Info: Creating [dbo].[aspnet_Profile_GetProfiles]...
Info: Creating [dbo].[aspnet_Profile_GetProperties]...
Info: Creating [dbo].[aspnet_RegisterSchemaVersion]...
Info: Creating [dbo].[aspnet_Roles_CreateRole]...
Info: Creating [dbo].[aspnet_Roles_DeleteRole]...
Info: Creating [dbo].[aspnet_Roles_GetAllRoles]...
Info: Creating [dbo].[aspnet_Roles_RoleExists]...
Info: Creating [dbo].[aspnet_Setup_RemoveAllRoleMembers]...
Info: Creating [dbo].[aspnet_Setup_RestorePermissions]...
Info: Creating [dbo].[aspnet_UnRegisterSchemaVersion]...
Info: Creating [dbo].[aspnet_Users_CreateUser]...
Info: Creating [dbo].[aspnet_Users_DeleteUser]...
Info: Creating [dbo].[aspnet_UsersInRoles_AddUsersToRoles]...
Info: Creating [dbo].[aspnet_UsersInRoles_FindUsersInRole]...
Info: Creating [dbo].[aspnet_UsersInRoles_GetRolesForUser]...
Info: Creating [dbo].[aspnet_UsersInRoles_GetUsersInRoles]...
Info: Creating [dbo].[aspnet_UsersInRoles_IsUserInRole]...
Info: Creating [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]...
Info: Creating [dbo].[aspnet_WebEvent_LogEvent]...
Info: Creating [dbo].[aspnet_Membership_CreateUser]...
Info: Creating [dbo].[aspnet_PersonalizationPerUser_SetPageSettings]...
Info: Creating [dbo].[aspnet_Profile_DeleteProfiles]...
Info: Creating [dbo].[aspnet_Profile_SetProperties]...
Info: The transacted portion of the database update succeeded.
Info: Update complete.
Info: Importing data: Pending.
Info: Importing data
Info: Importing data: Running.
Info: Processing Table '[dbo].[aspnet_Applications]'.: Pending.
Info: Processing Table '[dbo].[aspnet_Membership]'.: Pending.
Info: Processing Table '[dbo].[aspnet_Profile]'.: Pending.
Info: Processing Table '[dbo].[aspnet_Roles]'.: Pending.
Info: Processing Table '[dbo].[aspnet_Users]'.: Pending.
Info: Processing Table '[dbo].[Descendants]'.: Pending.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'.: Pending.
Info: Processing Table '[dbo].[Items]'.: Pending.
Info: Processing Table '[dbo].[RolesInRoles]'.: Pending.
Info: Processing Table '[dbo].[Blobs]'.: Pending.
Info: Processing Table '[dbo].[SharedFields]'.: Pending.
Info: Processing Table '[dbo].[VersionedFields]'.: Pending.
Info: Processing Table '[dbo].[Links]'.: Pending.
Info: Processing Table '[dbo].[UnversionedFields]'.: Pending.
Info: Processing Import.: Running.
Info: Disabling indexes.: Pending.
Info: Disabling indexes.: Running.
Info: Disabling indexes. (Start)
Info: Disabling index 'PK__aspnet_A__C93A4C98A5B789BB'.: Pending.
Info: Disabling index 'PK__aspnet_A__C93A4C98A5B789BB'.: Running.
Info: Disabling index 'PK__aspnet_A__C93A4C98A5B789BB'. (Start)
Info: Disabling index 'PK__aspnet_A__C93A4C98A5B789BB'.: Completed.
Info: Disabling index 'PK__aspnet_A__C93A4C98A5B789BB'. (Complete)
Info: Disabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'.: Pending.
Info: Disabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'.: Running.
Info: Disabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'. (Start)
Info: Disabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'.: Completed.
Info: Disabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'. (Complete)
Info: Disabling index 'UQ__aspnet_A__30910331BF55B7C6'.: Pending.
Info: Disabling index 'UQ__aspnet_A__30910331BF55B7C6'.: Running.
Info: Disabling index 'UQ__aspnet_A__30910331BF55B7C6'. (Start)
Info: Disabling index 'UQ__aspnet_A__30910331BF55B7C6'.: Completed.
Info: Disabling index 'UQ__aspnet_A__30910331BF55B7C6'. (Complete)
Info: Disabling index 'PK__aspnet_M__1788CC4DB2A38A53'.: Pending.
Info: Disabling index 'PK__aspnet_M__1788CC4DB2A38A53'.: Running.
Info: Disabling index 'PK__aspnet_M__1788CC4DB2A38A53'. (Start)
Info: Disabling index 'PK__aspnet_M__1788CC4DB2A38A53'.: Completed.
Info: Disabling index 'PK__aspnet_M__1788CC4DB2A38A53'. (Complete)
Info: Disabling index 'PK__aspnet_R__8AFACE1B58607B3B'.: Pending.
Info: Disabling index 'PK__aspnet_R__8AFACE1B58607B3B'.: Running.
Info: Disabling index 'PK__aspnet_R__8AFACE1B58607B3B'. (Start)
Info: Disabling index 'PK__aspnet_R__8AFACE1B58607B3B'.: Completed.
Info: Disabling index 'PK__aspnet_R__8AFACE1B58607B3B'. (Complete)
Info: Disabling index 'aspnet_Users_Index2'.: Pending.
Info: Disabling index 'aspnet_Users_Index2'.: Running.
Info: Disabling index 'aspnet_Users_Index2'. (Start)
Info: Disabling index 'aspnet_Users_Index2'.: Completed.
Info: Disabling index 'aspnet_Users_Index2'. (Complete)
Info: Disabling index 'ndxBlobId'.: Pending.
Info: Disabling index 'ndxBlobId'.: Running.
Info: Disabling index 'ndxBlobId'. (Start)
Info: Disabling index 'ndxBlobId'.: Completed.
Info: Disabling index 'ndxBlobId'. (Complete)
Info: Disabling index 'Descendant'.: Pending.
Info: Disabling index 'Descendant'.: Running.
Info: Disabling index 'Descendant'. (Start)
Info: Disabling index 'Descendant'.: Completed.
Info: Disabling index 'Descendant'. (Complete)
Info: Disabling index 'Descendants_PK'.: Pending.
Info: Disabling index 'Descendants_PK'.: Running.
Info: Disabling index 'Descendants_PK'. (Start)
Info: Disabling index 'Descendants_PK'.: Completed.
Info: Disabling index 'Descendants_PK'. (Complete)
Info: Disabling index 'ndxID'.: Pending.
Info: Disabling index 'ndxID'.: Running.
Info: Disabling index 'ndxID'. (Start)
Info: Disabling index 'ndxID'.: Completed.
Info: Disabling index 'ndxID'. (Complete)
Info: Disabling index 'ndxName'.: Pending.
Info: Disabling index 'ndxName'.: Running.
Info: Disabling index 'ndxName'. (Start)
Info: Disabling index 'ndxName'.: Completed.
Info: Disabling index 'ndxName'. (Complete)
Info: Disabling index 'ndxParentID'.: Pending.
Info: Disabling index 'ndxParentID'.: Running.
Info: Disabling index 'ndxParentID'. (Start)
Info: Disabling index 'ndxParentID'.: Completed.
Info: Disabling index 'ndxParentID'. (Complete)
Info: Disabling index 'ndxTemplateID'.: Pending.
Info: Disabling index 'ndxTemplateID'.: Running.
Info: Disabling index 'ndxTemplateID'. (Start)
Info: Disabling index 'ndxTemplateID'.: Completed.
Info: Disabling index 'ndxTemplateID'. (Complete)
Info: Disabling index 'ndxID'.: Pending.
Info: Disabling index 'ndxID'.: Running.
Info: Disabling index 'ndxID'. (Start)
Info: Disabling index 'ndxID'.: Completed.
Info: Disabling index 'ndxID'. (Complete)
Info: Disabling index 'ndxSourceItemID'.: Pending.
Info: Disabling index 'ndxSourceItemID'.: Running.
Info: Disabling index 'ndxSourceItemID'. (Start)
Info: Disabling index 'ndxSourceItemID'.: Completed.
Info: Disabling index 'ndxSourceItemID'. (Complete)
Info: Disabling index 'ndxTargetItemID'.: Pending.
Info: Disabling index 'ndxTargetItemID'.: Running.
Info: Disabling index 'ndxTargetItemID'. (Start)
Info: Disabling index 'ndxTargetItemID'.: Completed.
Info: Disabling index 'ndxTargetItemID'. (Complete)
Info: Disabling index 'ndxMembers'.: Pending.
Info: Disabling index 'ndxMembers'.: Running.
Info: Disabling index 'ndxMembers'. (Start)
Info: Disabling index 'ndxMembers'.: Completed.
Info: Disabling index 'ndxMembers'. (Complete)
Info: Disabling index 'ndxTarget'.: Pending.
Info: Disabling index 'ndxTarget'.: Running.
Info: Disabling index 'ndxTarget'. (Start)
Info: Disabling index 'ndxTarget'.: Completed.
Info: Disabling index 'ndxTarget'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling indexes.: Completed.
Info: Disabling indexes. (Complete)
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[aspnet_Applications]'.: Running.
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[aspnet_Membership]'.: Running.
Info: Processing Table '[dbo].[aspnet_Applications]'. 100.00% done.
Info: Processing Table '[dbo].[aspnet_Applications]'.: Completed.
Info: Processing Table '[dbo].[aspnet_Membership]'. 100.00% done.
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[aspnet_Membership]'.: Completed.
Info: Processing Table '[dbo].[aspnet_Profile]'.: Running.
Info: Processing Table '[dbo].[aspnet_Profile]'. 35.81% done.
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[aspnet_Profile]'. 51.44% done.
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[aspnet_Profile]'. 84.37% done.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_Profile]'. 100.00% done.
Info: Processing Table '[dbo].[aspnet_Profile]'.: Completed.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_Roles]'.: Running.
Info: Processing Table '[dbo].[aspnet_Roles]'. 100.00% done.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_Roles]'.: Completed.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'.: Running.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'. 34.07% done.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'. 49.45% done.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'. 70.33% done.
Info: Processing Import. 0.01% done.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'. 82.42% done.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'. 100.00% done.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[aspnet_SchemaVersions]'.: Completed.
Info: Processing Table '[dbo].[aspnet_Users]'.: Running.
Info: Processing Table '[dbo].[aspnet_Users]'. 100.00% done.
Info: Processing Table '[dbo].[aspnet_Users]'.: Completed.
Info: Processing Import. 0.01% done.
Info: Processing Table '[dbo].[Blobs]'.: Running.
Info: Processing Import. 0.05% done.
Info: Processing Table '[dbo].[Blobs]'. 100.00% done.
Info: Processing Table '[dbo].[Blobs]'.: Completed.
Info: Processing Table '[dbo].[Descendants]'.: Running.
Info: Processing Table '[dbo].[Descendants]'. 79.70% done.
Info: Processing Import. 6.08% done.
Info: Processing Import. 7.61% done.
Info: Processing Table '[dbo].[Descendants]'. 100.00% done.
Info: Processing Table '[dbo].[Descendants]'.: Completed.
Info: Processing Table '[dbo].[Items]'.: Running.
Info: Processing Table '[dbo].[Items]'. 100.00% done.
Info: Processing Table '[dbo].[Items]'.: Completed.
Info: Processing Import. 9.99% done.
Info: Processing Table '[dbo].[Links]'.: Running.
Info: Processing Table '[dbo].[Links]'. 58.42% done.
Info: Processing Import. 17.56% done.
Info: Processing Table '[dbo].[Links]'. 100.00% done.
Info: Processing Import. 22.94% done.
Info: Processing Table '[dbo].[Links]'.: Completed.
Info: Processing Table '[dbo].[RolesInRoles]'.: Running.
Info: Processing Table '[dbo].[RolesInRoles]'. 100.00% done.
Info: Processing Import. 22.95% done.
Info: Processing Table '[dbo].[RolesInRoles]'.: Completed.
Info: Processing Table '[dbo].[SharedFields]'.: Running.
Info: Processing Import. 23.60% done.
Info: Processing Table '[dbo].[SharedFields]'. 7.96% done.
Info: Processing Import. 31.17% done.
Info: Processing Table '[dbo].[SharedFields]'. 100.00% done.
Info: Processing Table '[dbo].[SharedFields]'.: Completed.
Info: Processing Table '[dbo].[UnversionedFields]'.: Running.
Info: Processing Table '[dbo].[UnversionedFields]'. 10.22% done.
Info: Processing Import. 32.03% done.
Info: Processing Import. 39.59% done.
Info: Processing Table '[dbo].[UnversionedFields]'. 100.00% done.
Info: Processing Table '[dbo].[UnversionedFields]'.: Completed.
Info: Processing Table '[dbo].[VersionedFields]'.: Running.
Info: Processing Import. 47.16% done.
Info: Processing Table '[dbo].[VersionedFields]'. 12.52% done.
Info: Processing Table '[dbo].[VersionedFields]'. 25.04% done.
Info: Processing Import. 54.72% done.
Info: Processing Table '[dbo].[VersionedFields]'. 37.57% done.
Info: Processing Import. 62.28% done.
Info: Processing Import. 69.85% done.
Info: Processing Table '[dbo].[VersionedFields]'. 50.09% done.
Info: Processing Import. 77.41% done.
Info: Processing Table '[dbo].[VersionedFields]'. 62.61% done.
Info: Processing Import. 84.98% done.
Info: Processing Table '[dbo].[VersionedFields]'. 75.13% done.
Info: Processing Import. 92.44% done.
Info: Processing Table '[dbo].[VersionedFields]'. 87.48% done.
Info: Processing Import. 100.00% done.
Info: Processing Table '[dbo].[VersionedFields]'. 100.00% done.
Info: Processing Table '[dbo].[VersionedFields]'.: Completed.
Info: Enabling indexes.: Pending.
Info: Enabling indexes.: Running.
Info: Enabling indexes. (Start)
Info: Enabling index 'PK__aspnet_A__C93A4C98A5B789BB'.: Pending.
Info: Enabling index 'PK__aspnet_A__C93A4C98A5B789BB'.: Running.
Info: Enabling index 'PK__aspnet_A__C93A4C98A5B789BB'. (Start)
Info: Enabling index 'PK__aspnet_A__C93A4C98A5B789BB'.: Completed.
Info: Enabling index 'PK__aspnet_A__C93A4C98A5B789BB'. (Complete)
Info: Enabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'.: Pending.
Info: Enabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'.: Running.
Info: Enabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'. (Start)
Info: Enabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'.: Completed.
Info: Enabling index 'UQ__aspnet_A__17477DE4FE4CFAA9'. (Complete)
Info: Enabling index 'UQ__aspnet_A__30910331BF55B7C6'.: Pending.
Info: Enabling index 'UQ__aspnet_A__30910331BF55B7C6'.: Running.
Info: Enabling index 'UQ__aspnet_A__30910331BF55B7C6'. (Start)
Info: Enabling index 'UQ__aspnet_A__30910331BF55B7C6'.: Completed.
Info: Enabling index 'UQ__aspnet_A__30910331BF55B7C6'. (Complete)
Info: Enabling index 'PK__aspnet_M__1788CC4DB2A38A53'.: Pending.
Info: Enabling index 'PK__aspnet_M__1788CC4DB2A38A53'.: Running.
Info: Enabling index 'PK__aspnet_M__1788CC4DB2A38A53'. (Start)
Info: Enabling index 'PK__aspnet_M__1788CC4DB2A38A53'.: Completed.
Info: Enabling index 'PK__aspnet_M__1788CC4DB2A38A53'. (Complete)
Info: Enabling index 'PK__aspnet_R__8AFACE1B58607B3B'.: Pending.
Info: Enabling index 'PK__aspnet_R__8AFACE1B58607B3B'.: Running.
Info: Enabling index 'PK__aspnet_R__8AFACE1B58607B3B'. (Start)
Info: Enabling index 'PK__aspnet_R__8AFACE1B58607B3B'.: Completed.
Info: Enabling index 'PK__aspnet_R__8AFACE1B58607B3B'. (Complete)
Info: Enabling index 'aspnet_Users_Index2'.: Pending.
Info: Enabling index 'aspnet_Users_Index2'.: Running.
Info: Enabling index 'aspnet_Users_Index2'. (Start)
Info: Enabling index 'aspnet_Users_Index2'.: Completed.
Info: Enabling index 'aspnet_Users_Index2'. (Complete)
Info: Enabling index 'ndxBlobId'.: Pending.
Info: Enabling index 'ndxBlobId'.: Running.
Info: Enabling index 'ndxBlobId'. (Start)
Info: Enabling index 'ndxBlobId'.: Completed.
Info: Enabling index 'ndxBlobId'. (Complete)
Info: Enabling index 'Descendant'.: Pending.
Info: Enabling index 'Descendant'.: Running.
Info: Enabling index 'Descendant'. (Start)
Info: Enabling index 'Descendant'.: Completed.
Info: Enabling index 'Descendant'. (Complete)
Info: Enabling index 'Descendants_PK'.: Pending.
Info: Enabling index 'Descendants_PK'.: Running.
Info: Enabling index 'Descendants_PK'. (Start)
Info: Enabling index 'Descendants_PK'.: Completed.
Info: Enabling index 'Descendants_PK'. (Complete)
Info: Enabling index 'ndxID'.: Pending.
Info: Enabling index 'ndxID'.: Running.
Info: Enabling index 'ndxID'. (Start)
Info: Enabling index 'ndxID'.: Completed.
Info: Enabling index 'ndxID'. (Complete)
Info: Enabling index 'ndxName'.: Pending.
Info: Enabling index 'ndxName'.: Running.
Info: Enabling index 'ndxName'. (Start)
Info: Enabling index 'ndxName'.: Completed.
Info: Enabling index 'ndxName'. (Complete)
Info: Enabling index 'ndxParentID'.: Pending.
Info: Enabling index 'ndxParentID'.: Running.
Info: Enabling index 'ndxParentID'. (Start)
Info: Enabling index 'ndxParentID'.: Completed.
Info: Enabling index 'ndxParentID'. (Complete)
Info: Enabling index 'ndxTemplateID'.: Pending.
Info: Enabling index 'ndxTemplateID'.: Running.
Info: Enabling index 'ndxTemplateID'. (Start)
Info: Enabling index 'ndxTemplateID'.: Completed.
Info: Enabling index 'ndxTemplateID'. (Complete)
Info: Enabling index 'ndxID'.: Pending.
Info: Enabling index 'ndxID'.: Running.
Info: Enabling index 'ndxID'. (Start)
Info: Enabling index 'ndxID'.: Completed.
Info: Enabling index 'ndxID'. (Complete)
Info: Enabling index 'ndxSourceItemID'.: Pending.
Info: Enabling index 'ndxSourceItemID'.: Running.
Info: Enabling index 'ndxSourceItemID'. (Start)
Info: Enabling index 'ndxSourceItemID'.: Completed.
Info: Enabling index 'ndxSourceItemID'. (Complete)
Info: Enabling index 'ndxTargetItemID'.: Pending.
Info: Enabling index 'ndxTargetItemID'.: Running.
Info: Enabling index 'ndxTargetItemID'. (Start)
Info: Enabling index 'ndxTargetItemID'.: Completed.
Info: Enabling index 'ndxTargetItemID'. (Complete)
Info: Enabling index 'ndxMembers'.: Pending.
Info: Enabling index 'ndxMembers'.: Running.
Info: Enabling index 'ndxMembers'. (Start)
Info: Enabling index 'ndxMembers'.: Completed.
Info: Enabling index 'ndxMembers'. (Complete)
Info: Enabling index 'ndxTarget'.: Pending.
Info: Enabling index 'ndxTarget'.: Running.
Info: Enabling index 'ndxTarget'. (Start)
Info: Enabling index 'ndxTarget'.: Completed.
Info: Enabling index 'ndxTarget'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling indexes.: Completed.
Info: Enabling indexes. (Complete)
Info: Processing Import.: Completed.
Info: Importing data: Completed.
Info: Importing data
Info: Updating database: Completed.
Info: Updating database (Complete)
Info: Deploying package to database: Completed.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Core;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_Core;user id=sa']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLExpress;initial catalog=developer2_Core;user id=sa;pooling=False'. The 'transacted' setting for this connection is 'False'.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Core;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_Core;user id=sa']/sqlScript)
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Master;user id=sa)
Info: Initializing deployment: Pending.
Info: Analyzing deployment plan: Pending.
Info: Updating database: Pending.
Info: Creating deployment plan: Pending.
Info: Verifying deployment plan: Pending.
Info: Deploying package to database: Pending.
Info: Creating deployment plan: Running.
Info: Initializing deployment: Running.
Info: Initializing deployment (Start)
Info: Initializing deployment: Completed.
Info: Initializing deployment (Complete)
Info: Creating deployment plan: Completed.
Info: Verifying deployment plan: Running.
Info: Analyzing deployment plan: Running.
Info: Analyzing deployment plan (Start)
Info: Analyzing deployment plan: Completed.
Info: Analyzing deployment plan (Complete)
Info: Verifying deployment plan: Completed.
Info: Deploying package to database: Running.
Info: Updating database: Running.
Info: Updating database (Start)
Info: Creating developer2_Master...
Info: Creating [dbo].[AccessControl]...
Info: Creating [dbo].[AccessControl].[IX_AccessControl]...
Info: Creating [dbo].[Archive]...
Info: Creating [dbo].[Archive].[ndx_ItemId]...
Info: Creating [dbo].[ArchivedFields]...
Info: Creating [dbo].[ArchivedFields].[ndx_ArchivalId]...
Info: Creating [dbo].[ArchivedFields].[ndx_VersionId]...
Info: Creating [dbo].[ArchivedItems]...
Info: Creating [dbo].[ArchivedItems].[ndx_ArchivalId]...
Info: Creating [dbo].[ArchivedVersions]...
Info: Creating [dbo].[ArchivedVersions].[ndx_ItemId]...
Info: Creating [dbo].[Blobs]...
Info: Creating [dbo].[Blobs].[ndxBlobId]...
Info: Creating [dbo].[ClientData]...
Info: Creating [dbo].[ClientData].[ndxID]...
Info: Creating [dbo].[ClientData].[ndxKey]...
Info: Creating [dbo].[Descendants]...
Info: Creating [dbo].[Descendants].[Descendant]...
Info: Creating [dbo].[EventQueue]...
Info: Creating [dbo].[EventQueue].[IX_Stamp]...
Info: Creating [dbo].[History]...
Info: Creating [dbo].[History].[ndxCreated]...
Info: Creating [dbo].[IDTable]...
Info: Creating [dbo].[IDTable].[ndxID]...
Info: Creating [dbo].[IDTable].[ndxPrefixKey]...
Info: Creating [dbo].[Items]...
Info: Creating [dbo].[Items].[ndxID]...
Info: Creating [dbo].[Items].[ndxName]...
Info: Creating [dbo].[Items].[ndxParentID]...
Info: Creating [dbo].[Items].[ndxTemplateID]...
Info: Creating [dbo].[Links]...
Info: Creating [dbo].[Links].[ndxID]...
Info: Creating [dbo].[Links].[ndxSourceItemID]...
Info: Creating [dbo].[Links].[ndxTargetItemID]...
Info: Creating [dbo].[Notifications]...
Info: Creating [dbo].[Properties]...
Info: Creating [dbo].[Properties].[ndxID]...
Info: Creating [dbo].[Properties].[ndxKey]...
Info: Creating [dbo].[PublishQueue]...
Info: Creating [dbo].[PublishQueue].[ndxDate]...
Info: Creating [dbo].[PublishQueue].[ndxID]...
Info: Creating [dbo].[SharedFields]...
Info: Creating [dbo].[SharedFields].[ndxUnique]...
Info: Creating [dbo].[Tasks]...
Info: Creating [dbo].[Tasks].[ndxID]...
Info: Creating [dbo].[UnversionedFields]...
Info: Creating [dbo].[UnversionedFields].[ndxUnique]...
Info: Creating [dbo].[VersionedFields]...
Info: Creating [dbo].[VersionedFields].[ndxUnique]...
Info: Creating [dbo].[WorkflowHistory]...
Info: Creating [dbo].[WorkflowHistory].[ndxID]...
Info: Creating [dbo].[WorkflowHistory].[ndxItemID]...
Info: Creating [dbo].[DF_Blobs_Id]...
Info: Creating [dbo].[DF_ClientData_ID]...
Info: Creating [dbo].[DF_EventQueue_Created]...
Info: Creating [dbo].[DF_History_AdditionalInfo]...
Info: Creating [dbo].[DF_History_Id]...
Info: Creating [dbo].[DF_History_ItemPath]...
Info: Creating [dbo].[DF_History_TaskStack]...
Info: Creating [dbo].[DF_IDTable_ID]...
Info: Creating [dbo].[DF_Links_ID]...
Info: Creating [dbo].[DF_Links_SourceLanguage]...
Info: Creating [dbo].[DF_Links_SourceVersion]...
Info: Creating [dbo].[DF_Links_TargetLanguage]...
Info: Creating [dbo].[DF_Links_TargetVersion]...
Info: Creating [dbo].[DF_Properties_ID]...
Info: Creating [dbo].[DF_PublishQueue_Action]...
Info: Creating [dbo].[DF_PublishQueue_ID]...
Info: Creating [dbo].[DF_PublishQueue_Language]...
Info: Creating [dbo].[DF_PublishQueue_Version]...
Info: Creating [dbo].[DF_SharedFields_Id]...
Info: Creating [dbo].[DF_UnversionedFields_Id]...
Info: Creating [dbo].[DF_VersionedFields_Id]...
Info: Creating [dbo].[DF_WorkflowHistory_ID]...
Info: Creating [dbo].[Fields]...
Info: The transacted portion of the database update succeeded.
Info: Update complete.
Info: Importing data: Pending.
Info: Importing data
Info: Importing data: Running.
Info: Processing Table '[dbo].[Blobs]'.: Pending.
Info: Processing Table '[dbo].[Descendants]'.: Pending.
Info: Processing Table '[dbo].[SharedFields]'.: Pending.
Info: Processing Table '[dbo].[Items]'.: Pending.
Info: Processing Table '[dbo].[UnversionedFields]'.: Pending.
Info: Processing Table '[dbo].[VersionedFields]'.: Pending.
Info: Processing Import.: Running.
Info: Disabling indexes.: Pending.
Info: Disabling indexes.: Running.
Info: Disabling indexes. (Start)
Info: Disabling index 'ndxBlobId'.: Pending.
Info: Disabling index 'ndxBlobId'.: Running.
Info: Disabling index 'ndxBlobId'. (Start)
Info: Disabling index 'ndxBlobId'.: Completed.
Info: Disabling index 'ndxBlobId'. (Complete)
Info: Disabling index 'Descendant'.: Pending.
Info: Disabling index 'Descendant'.: Running.
Info: Disabling index 'Descendant'. (Start)
Info: Disabling index 'Descendant'.: Completed.
Info: Disabling index 'Descendant'. (Complete)
Info: Disabling index 'Descendants_PK'.: Pending.
Info: Disabling index 'Descendants_PK'.: Running.
Info: Disabling index 'Descendants_PK'. (Start)
Info: Disabling index 'Descendants_PK'.: Completed.
Info: Disabling index 'Descendants_PK'. (Complete)
Info: Disabling index 'ndxID'.: Pending.
Info: Disabling index 'ndxID'.: Running.
Info: Disabling index 'ndxID'. (Start)
Info: Disabling index 'ndxID'.: Completed.
Info: Disabling index 'ndxID'. (Complete)
Info: Disabling index 'ndxName'.: Pending.
Info: Disabling index 'ndxName'.: Running.
Info: Disabling index 'ndxName'. (Start)
Info: Disabling index 'ndxName'.: Completed.
Info: Disabling index 'ndxName'. (Complete)
Info: Disabling index 'ndxParentID'.: Pending.
Info: Disabling index 'ndxParentID'.: Running.
Info: Disabling index 'ndxParentID'. (Start)
Info: Disabling index 'ndxParentID'.: Completed.
Info: Disabling index 'ndxParentID'. (Complete)
Info: Disabling index 'ndxTemplateID'.: Pending.
Info: Disabling index 'ndxTemplateID'.: Running.
Info: Disabling index 'ndxTemplateID'. (Start)
Info: Disabling index 'ndxTemplateID'.: Completed.
Info: Disabling index 'ndxTemplateID'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling indexes.: Completed.
Info: Disabling indexes. (Complete)
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[Blobs]'.: Running.
Info: Processing Import. 9.12% done.
Info: Processing Table '[dbo].[Blobs]'. 100.00% done.
Info: Processing Table '[dbo].[Blobs]'.: Completed.
Info: Processing Table '[dbo].[Descendants]'.: Running.
Info: Processing Table '[dbo].[Descendants]'. 100.00% done.
Info: Processing Import. 16.58% done.
Info: Processing Table '[dbo].[Descendants]'.: Completed.
Info: Processing Table '[dbo].[Items]'.: Running.
Info: Processing Table '[dbo].[Items]'. 100.00% done.
Info: Processing Import. 18.95% done.
Info: Processing Table '[dbo].[Items]'.: Completed.
Info: Processing Table '[dbo].[SharedFields]'.: Running.
Info: Processing Table '[dbo].[SharedFields]'. 100.00% done.
Info: Processing Table '[dbo].[SharedFields]'.: Completed.
Info: Processing Import. 25.42% done.
Info: Processing Table '[dbo].[UnversionedFields]'.: Running.
Info: Processing Table '[dbo].[UnversionedFields]'. 100.00% done.
Info: Processing Import. 34.74% done.
Info: Processing Table '[dbo].[UnversionedFields]'.: Completed.
Info: Processing Table '[dbo].[VersionedFields]'.: Running.
Info: Processing Import. 72.29% done.
Info: Processing Table '[dbo].[VersionedFields]'. 57.54% done.
Info: Processing Table '[dbo].[VersionedFields]'. 100.00% done.
Info: Processing Import. 100.00% done.
Info: Processing Table '[dbo].[VersionedFields]'.: Completed.
Info: Enabling indexes.: Pending.
Info: Enabling indexes.: Running.
Info: Enabling indexes. (Start)
Info: Enabling index 'ndxBlobId'.: Pending.
Info: Enabling index 'ndxBlobId'.: Running.
Info: Enabling index 'ndxBlobId'. (Start)
Info: Enabling index 'ndxBlobId'.: Completed.
Info: Enabling index 'ndxBlobId'. (Complete)
Info: Enabling index 'Descendant'.: Pending.
Info: Enabling index 'Descendant'.: Running.
Info: Enabling index 'Descendant'. (Start)
Info: Enabling index 'Descendant'.: Completed.
Info: Enabling index 'Descendant'. (Complete)
Info: Enabling index 'Descendants_PK'.: Pending.
Info: Enabling index 'Descendants_PK'.: Running.
Info: Enabling index 'Descendants_PK'. (Start)
Info: Enabling index 'Descendants_PK'.: Completed.
Info: Enabling index 'Descendants_PK'. (Complete)
Info: Enabling index 'ndxID'.: Pending.
Info: Enabling index 'ndxID'.: Running.
Info: Enabling index 'ndxID'. (Start)
Info: Enabling index 'ndxID'.: Completed.
Info: Enabling index 'ndxID'. (Complete)
Info: Enabling index 'ndxName'.: Pending.
Info: Enabling index 'ndxName'.: Running.
Info: Enabling index 'ndxName'. (Start)
Info: Enabling index 'ndxName'.: Completed.
Info: Enabling index 'ndxName'. (Complete)
Info: Enabling index 'ndxParentID'.: Pending.
Info: Enabling index 'ndxParentID'.: Running.
Info: Enabling index 'ndxParentID'. (Start)
Info: Enabling index 'ndxParentID'.: Completed.
Info: Enabling index 'ndxParentID'. (Complete)
Info: Enabling index 'ndxTemplateID'.: Pending.
Info: Enabling index 'ndxTemplateID'.: Running.
Info: Enabling index 'ndxTemplateID'. (Start)
Info: Enabling index 'ndxTemplateID'.: Completed.
Info: Enabling index 'ndxTemplateID'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling indexes.: Completed.
Info: Enabling indexes. (Complete)
Info: Processing Import.: Completed.
Info: Importing data: Completed.
Info: Importing data
Info: Updating database: Completed.
Info: Updating database (Complete)
Info: Deploying package to database: Completed.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Master;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_Master;user id=sa']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLExpress;initial catalog=developer2_Master;user id=sa;pooling=False'. The 'transacted' setting for this connection is 'False'.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Web;user id=sa)
Info: Initializing deployment: Pending.
Info: Analyzing deployment plan: Pending.
Info: Updating database: Pending.
Info: Creating deployment plan: Pending.
Info: Verifying deployment plan: Pending.
Info: Deploying package to database: Pending.
Info: Creating deployment plan: Running.
Info: Initializing deployment: Running.
Info: Initializing deployment (Start)
Info: Initializing deployment: Completed.
Info: Initializing deployment (Complete)
Info: Creating deployment plan: Completed.
Info: Verifying deployment plan: Running.
Info: Analyzing deployment plan: Running.
Info: Analyzing deployment plan (Start)
Info: Analyzing deployment plan: Completed.
Info: Analyzing deployment plan (Complete)
Info: Verifying deployment plan: Completed.
Info: Deploying package to database: Running.
Info: Updating database: Running.
Info: Updating database (Start)
Info: Creating developer2_Web...
Info: Creating [dbo].[AccessControl]...
Info: Creating [dbo].[AccessControl].[IX_AccessControl]...
Info: Creating [dbo].[Archive]...
Info: Creating [dbo].[Archive].[ndx_ItemId]...
Info: Creating [dbo].[ArchivedFields]...
Info: Creating [dbo].[ArchivedFields].[ndx_ArchivalId]...
Info: Creating [dbo].[ArchivedFields].[ndx_VersionId]...
Info: Creating [dbo].[ArchivedItems]...
Info: Creating [dbo].[ArchivedItems].[ndx_ArchivalId]...
Info: Creating [dbo].[ArchivedVersions]...
Info: Creating [dbo].[ArchivedVersions].[ndx_ItemId]...
Info: Creating [dbo].[Blobs]...
Info: Creating [dbo].[Blobs].[ndxBlobId]...
Info: Creating [dbo].[ClientData]...
Info: Creating [dbo].[ClientData].[ndxID]...
Info: Creating [dbo].[ClientData].[ndxKey]...
Info: Creating [dbo].[Descendants]...
Info: Creating [dbo].[Descendants].[Descendant]...
Info: Creating [dbo].[EventQueue]...
Info: Creating [dbo].[EventQueue].[IX_Stamp]...
Info: Creating [dbo].[History]...
Info: Creating [dbo].[History].[ndxCreated]...
Info: Creating [dbo].[IDTable]...
Info: Creating [dbo].[IDTable].[ndxID]...
Info: Creating [dbo].[IDTable].[ndxPrefixKey]...
Info: Creating [dbo].[Items]...
Info: Creating [dbo].[Items].[ndxID]...
Info: Creating [dbo].[Items].[ndxName]...
Info: Creating [dbo].[Items].[ndxParentID]...
Info: Creating [dbo].[Items].[ndxTemplateID]...
Info: Creating [dbo].[Links]...
Info: Creating [dbo].[Links].[ndxID]...
Info: Creating [dbo].[Links].[ndxSourceItemID]...
Info: Creating [dbo].[Links].[ndxTargetItemID]...
Info: Creating [dbo].[Notifications]...
Info: Creating [dbo].[Properties]...
Info: Creating [dbo].[Properties].[ndxID]...
Info: Creating [dbo].[Properties].[ndxKey]...
Info: Creating [dbo].[PublishQueue]...
Info: Creating [dbo].[PublishQueue].[ndxDate]...
Info: Creating [dbo].[PublishQueue].[ndxID]...
Info: Creating [dbo].[SharedFields]...
Info: Creating [dbo].[SharedFields].[ndxUnique]...
Info: Creating [dbo].[Tasks]...
Info: Creating [dbo].[Tasks].[ndxID]...
Info: Creating [dbo].[UnversionedFields]...
Info: Creating [dbo].[UnversionedFields].[ndxUnique]...
Info: Creating [dbo].[VersionedFields]...
Info: Creating [dbo].[VersionedFields].[ndxUnique]...
Info: Creating [dbo].[WorkflowHistory]...
Info: Creating [dbo].[WorkflowHistory].[ndxID]...
Info: Creating [dbo].[WorkflowHistory].[ndxItemID]...
Info: Creating [dbo].[DF_Blobs_Id]...
Info: Creating [dbo].[DF_ClientData_ID]...
Info: Creating [dbo].[DF_EventQueue_Created]...
Info: Creating [dbo].[DF_History_AdditionalInfo]...
Info: Creating [dbo].[DF_History_Id]...
Info: Creating [dbo].[DF_History_ItemPath]...
Info: Creating [dbo].[DF_History_TaskStack]...
Info: Creating [dbo].[DF_IDTable_ID]...
Info: Creating [dbo].[DF_Links_ID]...
Info: Creating [dbo].[DF_Links_SourceLanguage]...
Info: Creating [dbo].[DF_Links_SourceVersion]...
Info: Creating [dbo].[DF_Links_TargetLanguage]...
Info: Creating [dbo].[DF_Links_TargetVersion]...
Info: Creating [dbo].[DF_Properties_ID]...
Info: Creating [dbo].[DF_PublishQueue_Action]...
Info: Creating [dbo].[DF_PublishQueue_ID]...
Info: Creating [dbo].[DF_PublishQueue_Language]...
Info: Creating [dbo].[DF_PublishQueue_Version]...
Info: Creating [dbo].[DF_SharedFields_Id]...
Info: Creating [dbo].[DF_UnversionedFields_Id]...
Info: Creating [dbo].[DF_VersionedFields_Id]...
Info: Creating [dbo].[DF_WorkflowHistory_ID]...
Info: Creating [dbo].[Fields]...
Info: The transacted portion of the database update succeeded.
Info: Update complete.
Info: Importing data: Pending.
Info: Importing data
Info: Importing data: Running.
Info: Processing Table '[dbo].[Blobs]'.: Pending.
Info: Processing Table '[dbo].[Items]'.: Pending.
Info: Processing Table '[dbo].[Descendants]'.: Pending.
Info: Processing Table '[dbo].[SharedFields]'.: Pending.
Info: Processing Table '[dbo].[UnversionedFields]'.: Pending.
Info: Processing Table '[dbo].[VersionedFields]'.: Pending.
Info: Processing Import.: Running.
Info: Disabling indexes.: Pending.
Info: Disabling indexes.: Running.
Info: Disabling indexes. (Start)
Info: Disabling index 'ndxBlobId'.: Pending.
Info: Disabling index 'ndxBlobId'.: Running.
Info: Disabling index 'ndxBlobId'. (Start)
Info: Disabling index 'ndxBlobId'.: Completed.
Info: Disabling index 'ndxBlobId'. (Complete)
Info: Disabling index 'Descendant'.: Pending.
Info: Disabling index 'Descendant'.: Running.
Info: Disabling index 'Descendant'. (Start)
Info: Disabling index 'Descendant'.: Completed.
Info: Disabling index 'Descendant'. (Complete)
Info: Disabling index 'Descendants_PK'.: Pending.
Info: Disabling index 'Descendants_PK'.: Running.
Info: Disabling index 'Descendants_PK'. (Start)
Info: Disabling index 'Descendants_PK'.: Completed.
Info: Disabling index 'Descendants_PK'. (Complete)
Info: Disabling index 'ndxID'.: Pending.
Info: Disabling index 'ndxID'.: Running.
Info: Disabling index 'ndxID'. (Start)
Info: Disabling index 'ndxID'.: Completed.
Info: Disabling index 'ndxID'. (Complete)
Info: Disabling index 'ndxName'.: Pending.
Info: Disabling index 'ndxName'.: Running.
Info: Disabling index 'ndxName'. (Start)
Info: Disabling index 'ndxName'.: Completed.
Info: Disabling index 'ndxName'. (Complete)
Info: Disabling index 'ndxParentID'.: Pending.
Info: Disabling index 'ndxParentID'.: Running.
Info: Disabling index 'ndxParentID'. (Start)
Info: Disabling index 'ndxParentID'.: Completed.
Info: Disabling index 'ndxParentID'. (Complete)
Info: Disabling index 'ndxTemplateID'.: Pending.
Info: Disabling index 'ndxTemplateID'.: Running.
Info: Disabling index 'ndxTemplateID'. (Start)
Info: Disabling index 'ndxTemplateID'.: Completed.
Info: Disabling index 'ndxTemplateID'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling index 'ndxUnique'.: Pending.
Info: Disabling index 'ndxUnique'.: Running.
Info: Disabling index 'ndxUnique'. (Start)
Info: Disabling index 'ndxUnique'.: Completed.
Info: Disabling index 'ndxUnique'. (Complete)
Info: Disabling indexes.: Completed.
Info: Disabling indexes. (Complete)
Info: Processing Import. 0.00% done.
Info: Processing Table '[dbo].[Blobs]'.: Running.
Info: Processing Import. 20.77% done.
Info: Processing Table '[dbo].[Blobs]'. 100.00% done.
Info: Processing Table '[dbo].[Blobs]'.: Completed.
Info: Processing Table '[dbo].[Descendants]'.: Running.
Info: Processing Table '[dbo].[Descendants]'. 100.00% done.
Info: Processing Table '[dbo].[Descendants]'.: Completed.
Info: Processing Import. 37.76% done.
Info: Processing Table '[dbo].[Items]'.: Running.
Info: Processing Import. 43.15% done.
Info: Processing Table '[dbo].[Items]'. 100.00% done.
Info: Processing Table '[dbo].[Items]'.: Completed.
Info: Processing Table '[dbo].[SharedFields]'.: Running.
Info: Processing Import. 57.84% done.
Info: Processing Table '[dbo].[SharedFields]'. 100.00% done.
Info: Processing Table '[dbo].[SharedFields]'.: Completed.
Info: Processing Table '[dbo].[UnversionedFields]'.: Running.
Info: Processing Import. 59.61% done.
Info: Processing Table '[dbo].[UnversionedFields]'. 100.00% done.
Info: Processing Table '[dbo].[UnversionedFields]'.: Completed.
Info: Processing Table '[dbo].[VersionedFields]'.: Running.
Info: Processing Import. 100.00% done.
Info: Processing Table '[dbo].[VersionedFields]'. 100.00% done.
Info: Processing Table '[dbo].[VersionedFields]'.: Completed.
Info: Enabling indexes.: Pending.
Info: Enabling indexes.: Running.
Info: Enabling indexes. (Start)
Info: Enabling index 'ndxBlobId'.: Pending.
Info: Enabling index 'ndxBlobId'.: Running.
Info: Enabling index 'ndxBlobId'. (Start)
Info: Enabling index 'ndxBlobId'.: Completed.
Info: Enabling index 'ndxBlobId'. (Complete)
Info: Enabling index 'Descendant'.: Pending.
Info: Enabling index 'Descendant'.: Running.
Info: Enabling index 'Descendant'. (Start)
Info: Enabling index 'Descendant'.: Completed.
Info: Enabling index 'Descendant'. (Complete)
Info: Enabling index 'Descendants_PK'.: Pending.
Info: Enabling index 'Descendants_PK'.: Running.
Info: Enabling index 'Descendants_PK'. (Start)
Info: Enabling index 'Descendants_PK'.: Completed.
Info: Enabling index 'Descendants_PK'. (Complete)
Info: Enabling index 'ndxID'.: Pending.
Info: Enabling index 'ndxID'.: Running.
Info: Enabling index 'ndxID'. (Start)
Info: Enabling index 'ndxID'.: Completed.
Info: Enabling index 'ndxID'. (Complete)
Info: Enabling index 'ndxName'.: Pending.
Info: Enabling index 'ndxName'.: Running.
Info: Enabling index 'ndxName'. (Start)
Info: Enabling index 'ndxName'.: Completed.
Info: Enabling index 'ndxName'. (Complete)
Info: Enabling index 'ndxParentID'.: Pending.
Info: Enabling index 'ndxParentID'.: Running.
Info: Enabling index 'ndxParentID'. (Start)
Info: Enabling index 'ndxParentID'.: Completed.
Info: Enabling index 'ndxParentID'. (Complete)
Info: Enabling index 'ndxTemplateID'.: Pending.
Info: Enabling index 'ndxTemplateID'.: Running.
Info: Enabling index 'ndxTemplateID'. (Start)
Info: Enabling index 'ndxTemplateID'.: Completed.
Info: Enabling index 'ndxTemplateID'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling index 'ndxUnique'.: Pending.
Info: Enabling index 'ndxUnique'.: Running.
Info: Enabling index 'ndxUnique'. (Start)
Info: Enabling index 'ndxUnique'.: Completed.
Info: Enabling index 'ndxUnique'. (Complete)
Info: Enabling indexes.: Completed.
Info: Enabling indexes. (Complete)
Info: Processing Import.: Completed.
Info: Importing data: Completed.
Info: Importing data
Info: Updating database: Completed.
Info: Updating database (Complete)
Info: Deploying package to database: Completed.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Web;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_Web;user id=sa']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLExpress;initial catalog=developer2_Web;user id=sa;pooling=False'. The 'transacted' setting for this connection is 'False'.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_ExperienceForms;user id=sa)
Info: Initializing deployment: Pending.
Info: Analyzing deployment plan: Pending.
Info: Updating database: Pending.
Info: Creating deployment plan: Pending.
Info: Verifying deployment plan: Pending.
Info: Deploying package to database: Pending.
Info: Creating deployment plan: Running.
Info: Initializing deployment: Running.
Info: Initializing deployment (Start)
Info: Initializing deployment: Completed.
Info: Initializing deployment (Complete)
Info: Creating deployment plan: Completed.
Info: Verifying deployment plan: Running.
Info: Analyzing deployment plan: Running.
Info: Analyzing deployment plan (Start)
Info: Analyzing deployment plan: Completed.
Info: Analyzing deployment plan (Complete)
Info: Verifying deployment plan: Completed.
Info: Deploying package to database: Running.
Info: Updating database: Running.
Info: Updating database (Start)
Info: Creating developer2_ExperienceForms...
Info: Creating [dbo].[FieldData]...
Info: Creating [dbo].[FormEntry]...
Info: Creating [dbo].[FK_FieldData_FormEntry]...
Info: The transacted portion of the database update succeeded.
Info: Update complete.
Info: Updating database: Completed.
Info: Updating database (Complete)
Info: Deploying package to database: Completed.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_ExperienceForms;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_ExperienceForms;user id=sa']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLExpress;initial catalog=developer2_ExperienceForms;user id=sa;pooling=False'. The 'transacted' setting for this connection is 'False'.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Reporting;user id=sa)
Info: Initializing deployment: Pending.
Info: Analyzing deployment plan: Pending.
Info: Updating database: Pending.
Info: Creating deployment plan: Pending.
Info: Verifying deployment plan: Pending.
Info: Deploying package to database: Pending.
Info: Creating deployment plan: Running.
Info: Initializing deployment: Running.
Info: Initializing deployment (Start)
Info: Initializing deployment: Completed.
Info: Initializing deployment (Complete)
Info: Creating deployment plan: Completed.
Info: Verifying deployment plan: Running.
Info: Analyzing deployment plan: Running.
Info: Analyzing deployment plan (Start)
Info: Analyzing deployment plan: Completed.
Info: Analyzing deployment plan (Complete)
Info: Verifying deployment plan: Completed.
Info: Deploying package to database: Running.
Info: Updating database: Running.
Info: Updating database (Start)
Info: Creating developer2_Reporting...
Info: Creating [dbo].[ArrayOfGuids]...
Info: Creating [dbo].[ArrayOfRanges]...
Info: Creating [dbo].[Assets_Type]...
Info: Creating [dbo].[BusinessUnits_Type]...
Info: Creating [dbo].[CampaignMetrics_Type]...
Info: Creating [dbo].[ChannelMetrics_Type]...
Info: Creating [dbo].[Conversions_Type]...
Info: Creating [dbo].[ConversionsMetrics_Type]...
Info: Creating [dbo].[DeviceMetrics_Type]...
Info: Creating [dbo].[DeviceNames_Type]...
Info: Creating [dbo].[DimensionKeys_Type]...
Info: Creating [dbo].[DownloadEventMetrics_Type]...
Info: Creating [dbo].[Downloads_Type]...
Info: Creating [dbo].[FailureDetails_Type]...
Info: Creating [dbo].[Failures_Type]...
Info: Creating [dbo].[FollowHits_Type]...
Info: Creating [dbo].[GeoMetrics_Type]...
Info: Creating [dbo].[GoalMetrics_Type]...
Info: Creating [dbo].[InteractionTrailEntry]...
Info: Creating [dbo].[Items_Type]...
Info: Creating [dbo].[Keywords_Type]...
Info: Creating [dbo].[LanguageMetrics_Type]...
Info: Creating [dbo].[Languages_Type]...
Info: Creating [dbo].[OutcomeMetrics_Type]...
Info: Creating [dbo].[PageMetrics_Type]...
Info: Creating [dbo].[PageViewsMetrics_Type]...
Info: Creating [dbo].[PatternMetrics_Type]...
Info: Creating [dbo].[ReferringSiteMetrics_Type]...
Info: Creating [dbo].[ReferringSites_Type]...
Info: Creating [dbo].[SearchMetrics_Type]...
Info: Creating [dbo].[SegmentMetrics_Type]...
Info: Creating [dbo].[SegmentRecords_Type]...
Info: Creating [dbo].[SiteNames_Type]...
Info: Creating [dbo].[SiteSearches_Type]...
Info: Creating [dbo].[SlowPages_Type]...
Info: Creating [dbo].[Traffic_Type]...
Info: Creating [dbo].[TreeData]...
Info: Creating [dbo].[TreeKeys]...
Info: Creating [dbo].[ValueBySource_Type]...
Info: Creating [dbo].[Visits_Type]...
Info: Creating [dbo].[VisitsByBusinessContactLocation_Type]...
Info: Creating [dbo].[Accounts]...
Info: Creating [dbo].[Assets]...
Info: Creating [dbo].[Assets].[IX_Assets_Url]...
Info: Creating [dbo].[BusinessUnits]...
Info: Creating [dbo].[Contacts]...
Info: Creating [dbo].[DeviceNames]...
Info: Creating [dbo].[DimensionKeys]...
Info: Creating [dbo].[Fact_AutomationStates]...
Info: Creating [dbo].[Fact_CampaignMetrics]...
Info: Creating [dbo].[Fact_ChannelMetrics]...
Info: Creating [dbo].[Fact_Conversions]...
Info: Creating [dbo].[Fact_Conversions].[IX_Fact_Conversion_Campaign]...
Info: Creating [dbo].[Fact_Conversions].[IX_Fact_Conversion_DeviceName]...
Info: Creating [dbo].[Fact_Conversions].[IX_Fact_Conversion_Goal]...
Info: Creating [dbo].[Fact_Conversions].[IX_Fact_Conversion_Language]...
Info: Creating [dbo].[Fact_Conversions].[IX_Fact_Conversion_SiteName]...
Info: Creating [dbo].[Fact_Conversions].[IX_Fact_Conversion_TrafficType]...
Info: Creating [dbo].[Fact_ConversionsMetrics]...
Info: Creating [dbo].[Fact_DeviceMetrics]...
Info: Creating [dbo].[Fact_DownloadEventMetrics]...
Info: Creating [dbo].[Fact_Downloads]...
Info: Creating [dbo].[Fact_Downloads].[IX_Fact_Downloads_Campaign]...
Info: Creating [dbo].[Fact_Downloads].[IX_Fact_Downloads_DeviceName]...
Info: Creating [dbo].[Fact_Downloads].[IX_Fact_Downloads_Language]...
Info: Creating [dbo].[Fact_Downloads].[IX_Fact_Downloads_SiteName]...
Info: Creating [dbo].[Fact_Downloads].[IX_Fact_Downloads_TrafficType]...
Info: Creating [dbo].[Fact_Failures]...
Info: Creating [dbo].[Fact_Failures].[IX_Fact_Failures_FailureDetails]...
Info: Creating [dbo].[Fact_Failures].[IX_Fact_Failures_Keywords]...
Info: Creating [dbo].[Fact_Failures].[IX_Fact_Failures_PageEventDefinition]...
Info: Creating [dbo].[Fact_Failures].[IX_Fact_Failures_ReferringSite]...
Info: Creating [dbo].[Fact_FollowHits]...
Info: Creating [dbo].[Fact_FollowHits].[IX_Fact_FollowHits_Item]...
Info: Creating [dbo].[Fact_FollowHits].[IX_Fact_FollowHits_Keywords]...
Info: Creating [dbo].[Fact_FormFieldMetrics]...
Info: Creating [dbo].[Fact_FormMetrics]...
Info: Creating [dbo].[Fact_GeoMetrics]...
Info: Creating [dbo].[Fact_GoalMetrics]...
Info: Creating [dbo].[Fact_LanguageMetrics]...
Info: Creating [dbo].[Fact_MvTesting]...
Info: Creating [dbo].[Fact_MvTesting].[IX_Fact_MvTesting_TestSetId]...
Info: Creating [dbo].[Fact_MvTestingDetails]...
Info: Creating [dbo].[Fact_MvTestingDetails].[IX_Fact_MvTestingDetails_TestSetId]...
Info: Creating [dbo].[Fact_OutcomeMetrics]...
Info: Creating [dbo].[Fact_PageMetrics]...
Info: Creating [dbo].[Fact_PageViews]...
Info: Creating [dbo].[Fact_PageViews].[IX_Fact_PageViews_Contact]...
Info: Creating [dbo].[Fact_PageViews].[IX_Fact_PageViews_Item]...
Info: Creating [dbo].[Fact_PageViewsByLanguage]...
Info: Creating [dbo].[Fact_PageViewsMetrics]...
Info: Creating [dbo].[Fact_PatternMetrics]...
Info: Creating [dbo].[Fact_Personalization]...
Info: Creating [dbo].[Fact_Personalization].[IX_Fact_Personalization_TestSetId]...
Info: Creating [dbo].[Fact_ReferringSiteMetrics]...
Info: Creating [dbo].[Fact_RulesExposure]...
Info: Creating [dbo].[Fact_Searches]...
Info: Creating [dbo].[Fact_SearchMetrics]...
Info: Creating [dbo].[Fact_SegmentMetrics]...
Info: Creating [dbo].[Fact_SegmentMetrics].[IX_Fact_SegmentMetrics_All_Columns]...
Info: Creating [dbo].[Fact_SegmentMetricsReduced]...
Info: Creating [dbo].[Fact_SegmentMetricsReduced].[IX_Fact_SegmentMetricsReduced_All_Columns]...
Info: Creating [dbo].[Fact_SiteSearches]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_AccountId]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_Campaign]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_DeviceName]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_Item]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_Keywords]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_Language]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_SiteName]...
Info: Creating [dbo].[Fact_SiteSearches].[IX_Fact_SiteSearches_TrafficType]...
Info: Creating [dbo].[Fact_SlowPages]...
Info: Creating [dbo].[Fact_SlowPages].[IX_Fact_SlowPages_Account]...
Info: Creating [dbo].[Fact_SlowPages].[IX_Fact_SlowPages_Contact]...
Info: Creating [dbo].[Fact_SlowPages].[IX_Fact_SlowPages_Duration]...
Info: Creating [dbo].[Fact_SlowPages].[IX_Fact_SlowPages_Item]...
Info: Creating [dbo].[Fact_SlowPages].[IX_Fact_SlowPages_Visit]...
Info: Creating [dbo].[Fact_TestConversions]...
Info: Creating [dbo].[Fact_TestConversions].[IX_Fact_TestConversions_GoalId]...
Info: Creating [dbo].[Fact_TestOutcomes]...
Info: Creating [dbo].[Fact_TestOutcomes].[IX_Fact_TestOutcomes_TestSetId]...
Info: Creating [dbo].[Fact_TestPageClicks]...
Info: Creating [dbo].[Fact_TestStatistics]...
Info: Creating [dbo].[Fact_Traffic]...
Info: Creating [dbo].[Fact_Traffic].[IX_ByDate]...
Info: Creating [dbo].[Fact_Traffic].[IX_ByDateAndTrafficType]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_Campaign]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_DeviceName]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_Item]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_Keywords]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_Language]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_ReferringSite]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_SiteName]...
Info: Creating [dbo].[Fact_Traffic].[IX_Fact_Traffic_TrafficType]...
Info: Creating [dbo].[Fact_ValueBySource]...
Info: Creating [dbo].[Fact_ValueBySource].[IX_Fact_ValueBySource_DeviceName]...
Info: Creating [dbo].[Fact_ValueBySource].[IX_Fact_ValueBySource_Language]...
Info: Creating [dbo].[Fact_ValueBySource].[IX_Fact_ValueBySource_SiteName]...
Info: Creating [dbo].[Fact_ValueBySource].[IX_Fact_ValueBySource_TrafficType]...
Info: Creating [dbo].[Fact_Visits]...
Info: Creating [dbo].[Fact_Visits].[IX_Fact_Visits_Contact]...
Info: Creating [dbo].[Fact_Visits].[IX_Fact_Visits_FirstVisit]...
Info: Creating [dbo].[Fact_Visits].[IX_Fact_Visits_Item]...
Info: Creating [dbo].[Fact_Visits].[IX_Fact_Visits_Language]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation].[IX_Fact_VisitsByBusinessContactLocation_Account]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation].[IX_Fact_VisitsByBusinessContactLocation_Contact]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation].[IX_Fact_VisitsByBusinessContactLocation_DeviceName]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation].[IX_Fact_VisitsByBusinessContactLocation_Language]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation].[IX_Fact_VisitsByBusinessContactLocation_SiteName]...
Info: Creating [dbo].[Fact_VisitsByBusinessContactLocation].[IX_Fact_VisitsByBusinessContactLocation_TrafficType]...
Info: Creating [dbo].[FailureDetails]...
Info: Creating [dbo].[FormFieldNames]...
Info: Creating [dbo].[Items]...
Info: Creating [dbo].[Keywords]...
Info: Creating [dbo].[Languages]...
Info: Creating [dbo].[Properties]...
Info: Creating [dbo].[Properties].[IX_Properties_Column]...
Info: Creating [dbo].[ReferringSites]...
Info: Creating [dbo].[SegmentRecords]...
Info: Creating [dbo].[SegmentRecords].[IX_SegmentRecords_All_Columns]...
Info: Creating [dbo].[SegmentRecords].[IX_SegmentRecords_All_Columns2]...
Info: Creating [dbo].[SegmentRecordsReduced]...
Info: Creating [dbo].[SegmentRecordsReduced].[IX_SegmentRecordsReduced_All_Columns]...
Info: Creating [dbo].[SegmentRecordsReduced].[IX_SegmentRecordsReduced_All_Columns2]...
Info: Creating [dbo].[Segments]...
Info: Creating [dbo].[SiteNames]...
Info: Creating [dbo].[Taxonomy_TaxonEntity]...
Info: Creating [dbo].[Taxonomy_TaxonEntityFieldDefinition]...
Info: Creating [dbo].[Taxonomy_TaxonEntityFieldValue]...
Info: Creating [dbo].[Testing_ClusterMembers]...
Info: Creating [dbo].[Testing_Clusters]...
Info: Creating [dbo].[Trail_AutomationStates]...
Info: Creating [dbo].[Trail_AutomationStates].[IX_Trail_AutomationStates_Processed]...
Info: Creating [dbo].[Trail_Interactions]...
Info: Creating [dbo].[Trail_Interactions].[IX_Trail_Interactions_Processed]...
Info: Creating [dbo].[Trail_PathAnalyzer]...
Info: Creating [dbo].[Trail_PathAnalyzer].[IX_Trail_PathAnalyzer_Processed]...
Info: Creating [dbo].[TreeDefinitions]...
Info: Creating [dbo].[Trees]...
Info: Creating [dbo].[Trees].[IX_Trees]...
Info: Creating [dbo].[Trees].[IX_Trees_Visits]...
Info: Creating [dbo].[DF_Fact_MvTesting_Bounces]...
Info: Creating [dbo].[DF_Fact_MvTesting_PageCount]...
Info: Creating [dbo].[DF_Fact_MvTesting_TotalPageDuration]...
Info: Creating [dbo].[DF_Fact_MvTesting_TotalWebsiteDuration]...
Info: Creating [dbo].[DF_Fact_MvTesting_Visitors]...
Info: Creating unnamed constraint on [dbo].[Fact_MvTestingDetails]...
Info: Creating unnamed constraint on [dbo].[Taxonomy_TaxonEntity]...
Info: Creating unnamed constraint on [dbo].[Trail_PathAnalyzer]...
Info: Creating [dbo].[FK_Fact_Conversions_Accounts]...
Info: Creating [dbo].[FK_Fact_Conversions_DeviceNames]...
Info: Creating [dbo].[FK_Fact_Conversions_Languages]...
Info: Creating [dbo].[FK_Fact_Conversions_SiteNames]...
Info: Creating [dbo].[FK_Fact_Downloads_Accounts]...
Info: Creating [dbo].[FK_Fact_Downloads_Assets]...
Info: Creating [dbo].[FK_Fact_Downloads_DeviceNames]...
Info: Creating [dbo].[FK_Fact_Downloads_Languages]...
Info: Creating [dbo].[FK_Fact_Downloads_SiteNames]...
Info: Creating [dbo].[FK_Fact_Failures_Accounts]...
Info: Creating [dbo].[FK_Fact_Failures_FailureDetails]...
Info: Creating [dbo].[FK_Fact_Failures_Keywords]...
Info: Creating [dbo].[FK_Fact_Failures_ReferringSites]...
Info: Creating [dbo].[FK_Fact_FollowHits_Items]...
Info: Creating [dbo].[FK_Fact_FollowHits_Keywords]...
Info: Creating [dbo].[FK_Fact_PageViews_Items]...
Info: Creating [dbo].[FK_Fact_PageViewsByLanguage_DeviceNames]...
Info: Creating [dbo].[FK_Fact_PageViewsByLanguage_Items]...
Info: Creating [dbo].[FK_Fact_PageViewsByLanguage_Languages]...
Info: Creating [dbo].[FK_Fact_PageViewsByLanguage_SiteNames]...
Info: Creating [dbo].[FK_Fact_Searches_Accounts]...
Info: Creating [dbo].[FK_Fact_Searches_DeviceNames]...
Info: Creating [dbo].[FK_Fact_Searches_Items]...
Info: Creating [dbo].[FK_Fact_Searches_Keywords]...
Info: Creating [dbo].[FK_Fact_Searches_Languages]...
Info: Creating [dbo].[FK_Fact_Searches_PageEventItems]...
Info: Creating [dbo].[FK_Fact_Searches_SiteNames]...
Info: Creating [dbo].[FK_Fact_SiteSearches_Accounts]...
Info: Creating [dbo].[FK_Fact_SiteSearches_DeviceNames]...
Info: Creating [dbo].[FK_Fact_SiteSearches_Items]...
Info: Creating [dbo].[FK_Fact_SiteSearches_Keywords]...
Info: Creating [dbo].[FK_Fact_SiteSearches_Languages]...
Info: Creating [dbo].[FK_Fact_SiteSearches_SiteNames]...
Info: Creating [dbo].[FK_Fact_SlowPages_Accounts]...
Info: Creating [dbo].[FK_Fact_SlowPages_ContactId]...
Info: Creating [dbo].[FK_Fact_SlowPages_Items]...
Info: Creating [dbo].[FK_Fact_Traffic_DeviceNames]...
Info: Creating [dbo].[FK_Fact_Traffic_Items]...
Info: Creating [dbo].[FK_Fact_Traffic_Keywords]...
Info: Creating [dbo].[FK_Fact_Traffic_Languages]...
Info: Creating [dbo].[FK_Fact_Traffic_ReferringSites]...
Info: Creating [dbo].[FK_Fact_Traffic_SiteNames]...
Info: Creating [dbo].[FK_Fact_ValueBySource_DeviceNames]...
Info: Creating [dbo].[FK_Fact_ValueBySource_Languages]...
Info: Creating [dbo].[FK_Fact_ValueBySource_SiteNames]...
Info: Creating [dbo].[FK_Fact_Visits_Contacts]...
Info: Creating [dbo].[FK_Fact_Visits_Items]...
Info: Creating [dbo].[FK_Fact_Visits_Languages]...
Info: Creating [dbo].[FK_Fact_VisitsByBusinessContactLocation_DeviceNames]...
Info: Creating [dbo].[FK_Fact_VisitsByBusinessContactLocation_Locations]...
Info: Creating [dbo].[FK_Fact_VisitsByBusinessContactLocation_SiteNames]...
Info: Creating [dbo].[FK_Taxonomy_TaxonEntityFieldValue_Taxonomy_TaxonEntity]...
Info: Creating [dbo].[FK_Taxonomy_TaxonEntityFieldValue_Taxonomy_TaxonEntityFieldDefinition]...
Info: Creating [dbo].[Dates]...
Info: Creating [dbo].[Conversions]...
Info: Creating [dbo].[Downloads]...
Info: Creating [dbo].[FollowHits]...
Info: Creating [dbo].[NotFoundUrls]...
Info: Creating [dbo].[ReportDataView]...
Info: Creating [dbo].[SiteSearches]...
Info: Creating [dbo].[SlowPages]...
Info: Creating [dbo].[TopLeads]...
Info: Creating [dbo].[Traffic]...
Info: Creating [dbo].[TrafficOverview]...
Info: Creating [dbo].[ValueBySource]...
Info: Creating [dbo].[CampaignsOverview]...
Info: Creating [dbo].[GetTagValue]...
Info: Creating [dbo].[GetTaxonEntityChildIds]...
Info: Creating [dbo].[__DeleteAllReportingData]...
Info: Creating [dbo].[Add_AutomationStates]...
Info: Creating [dbo].[Add_CampaignMetrics_Tvp]...
Info: Creating [dbo].[Add_ChannelMetrics_Tvp]...
Info: Creating [dbo].[Add_Conversions]...
Info: Creating [dbo].[Add_Conversions_Tvp]...
Info: Creating [dbo].[Add_ConversionsMetrics_Tvp]...
Info: Creating [dbo].[Add_DeviceMetrics_Tvp]...
Info: Creating [dbo].[Add_DownloadEventMetrics_Tvp]...
Info: Creating [dbo].[Add_Downloads]...
Info: Creating [dbo].[Add_Downloads_Tvp]...
Info: Creating [dbo].[Add_Failures]...
Info: Creating [dbo].[Add_Failures_Tvp]...
Info: Creating [dbo].[Add_FollowHits]...
Info: Creating [dbo].[Add_FollowHits_Tvp]...
Info: Creating [dbo].[Add_GeoMetrics_Tvp]...
Info: Creating [dbo].[Add_GoalMetrics_Tvp]...
Info: Creating [dbo].[Add_LanguageMetrics_Tvp]...
Info: Creating [dbo].[Add_MvTesting]...
Info: Creating [dbo].[Add_MvTestingDetails]...
Info: Creating [dbo].[Add_OutcomeMetrics_Tvp]...
Info: Creating [dbo].[Add_PageMetrics_Tvp]...
Info: Creating [dbo].[Add_PageViews]...
Info: Creating [dbo].[Add_PageViewsByLanguage]...
Info: Creating [dbo].[Add_PageViewsMetrics_Tvp]...
Info: Creating [dbo].[Add_PatternMetrics_Tvp]...
Info: Creating [dbo].[Add_Personalization]...
Info: Creating [dbo].[Add_ReferringSiteMetrics_Tvp]...
Info: Creating [dbo].[Add_RulesExposure]...
Info: Creating [dbo].[Add_SearchMetrics_Tvp]...
Info: Creating [dbo].[Add_SegmentMetrics]...
Info: Creating [dbo].[Add_SegmentMetrics_Tvp]...
Info: Creating [dbo].[Add_SiteSearches]...
Info: Creating [dbo].[Add_SiteSearches_Tvp]...
Info: Creating [dbo].[Add_SlowPages]...
Info: Creating [dbo].[Add_SlowPages_Tvp]...
Info: Creating [dbo].[Add_TestConversions]...
Info: Creating [dbo].[Add_TestingCluster]...
Info: Creating [dbo].[Add_TestingClusterMembers]...
Info: Creating [dbo].[Add_TestOutcomes]...
Info: Creating [dbo].[Add_TestPageClicks]...
Info: Creating [dbo].[Add_TestStatistics]...
Info: Creating [dbo].[Add_Traffic]...
Info: Creating [dbo].[Add_Traffic_Tvp]...
Info: Creating [dbo].[Add_ValueBySource]...
Info: Creating [dbo].[Add_ValueBySource_Tvp]...
Info: Creating [dbo].[Add_Visits]...
Info: Creating [dbo].[Add_Visits_Tvp]...
Info: Creating [dbo].[Add_VisitsByBusinessContactLocation]...
Info: Creating [dbo].[Add_VisitsByBusinessContactLocation_Tvp]...
Info: Creating [dbo].[Ensure_Asset]...
Info: Creating [dbo].[Ensure_Assets_Tvp]...
Info: Creating [dbo].[Ensure_BusinessUnit]...
Info: Creating [dbo].[Ensure_BusinessUnits_Tvp]...
Info: Creating [dbo].[Ensure_DeviceName]...
Info: Creating [dbo].[Ensure_DeviceNames_Tvp]...
Info: Creating [dbo].[Ensure_DimensionKeys]...
Info: Creating [dbo].[Ensure_DimensionKeys_Tvp]...
Info: Creating [dbo].[Ensure_FailureDetails]...
Info: Creating [dbo].[Ensure_FailureDetails_Tvp]...
Info: Creating [dbo].[Ensure_Item]...
Info: Creating [dbo].[Ensure_Items_Tvp]...
Info: Creating [dbo].[Ensure_Keywords]...
Info: Creating [dbo].[Ensure_Keywords_Tvp]...
Info: Creating [dbo].[Ensure_Language]...
Info: Creating [dbo].[Ensure_Languages_Tvp]...
Info: Creating [dbo].[Ensure_ReferringSite]...
Info: Creating [dbo].[Ensure_ReferringSites_Tvp]...
Info: Creating [dbo].[Ensure_SegmentRecords]...
Info: Creating [dbo].[Ensure_SegmentRecords_Tvp]...
Info: Creating [dbo].[Ensure_SiteName]...
Info: Creating [dbo].[Ensure_SiteNames_Tvp]...
Info: Creating [dbo].[Get_AllTaxonEntities]...
Info: Creating [dbo].[Get_MissingDailyTrees]...
Info: Creating [dbo].[Get_TaxonEntity]...
Info: Creating [dbo].[Get_TaxonEntityChildren]...
Info: Creating [dbo].[Get_TaxonEntityList]...
Info: Creating [dbo].[ReduceMetricsTable]...
Info: Creating [dbo].[ReduceSegmentMetrics]...
Info: Creating [dbo].[Register_AutomationStates]...
Info: Creating [dbo].[Register_Interaction]...
Info: Creating [dbo].[Upsert_Account]...
Info: Creating [dbo].[Upsert_Contact]...
Info: Creating [dbo].[Upsert_TaxonEntities]...
Info: Creating [dbo].[Upsert_TaxonEntity]...
Info: Creating [dbo].[Upsert_TaxonEntityField]...
Info: Creating [dbo].[Upsert_TaxonEntityFields]...
Info: The transacted portion of the database update succeeded.
Info: Update complete.
Info: Updating database: Completed.
Info: Updating database (Complete)
Info: Deploying package to database: Completed.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Reporting;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_Reporting;user id=sa']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLExpress;initial catalog=developer2_Reporting;user id=sa;pooling=False'. The 'transacted' setting for this connection is 'False'.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Processing.Tasks;user id=sa)
Info: Initializing deployment: Pending.
Info: Analyzing deployment plan: Pending.
Info: Updating database: Pending.
Info: Creating deployment plan: Pending.
Info: Verifying deployment plan: Pending.
Info: Deploying package to database: Pending.
Info: Creating deployment plan: Running.
Info: Initializing deployment: Running.
Info: Initializing deployment (Start)
Info: Initializing deployment: Completed.
Info: Initializing deployment (Complete)
Info: Creating deployment plan: Completed.
Info: Verifying deployment plan: Running.
Info: Analyzing deployment plan: Running.
Info: Analyzing deployment plan (Start)
Info: Analyzing deployment plan: Completed.
Info: Analyzing deployment plan (Complete)
Info: Verifying deployment plan: Completed.
Info: Deploying package to database: Running.
Info: Updating database: Running.
Info: Updating database (Start)
Info: Creating developer2_Processing.Tasks...
Info: Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.
Info: Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
Info: Creating [xdb_processing_tasks]...
Info: Creating [xdb_processing_tasks].[HistoryCursors]...
Info: Creating [xdb_processing_tasks].[HistoryCursors].[IX_HistoryCursors_Completed]...
Info: Creating [xdb_processing_tasks].[HistoryTasks]...
Info: Creating [xdb_processing_tasks].[HistoryTaskStates]...
Info: Creating [xdb_processing_tasks].[ProcessingCursors]...
Info: Creating [xdb_processing_tasks].[ProcessingCursors].[IX_ProcessingCursors_Task]...
Info: Creating [xdb_processing_tasks].[ProcessingCursors].[IX_ProcessingCursors_Completed]...
Info: Creating [xdb_processing_tasks].[ProcessingTasks]...
Info: Creating [xdb_processing_tasks].[ProcessingTasks].[IX_ProcessingTasks_StatusAndType]...
Info: Creating [xdb_processing_tasks].[RebuildTargetStates]...
Info: Creating [xdb_processing_tasks].[FK_HistoryCursors_Task_HistoryTasks_Id]...
Info: Creating [xdb_processing_tasks].[FK_ProcessingCursors_Task_ProcessingTasks_Id]...
Info: Creating [xdb_processing_tasks].[FK_RebuildTargetStates_To_HistoryTaskStates_Id]...
Info: Creating [xdb_processing_tasks].[GrantLeastPrivilege]...
Info: Creating [xdb_processing_tasks].[History_AddCursor]...
Info: Creating [xdb_processing_tasks].[History_AddTargetState]...
Info: Creating [xdb_processing_tasks].[History_AddTask]...
Info: Creating [xdb_processing_tasks].[History_AddTaskState]...
Info: Creating [xdb_processing_tasks].[History_AreAllCursorsCompleted]...
Info: Creating [xdb_processing_tasks].[History_DeleteCursorsByTaskId]...
Info: Creating [xdb_processing_tasks].[History_DeleteTargetStatesByTaskStateId]...
Info: Creating [xdb_processing_tasks].[History_DeleteTaskStateById]...
Info: Creating [xdb_processing_tasks].[History_GetCursorsCountByTaskId]...
Info: Creating [xdb_processing_tasks].[History_GetTaskById]...
Info: Creating [xdb_processing_tasks].[History_GetTaskStateById]...
Info: Creating [xdb_processing_tasks].[History_GetTotalNumberOfConsumedItemsByTaskId]...
Info: Creating [xdb_processing_tasks].[History_MarkCursorCompleted]...
Info: Creating [xdb_processing_tasks].[History_TryAcquireCursor]...
Info: Creating [xdb_processing_tasks].[History_TryDeleteTaskById]...
Info: Creating [xdb_processing_tasks].[History_TryRegisterCursorSplitRequest]...
Info: Creating [xdb_processing_tasks].[History_TryUpdateTaskById]...
Info: Creating [xdb_processing_tasks].[History_UpdateCursor]...
Info: Creating [xdb_processing_tasks].[History_UpdateCursorProgress]...
Info: Creating [xdb_processing_tasks].[History_UpdateTaskState]...
Info: Creating [xdb_processing_tasks].[Processing_AddCursor]...
Info: Creating [xdb_processing_tasks].[Processing_AddTask]...
Info: Creating [xdb_processing_tasks].[Processing_AreAllCursorsCompleted]...
Info: Creating [xdb_processing_tasks].[Processing_DeleteCursorsByTaskId]...
Info: Creating [xdb_processing_tasks].[Processing_GetCursorsCountByTaskId]...
Info: Creating [xdb_processing_tasks].[Processing_GetTaskById]...
Info: Creating [xdb_processing_tasks].[Processing_GetTotalNumberOfConsumedItemsByTaskId]...
Info: Creating [xdb_processing_tasks].[Processing_IncrementTaskProgressById]...
Info: Creating [xdb_processing_tasks].[Processing_MarkCursorCompleted]...
Info: Creating [xdb_processing_tasks].[Processing_PickDeferredTask]...
Info: Creating [xdb_processing_tasks].[Processing_PickDistributedTaskInProgress]...
Info: Creating [xdb_processing_tasks].[Processing_PickDistributedTaskPending]...
Info: Creating [xdb_processing_tasks].[Processing_RemoveExpiredTasks]...
Info: Creating [xdb_processing_tasks].[Processing_RemoveTaskById]...
Info: Creating [xdb_processing_tasks].[Processing_TryAcquireCursor]...
Info: Creating [xdb_processing_tasks].[Processing_TryRegisterCursorSplitRequest]...
Info: Creating [xdb_processing_tasks].[Processing_UpdateCursor]...
Info: Creating [xdb_processing_tasks].[Processing_UpdateCursorProgress]...
Info: Creating [xdb_processing_tasks].[Processing_UpdateTaskStatusById]...
Info: The transacted portion of the database update succeeded.
Info: Update complete.
Info: Updating database: Completed.
Info: Updating database (Complete)
Info: Deploying package to database: Completed.
Info: Adding database (data source=.\SQLExpress;initial catalog=developer2_Processing.Tasks;user id=sa)
Info: Adding database (sitemanifest/dbFullSql[@path='data source=.\SQLExpress;initial catalog=developer2_Processing.Tasks;user id=sa']/sqlScript)
Info: Opening SQL Connection with connection string 'data source=.\SQLExpress;initial catalog=developer2_Processing.Tasks;user id=sa;pooling=False'. The 'transacted' setting for this connection is 'False'.
Info: Updating file (Sitecore\App_Config\ConnectionStrings.config).
Info: Updating file (Sitecore\App_Config\Sitecore\ContentSearch\Sitecore.ContentSearch.Solr.Index.Core.config).
Info: Updating file (Sitecore\App_Config\Sitecore\ContentSearch\Sitecore.ContentSearch.Solr.Index.Master.config).
Info: Updating file (Sitecore\App_Config\Sitecore\ContentSearch\Sitecore.ContentSearch.Solr.Index.Web.config).
Info: Updating file (Sitecore\App_Config\Sitecore\ContentTesting\Sitecore.ContentTesting.Solr.IndexConfiguration.config).
Info: Updating file (Sitecore\App_Config\Sitecore\FederatedExperienceManager\Sitecore.FXM.Solr.DomainsSearch.Index.Master.config).
Info: Updating file (Sitecore\App_Config\Sitecore\FederatedExperienceManager\Sitecore.FXM.Solr.DomainsSearch.Index.Web.config).
Info: Updating file (Sitecore\App_Config\Sitecore\Marketing.Assets\Sitecore.Marketing.Definitions.MarketingAssets.Repositories.Solr.Index.Master.config).
Info: Updating file (Sitecore\App_Config\Sitecore\Marketing.Assets\Sitecore.Marketing.Definitions.MarketingAssets.Repositories.Solr.Index.Web.config).
Info: Updating file (Sitecore\App_Config\Sitecore\Marketing.Operations.xMgmt\Sitecore.Marketing.Solr.Index.Master.config).
Info: Updating file (Sitecore\App_Config\Sitecore\Marketing.Operations.xMgmt\Sitecore.Marketing.Solr.Index.Web.config).
Total changes: 32 (21 added, 0 deleted, 11 updated, 0 parameters changed, 31341 bytes copied)

[-------------------------------------------------------------------------------------------------------- SetLicense : Copy --------------------------------------------------------------------------------------------------------------]
[SetLicense]:[Copying] C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration\license.xml => C:\inetpub\wwwroot\Sitecore\App_Data

[------------------------------------------------------------------------------------------------------ StartAppPool : ManageAppPool -----------------------------------------------------------------------------------------------------]
[StartAppPool]:[Start] Sitecore

[------------------------------------------------------------------------------------------------------ StartWebsite : ManageWebsite -----------------------------------------------------------------------------------------------------]
[StartWebsite]:[Start] Sitecore

[-------------------------------------------------------------------------------------------------- UpdateSolrSchema : SitecoreUrl -------------------------------------------------------------------------------------------------------]
[UpdateSolrSchema]:[Requesting] http://Sitecore/sitecore/admin/PopulateManagedSchema.aspx?indexes=all
[UpdateSolrSchema]:[Success] Completed Request
[TIME] 00:04:11
Transcript stopped, output file is C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration\sitecore-xp0.190423 (13).log
PS C:\Training\Sitecore XP0\Sitecore XP0\Sitecore 9.0.0\configuration>