Commerce Server Blog

In last two articles, we have seen what is commerce server staging and how it works. Check below links for more details.

http://microsoftblog.co.in/commerceserver/introduction-to-commerce-server-staging-2/

http://microsoftblog.co.in/commerceserver/how-commerce-server-staging-works/

In this article, we will see what are the security (access privileges ) consideration we should consider to staging service accounts. Microsoft CS team has provided some recommendations on this. I have seen in couple of implementations, the entire stating is executed on the service account which has admin privileges, which is not recommended. Here are the set of privileges a staging Service account should have.

Here are the set of privileges, AD groups (css administrators and css operators accounts) should have -

Note: Since staging doesn’t do any operations on <site>_transactions, there is no need of giving access to staging service account to this database.

To make developer life easier, I have created SQL scripts which provides proper access to the service accounts.

If you are using commerce server 2007/2009 on 64 bit machine and used pipeline component registration wizard to register pipeline components and if we try to open 64 bit pipeline editor, you may not see your component rather you will see "<<unknown>>” message. This issue occurs because Pipereg.exe cannot recognize 64-bit architecture. To resolve this issue, follow below steps.

• Use the 64-bit version of the Assembly Registration tool (Regasm.exe) to prepare the custom pipeline components for registration(C:\Windows\Microsoft.NET\Framework64\v2.0.50727). So, open Open a command prompt, Change default installation folder for the .NET Framework and run below command.
  regasm MyAssemblyComp.dll /tlb:MyAssemblyComp.tlb 
• Use Pipereg.exe to register the type library file that you created in above step. Make sure that you select the Export registration data option to export the registry information to a .reg file. 
• At a command prompt, run the .reg file that you created above or run the .reg file directly from Windows Explorer.

If you check, the custom pipeline components appear correctly in the 64-bit version of Pipeline Editor. 

Optional: If you still have the issue then you can use Microsoft regcleaner tool to clean the unnecessary registry entries from the system and perform above steps again. Warning Serious problems might occur if you opt this method and you reinstall the operating system. No one (including Microsoft) cannot guarantee that these problems can be solved. So, modify the registry at your own risk.

In the previous post, I explains the core CS staging concepts and if you have not yet viewed , click below link for more detail.
http://microsoftblog.co.in/commerceserver/how-commerce-server-staging-works/

In this article, we will learn how staging works. When you install commerce server staging (Note: staging is part of CS enterprise version), a service named “Commerce Server Staging” is installed and you can see it in services MMC. When ever we start a staging project, the replication (during transit, CS encrypts data using SHA algorithm) will happen under this account credentials. So, make sure you don’t run this service under network or local account instead run it under domain account. Apart from the service, three groups are created on the server and each group has it’s own significance.

• CSS_SG: commerce server staging service group have operator access to all projects. So, the service account under which the staging service runs is to be part of this group.
• CSS_Operators: commerce server operator group have operator access to manage projects.

• CSS_Administrators: commerce server administrators group have administrative access.

The below table explains security permissions between the groups.

The users can able to access projects and routes in Staging MMC only if they are part of CSS_Operators or CSS_Administrators and make sure proper access to databases. I will explain more about sql security in my upcoming articles.

The below diagram explains how stage data is moved from source CSS server to destination CSS server.

• The staging operation starts when the user trigger project execution. Project execution can be done manually either through staging MMC or staging command line utility (CSS.EXE) or the execution process can be scheduled to run on a particular time/date.

• Based on the project name, CSS process loads information from configuration settings and initiates the process.
• Based on the destination settings, the source CSS informs all destination CSS systems about the execution so that they are aware and do the necessary imports.
• Based on setting, the data is extracted from commerce server or web folder or IIS.
• Once extract is done, the extracted data is moved to destination folders. Here Staging encryptions data using SHA algorithm so that the data transferred happens securely.
• Once the files are copied to the destination folder, the destination CSS loads the configuration and start importing data.

I have seen couple of post in MSDN forums asking help to extend payment methods in commerce server. In CS2007, the process is simple but in CS2009 and if you are using SharePoint extensibility kit then the process is much more complex but can be easily achievable. Note that current extensibility kit only supports credit card payment type and to make cheque payment work, we have to do changes in the respective

