Installing EpiServer Community on a commerce site

Installing EPiServer relate on an EPiServer CMS 7 site working with EPiServer Commerce can be a challenge, This post can be helpful for those who are trying to do this or facing issue in installing other EPiServer products.

 Technologies under discussion are
EPiServer CMS 7.1,
EPiServer Commerce 1 R3
EPiServer Relate+ 7

 Issue: Installing Commerce and Relate (Community) is a no go
http://world.episerver.com/Support/Bug-list-beta/bug/95414/
Issue details:
An unhandled error has occured:
 The argument is null or empty. Supply an argument that is not null or empty and
 then try the command again.
When executing
At C:\Program Files (x86)\EPiServer\CommonFramework\7.0.844.1\Install\System Sc
 ripts\Upgrade Site.ps1:93 char:17
+ -SqlServerName <<<< $properties.DatabaseServerName `

  An unhandled error has occured:
 The argument is null or empty. Supply an argument that is not null or empty and
 then try the command again.
When executing
At C:\Program Files (x86)\EPiServer\CommonFramework\7.0.844.1\Install\System Sc
 ripts\Upgrade Site.ps1:93 char:17
+ -SqlServerName <<<< $properties.DatabaseServerName `
=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CommonFramework\7.0.844.1\Install\System Scripts\Upgrade Site.ps1:93 char:17
 + -SqlServerName <<<< $properties.DatabaseServerName `
System.Management.Automation.ParentContainsErrorRecordException: Cannot validate argument on parameter 'SqlServerName'. The argument is null or empty. Supply an argument that is not null or empty and then try the command again.

Possible Solutions:
Solution 1:
  • Follow process for installing CMS 7, Relate, Commerce
  • Install Site with database, with Commerce and the sample site
  • Install a Relate site and note references. 
  • Add the same references to the Commerce site
  • Copy and paste Community/Mail related sections of web.config in the Relate site to the commerce web.config
  • Find the install database script in the install directory for Relate, run the script against the site database to create the Community tables.
(I will write a separate post that how we can merge a community data base with a CMS database.)

Solution 2: STAR Solution, I tried a different approach that can be used in other setup related issues also. 
  • Find the issue in PS1
  • Fix the issue in PS1 File.
  • Remove the Signature At the bottom of the site. e.g # SIG # Begin signature block ................................................... # SIG # End signature block
  • Now File is no longer signed therfore we will need some power shell policy adjustments.
  • PS C:\Users\tobias> Set-ExecutionPolicy 'unrestricted'
  • Set-ExecutionPolicy -scope CurrentUser -executionPolicy Unrestricted
  • Re-Run the setup and fix the other Issues.

I tried this approach to solve some issues while installing Commerce on a hosting server also.



Comments

  1. Kim S22 October 2013 at 01:06

    This comment has been removed by the author.

    ReplyDelete
  2. Kim S22 October 2013 at 01:08

    Hi,

    I have the same issue trying to install commerce to a CMS (mvc) site.

    Could you elaborate a bit on what the issue in the PS1 file is? Is the property wrong or have you just hardcoded a db name?

    Thanks in advance!

    ReplyDelete
    Replies
    1. Khurram Khan4 December 2013 at 02:16

      Hi Kim, Sorry for late reply, Yes you just have to hard code this, somehow values defined through setup are not picking at this point.
      Regards
      /K

      Delete

Post a Comment

Popular posts from this blog

POC custom pricing provider works

In most ecommerce websites, prices comes from some third system and we import the prices into EPiServer Commerce along with products and variants data, but this is not the case all the time. In some scenarios pricing are quite complex and have to decide at run time or require to retrieve from some web services. A custom pricing provider can be built to support these kind of scenarios. we are require to implement IPriceService for read only prices and IPriceDetailService for Editing prices. We will be require to register these service in structure map e.g. services.AddSingleton< IPriceService, CustomPriceService >(); Find the POC on GIST
Read more

EPiServer CMS 11 Useful SQL Queries - 1

Here is a set of few queries that we have been using in different investigations Check How Big is your Database Get Data for Each Property and from Each Content Type Complete Tree Structure of your web site Check EPiServer DB Version Check How Big is Database SELECT      t.NAME AS TableName,     s.Name AS SchemaName,     p.rows AS RowCounts,     SUM(a.total_pages) * 8 AS TotalSpaceKB,      CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,     SUM(a.used_pages) * 8 AS UsedSpaceKB,      CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,      (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,     CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB FROM      sys.tables t INNER JOIN           sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN      sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INN
Read more

EPiServer CMS 11 Useful SQL Queries - 2

Here is a set of few queries that we have been using in different investigations Get usages of EPiServer contents including pages and blocks Check Table size No contents have been added for following content types Looking into Activity Logs Unmapped Property List Get usages of EPiServer contents including pages and blocks SELECT   tct.Name,    tct.ModelType,    COUNT(tc.pkID) AS PageCount FROM   tblContent AS tc RIGHT OUTER JOIN   tblContentType AS tct ON tc.fkContentTypeID = tct.pkID Where tct.ModelType is not null and tct.ModelType not like 'EPiServer.%' GROUP BY   tct.Name, tct.ModelType ORDER BY  PageCount desc Check table size EXEC sp_spaceused 'tblBigTable' No contents have been added for following content types SELECT   tct.Name,    tct.ModelType FROM   tblContent AS tc RIGHT OUTER JOIN   tblContentType AS tct ON tc.fkContentTypeID = tct.pkID Where tct.ModelType is not null and tct.ModelType not like 'EPiServer.%' GROU
Read more