The basic steps for this are:

• Create the underlying SQL Server data store to store “Cheque” details (preferable create in XXX_transaction table). This involves creating the tables in the data store.
• Create Cheque class with the list of properties to hold Cheque information.
• Configure the assembly information (where Cheque class exist) in Web config.
• Configure the Fields information in Order Mapping xml file.
• Configure the Fields information in Order Pipeline.
• Execute OrderMapping tool, which creates required stored procedures (as output file) based on the configuration files (order mapping, web.config and order pipeline) . Execute the generated stored procedures in data store (in XXX_transaction table).
• Create Cheque class which extends entity class. This class is used by CS2009 Foundation classes .
• Create Translators and PaymentResponseBuilders (Operation Sequence Component)
• Create further mappings for Commerce Entities in the MetadataDefinitions.xml file
• Modify ChannelConfiguration file and create entries for newly created Translators and Responsebuilders.
• Modify the extensibility code (Create C# helper classes etc…) wherever required. Note that current extensibility kit only supports credit card payment type and to make cheque payment work, we have to do changes in the respective files which I didn’t mention here.
• Above steps helps us to store cheque values in database and the process of creating business process is same in commerce server 2007 and 2009.
  • Create a new pipeline component named “ChequePayment” and implement your business process.
  • Open customer and order manager and create a new payment type – “Cheque”.

Hope this high level approach gave birds view of what to do and if you need in depth knowledge, feel free to contact me. Similarly I have blogged the steps involved in line item.

http://microsoftblog.co.in/commerceserver/steps-involved-in-extended-commerce-server-2009-systems/

Commerce server staging (in short CSS), helps us to transfer and update business data and web site content from one environment to another environment.  In the nutshell, CSS provides following functionality.

• Remotely administer servers and projects.
• Replicate web site content or business data over LAN and through firewalls (TCP port 507).
• You can deploy content or data manually or on pre-determined schedule.
• Replicate IIS metadata
• Configure scripts and/or batch files to run before or after content or data is replicated.

Few things to make note of:

• Business data includes catalog schema and data, Marketing data, site terms, order configuration.
• You can’t stage/ replicate profile schema, profile data, inventory schema, order data, direct mailer job, lists and confirguration.
• All business data types supported by CSS can refresh site cache.
• Web Content, includes HTML, images, ASP.NET pages, commerce server pipelines and other files, IIS metadata.
• IIS meta data includes information about the files in the website and its configuration.
• Make sure TCP port 507 is open in order staging site work.
• Roll back feature is applicable to web content deployment only.

The below diagram explains how staging works. In CSS, we have three types of servers.

• Source staging server – this is the server from where the content & data is deployed.
• End point server – this is the server to which the content & data is deployed.
• Way point server – this server is used to relay the content & data from source staging server to end point server.

In the below diagram demonstrates how the data is moved from one environment to another environment. The CSS service can be installed on dedicated box or on all environment servers.

In order to understand CSS, you have to learn two concepts – one is project and another one route. A CSS project defines the properties of a CSS deployment and it takes few key properties like, name, type (content deployment or business data deployment) and project source (path where the data is staged). Some of the points we have to remember while creating a project.

• A project needs to be created in each CSS server involved in staging. (The above diagram, we are using single CSS server for all deployments).
• Project name should be same for all CSS servers (this will not accept special characters including space) and the properties may differ from one project to other.
• Project properties tells the purpose of staging.
• Project type must be same for the same projects across CSS servers. For example, if the project at source staging server is “web deployment” then the end point server project type should be the same.

A route in CSS signifies a path by which the data is moved from source to destination. A route will hold few properties such as route name, local directory to store the data and the destination server. As CSS project, route is also required to have few mandatory settings in order to work and they are

• A route needs to be created in each CSS server involved in staging.
• Route name should be same for all CSS servers .

Note: Defining a route is not compulsory for a given deployment. In majority of the deployments, I have seen, we have created CSS projects without routes. This is applicable if the source server can’t access the destination server directly.

In coming posts, I will try to explain how commerce server staging works, command line tools and how can we write scripts to make the deployment easier.