Commerce Server 2009 Forum

Remove LineItem Grouping

Tue, 24 Nov 2009 18:49:36 Z

Out of the box if I add the same product to my cart twice the system just increases the count of the existing line items in the cart.

What I would like to do is create a new line item in the basket even if it already exists.

Does anyone know if this is possible and what might be the best way to implement it.

Store objects query

Wed, 25 Nov 2009 07:47:01 Z

Hi!

I would like to make a query to receive all store objects I have defined in CS2009.

I have tried to make query like this:

var queryStoreProfile = new CommerceQuery<CommerceEntity>("StoreProfile");
queryStoreProfile.SearchCriteria.Model.Id = "mystoreitemid";
CommerceResponse response = SiteContext.ProcessRequest(queryStoreProfile.ToRequest());

This query will return one storeprofile just like I want it to do. But I don't want to make a query to use id.
When i try to change query to fill my needs, everything fails.

var queryStoreProfile = new CommerceQuery<CommerceEntity>("StoreProfile");
queryStoreProfile.SearchCriteria.Model.ModelName = "StoreProfile";
CommerceResponse response = SiteContext.ProcessRequest(queryStoreProfile.ToRequest());

This will not work and there is a mention about this in documentation http://msdn.microsoft.com/en-us/library/dd452374(CS.90).aspx
Like the documentation says I have to define either Id or ModelName to query and ModelName cannot be StoreProfile. How can I make the query to work?

Would it be possible to make a query based on property:

var queryStoreProfile = new CommerceQuery<CommerceEntity>("StoreProfile");
queryStoreProfile.SearchCriteria.Model.Properties["Longitude"]= "66";
CommerceResponse response = SiteContext.ProcessRequest(queryStoreProfile.ToRequest());

When I'm not using Id in query I will every time get exception:

Message : The operation could not be performed because the search criteria Model is not valid. The search criteria Model must contain exactly one property that maps to a Commerce Server profile property defined as a primary, join, or unique key.

Is there a way to get data I need with OOB API or do I have to make custom functionalities to get data I need? This might not be a big issue but I'm just a newbie with CS2009. ;-)

-Antti

Multi development enviornment for Commerce server when creating the SOA

Wed, 25 Nov 2009 10:57:26 Z

what are basic setup required at devloper machines when we are creating SOA envoirnment for commerce server 2009

Vijay Sagar

Commerce Server Discounts

Wed, 25 Nov 2009 17:02:37 Z

Hi,

We are in the process of creating our own custom discounts. What we want to be able to do is establish whether our own discount or the commerce server discount gives the best price and use that one.

In order to do this we suspect we woudl have to insert a custom pipeline component to run our discounts but we would want to do this on the unchanged basket. In other words we would want to run the appropriate pipeline and identify the complete discounts applied then 'rollback' the commerce server discounts and run our own custom one.

Is there anyway to 'undo' commerce server discounts and restore the basket to its pre-state?

Thanks in advance

Multi language Login Page

Fri, 13 Nov 2009 11:47:48 Z

Its strange i cant find anything about this, i might be searching the wrong way, because this shoulb be a common request i guess...

I have Commerce Server 2009 on SharePoint, CS uses FBA and it points to: /_layouts/CommerceServer/ContemporaryLoginPage.aspx?

This loginpage has all text comming from resources, we have translated the resources but for the login page we have everything in english... (because loginpage is under _layouts/ probably and not in a variation.

So what can i do?

Duplicate the login.aspx and translate it (then in webconfig i must be able to give 2 login pages?? or just one that redirects the the right one

or another way that the right resx is loaded up based on the browser config?

Or some other way?

Tks

http://pontodepartilha.blogspot.com

Relation between Profile Database and Transaction Database of Commerce Server?

Tue, 24 Nov 2009 15:15:17 Z

I have to create a WCF service over Commerce Server Database for Full-fillment system.
That Service will read the data from Profile and Transaction database and send XML of Newly created (Not fullfill) orders to a 2nd Service.

The issue I am facing is "I am not able to find UserID/user detail in Transaction Database tables (LineItems and OrderForms).
Please let me know How Commerce Server is maintaining this relationship and how to get this information i.e "which Order belongs to which Customer?".

Thanks for your help.

Regards
Sudhanshu Bhatnagar

Error importing object data for Product Catalog from file <...>Product Catalog 80131904:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Thu, 19 Nov 2009 11:09:23 Z

I am getting errors trying to unpack and create ContemporarySite.

We get the same errors using the wizard or the pup directly...Are they related to any thing we should rollback?

These are the errors:

Error importing object data for Product Catalog from file C:\Users\user\AppData\Local\Temp\2\Product Catalog 80131904:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Error importing object data for Transactions from file C:\Users\user\AppData\Local\Temp\2\Transactions 80131904:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Error importing object data for Transaction Config from file C:\Users\user\AppData\Local\Temp\2\Transaction Config 80131904:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Error importing object data for Marketing from file C:\Users\user\AppData\Local\Temp\2\Marketing 80131904:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Error importing object data for Inventory from file C:\Users\user\AppData\Local\Temp\2\Inventory 80131904:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

http://pontodepartilha.blogspot.com

How to get most recent X orders?

Sun, 22 Nov 2009 06:33:51 Z

I'm looking to display to the user some info from the last 3 orders. I'm sort of using the SharePoint commerce server extensions, but am finding that I need to do a lot of copying and pasting into my own libraries. I'm still learning the API and could do this in SQL but can't figure out how to do this with the search api. The OrderController has a method but will only get the orders back for a certain date range.

any ideas?

Thanks,
Corey

Post migration question CS 2002 - CS 2009

Thu, 24 Sep 2009 19:45:23 Z

I found that after I completed the CS 2009 Upgrade wizard step for all of the CS resources that I did not have a marketing_lists table. But instead I still had the campaign table. the DB connection string located in the Marketing resource indicates that the mailing lists will continue to use the campaign table. Is this correct? I guess I expected to see a new marketing_list table with the prevous lists migrated there.

Error importing object data for Product Catalog from file C:\Users\******\AppData\Local\Temp\Product Catalog 80131500:Line Number 0 : Cannot open log for source 'Commerce Server Catalog'. You may not have write access.

Fri, 20 Nov 2009 15:31:29 Z

Hi
I am facing issue while creating the Commerce Server site using "Microsoft Sharepoint commerce Service Configuration Wizard."
It is creating all the databases.

Softwares on the Server:
Windows 2008
IIS 7.0
Commerce Server 2007 Enterprise Edition
Commerce Server 2009 Enterprise Edition
WSS 3.0 with SP2
Visual Studio 2008 with SP2

My SQL Server 2008 (with Instance ServerName\InstanceName) on different Server

I am admin on Server on which Commerce Server is installed.
I have DB Creation Permissions on SQL Server (but not sysAdmin)

At the same time I am facing 2 more issue related to WSS:

1. When I am running "SharePoint Products and Technologies Configuration" wizard; it stopes at 8th Step and showing the Error Message with no valid error message it's something "Window is getting closed." .
It creates SharePoint Configuration databases and all the Central Admin starts running.

2. I am getting warning of "Check for Sharepoint Infrastructure Update: failed" on "Microsoft Sharepoint Commerce Service Configuration Wizard". Even I have installed all the pre-requisite softwares.

Please let me know what needs to be done for resolving these issue.
I will be very great full to you guys.

Below are the details of Pup.log file
**************************************************************************************************************************
[10:01:37] Initializing...
[10:01:37] The cmdline used to launch the packager: /u /f:MicrosoftCommerceDefaultSiteNoData.pup /i:e:\Program Files\Commerce2009\Microsoft Commerce Server 2009\Site\eStore_settings.ini
[10:01:37] IIS Entry #1 Name:Default Web Site Path:C:\inetpub\wwwroot
[10:01:37] IIS Entry #151768767 Name:SharePoint Central Administration v3 Path:C:\inetpub\wwwroot\wss\VirtualDirectories\43689
[10:01:37] IIS Entry #2015432674 Name:eStore Commerce Site Path:C:\inetpub\wwwroot\wss\VirtualDirectories\1259
[10:01:37] IIS Entry #1060659026 Name:SharePoint - 11312 Path:C:\inetpub\wwwroot\wss\VirtualDirectories\11312
[10:01:37] IIS Entry #1060333348 Name:eStore Path:C:\inetpub\wwwroot\wss\VirtualDirectories\9917
[10:01:37] IIS Entry #972354044 Name:SharePoint - 12116 Path:C:\inetpub\wwwroot\wss\VirtualDirectories\12116
[10:01:37] Silent Mode : Extracting information from INI file mentioned in command line.
[10:01:37] Opening a compound document
[10:01:37] Getting package INI file
[10:01:37] Extracting Config stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\TOC.ini file
[10:01:37] Path of package: MicrosoftCommerceDefaultSiteNoData.pup
[10:01:39] Creating SiteConfig for eStore
[10:01:40] Database eStore_profiles was created on SPCSDSQ001\SQL01.
[10:01:40] Database eStore_productcatalog was created on SPCSDSQ001\SQL01.
[10:01:40] Database eStore_marketing_lists was created on SPCSDSQ001\SQL01.
[10:01:40] Database eStore_marketing was created on SPCSDSQ001\SQL01.
[10:01:40] Database eStore_productcatalog was not created on SPCSDSQ001\SQL01 because it already exists.
[10:01:40] Database eStore_transactionconfig was created on SPCSDSQ001\SQL01.
[10:01:40] Database eStore_transactions was created on SPCSDSQ001\SQL01.
[10:01:40] Adding config data for Product Catalog
[10:01:40] Extracting Config stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Product Catalog_Config.blb file
[10:01:40] Extracting object data for Product Catalog from Config
[10:01:40] Asking for a connection string for Product Catalog
[10:01:40] Getting object data for Product Catalog from stream Data
[10:01:40] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Product Catalog.blb file
[10:01:40] Unpacking files for Product Catalog
[10:01:40] Unpacking the site files.
[10:01:40] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Product Catalog.blb
[10:01:40] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Product Catalog.blb" "C:\Users\bhatns\AppData\Local\Temp\Product Catalog\
[10:01:41]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Product Catalog.blb':
extracting: C:\Users\bhatns\AppData\Local\Temp\Product Catalog\\CatalogPup.xml

Operation successful

[10:01:41] File decompression is complete
[10:01:45] Error importing object data for Product Catalog from file C:\Users\bhatns\AppData\Local\Temp\Product Catalog 80131500:Line Number 0 : Cannot open log for source 'Commerce Server Catalog'. You may not have write access.
The RPC server is unavailable
[10:01:45] Adding config data for Transactions
[10:01:45] Extracting Config stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Transactions_Config.blb file
[10:01:45] Extracting object data for Transactions from Config
[10:01:45] Asking for a connection string for Transactions
[10:01:45] Getting object data for Transactions from stream Data
[10:01:45] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Transactions.blb file
[10:01:45] Unpacking files for Transactions
[10:01:45] Unpacking the site files.
[10:01:45] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Transactions.blb
[10:01:45] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Transactions.blb" "C:\Users\bhatns\AppData\Local\Temp\Transactions\
[10:01:46]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Transactions.blb':
extracting: C:\Users\bhatns\AppData\Local\Temp\Transactions\\TransactionMetaData.xml

Operation successful

[10:01:46] File decompression is complete
[10:01:47] Adding config data for Transaction Config
[10:01:47] Extracting Config stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Transaction Config_Config.blb file
[10:01:47] Extracting object data for Transaction Config from Config
[10:01:47] Asking for a connection string for Transaction Config
[10:01:47] Getting object data for Transaction Config from stream Data
[10:01:47] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Transaction Config.blb file
[10:01:47] Unpacking files for Transaction Config
[10:01:47] Unpacking the site files.
[10:01:47] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Transaction Config.blb
[10:01:47] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Transaction Config.blb" "C:\Users\bhatns\AppData\Local\Temp\Transaction Config\
[10:01:48]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Transaction Config.blb':
extracting: C:\Users\bhatns\AppData\Local\Temp\Transaction Config\\TransactionConfigData.xml

Operation successful

[10:01:48] File decompression is complete
[10:01:48] Extracting object data for Biz Data Service from Config
[10:01:48] Getting object data for Biz Data Service from stream Data
[10:01:48] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Biz Data Service.blb file
[10:01:48] Unpacking files for Biz Data Service
[10:01:48] Unpacking the site files.
[10:01:48] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Biz Data Service.blb
[10:01:48] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Biz Data Service.blb" "C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\
[10:01:49]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Biz Data Service.blb':
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\BizData.ini
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\es_create.sql
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\es_stored_procs.sql
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\ExpressionDefinition.xml
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\ProfileDefinition.xml
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\SCHEMAUPM_SQLSource.SQLSource.sql
   extracting: C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\\SiteTerms.xml

Operation successful

[10:01:49] File decompression is complete
[10:01:49] Creating global resource for Biz Data Service

Time=Wednesday, November 18, 2009 10:01:49 Site=eStore Resource=Biz Data Service Function=CIniFileHelper::ReadValue(LPCOLESTR pszKeyName,bool &bValue)
Key name: IsSilentMode Value read:.
Time=Wednesday, November 18, 2009 10:01:49 Site=eStore Resource=Biz Data Service Function=(null)
Bizdata.ini file path= C:\Users\bhatns\AppData\Local\Temp\Biz Data Service\BizData.ini
Time=Wednesday, November 18, 2009 10:01:49 Site=eStore Resource=Biz Data Service Function=(null)
Silent mode parameter: true ; IsSilentMode Ini file setting: true; Validate CatalogStore connection: true;
Time=Wednesday, November 18, 2009 10:01:50 Site=eStore Resource=Biz Data Service Function=CIniFileHelper::ReadValue(LPCOLESTR pszKeyName,bool &bValue)
Key name: IsSilentMode Value read:.
Time=Wednesday, November 18, 2009 10:01:50 Site=eStore Resource=Biz Data Service Function=CIniFileHelper::ReadValue(LPCOLESTR pszKeyName,bool &bValue)
Key name: IsBizDataStore Value read:true.
Time=Wednesday, November 18, 2009 10:01:50 Site=eStore Resource=Biz Data Service Function=(null)
bInitSuccess:true bSilent:true bIniExists:true[10:01:56] Extracting object data for Site CS Authentication from Config
[10:01:56] Getting object data for Site CS Authentication from stream Data
[10:01:56] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication.blb file
[10:01:56] Unpacking files for Site CS Authentication
[10:01:56] Unpacking the site files.
[10:01:56] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication.blb
[10:01:56] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication.blb" "C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication\
[10:01:57]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication.blb':
extracting: C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication\\AuthSetup.ini

Operation successful

[10:01:57] File decompression is complete
[10:01:57] Creating global resource for Site CS Authentication

Time=Wednesday, November 18, 2009 10:01:57 Site=eStore Resource=Site CS Authentication Function=CIniFileHelper::ReadValue(LPCOLESTR pszKeyName,bool &bValue)
Key name: UseAutoCookie Value read:false.
Time=Wednesday, November 18, 2009 10:01:57 Site=eStore Resource=Site CS Authentication Function=CIniFileHelper::ReadValue(LPCOLESTR pszKeyName,bool &bValue)
Key name: EncryptData Value read:true.
Time=Wednesday, November 18, 2009 10:01:57 Site=eStore Resource=Site CS Authentication Function=CIniFileHelper::ReadValue(LPCOLESTR pszKeyName,bool &bValue)
Key name: PerSiteCookie Value read:true.
Time=Wednesday, November 18, 2009 10:01:57 Site=eStore Resource=Site CS Authentication Function=(null)
Path as parameter= C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication; Authsetup.ini File location= C:\Users\bhatns\AppData\Local\Temp\Site CS Authentication\AuthSetup.ini; Silent mode parameter= true
[10:01:57] Adding config data for Marketing
[10:01:57] Extracting Config stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Marketing_Config.blb file
[10:01:57] Extracting object data for Marketing from Config
[10:01:57] Asking for a connection string for Marketing
[10:01:58] Asking for a connection string for Marketing
[10:01:58] Getting object data for Marketing from stream Data
[10:01:58] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Marketing.blb file
[10:01:58] Unpacking files for Marketing
[10:01:58] Unpacking the site files.
[10:01:58] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Marketing.blb
[10:01:58] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Marketing.blb" "C:\Users\bhatns\AppData\Local\Temp\Marketing\
[10:01:59]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Marketing.blb':
extracting: C:\Users\bhatns\AppData\Local\Temp\Marketing\\MarketingData.xml

Operation successful

[10:01:59] File decompression is complete
[10:02:04] Adding config data for Inventory
[10:02:04] Extracting Config stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Inventory_Config.blb file
[10:02:04] Extracting object data for Inventory from Config
[10:02:04] Asking for a connection string for Inventory
[10:02:04] Getting object data for Inventory from stream Data
[10:02:04] Extracting Data stream contents and putting in C:\Users\bhatns\AppData\Local\Temp\Inventory.blb file
[10:02:04] Unpacking files for Inventory
[10:02:04] Unpacking the site files.
[10:02:04] Unpack : The CAB file getting extracted is : C:\Users\bhatns\AppData\Local\Temp\Inventory.blb
[10:02:04] The following command is being executed to decompress a file from the package: "e:\Program Files\Commerce2009\cabarc.exe" -p -r -o X "C:\Users\bhatns\AppData\Local\Temp\Inventory.blb" "C:\Users\bhatns\AppData\Local\Temp\Inventory\
[10:02:05]
Microsoft (R) Cabinet Tool - Version 5.2.3663.0
Copyright (c) Microsoft Corporation. All rights reserved..

Extracting file(s) from cabinet 'C:\Users\bhatns\AppData\Local\Temp\Inventory.blb':
extracting: C:\Users\bhatns\AppData\Local\Temp\Inventory\\InventoryPup.xml

Operation successful

[10:02:05] File decompression is complete
[10:02:07] Operation Completed
[10:02:07] Starting Cleanup
[10:02:07] Cleanup finished.
[10:02:07] Program ending.
[10:02:07] Exit status code for this session: -1

Navigation doesn't work anymore

Mon, 23 Nov 2009 09:10:47 Z

Hello,

Our navigation for the webshop doens't work anymore
When we want to go to the site, I get the following error;

The DataSourceID of 'CurrentNav' must be the ID of a control of type IHierarchicalDataSource. A control with ID 'SiteMapDS' could not be found.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The DataSourceID of 'CurrentNav' must be the ID of a control of type IHierarchicalDataSource. A control with ID 'SiteMapDS' could not be found.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): The DataSourceID of 'CurrentNav' must be the ID of a control of type IHierarchicalDataSource.  A control with ID 'SiteMapDS' could not be found.]
   System.Web.UI.WebControls.HierarchicalDataBoundControl.GetDataSource() +2332337
   System.Web.UI.WebControls.HierarchicalDataBoundControl.ConnectToHierarchicalDataSource() +212
   System.Web.UI.WebControls.HierarchicalDataBoundControl.OnLoad(EventArgs e) +28
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

And I use the following code in the masterpage;

      
      <SharePoint:AspMenu ID="CurrentNav" runat="server" datasourceID="SiteMapDS" orientation="Vertical"
                      StaticDisplayLevels="3"
                      MaximumDynamicDisplayLevels="1"
                      ItemWrap="true" AccessKey="3"
                      CssClass="Skin_Menu"
                      StaticMenuItemStyle-VerticalPadding="3px"
                      SkipLinkText="<%$Resources:defaultSite,masterpages_skiplinktext%>"
          StaticHoverStyle-CssClass="Skin_MenuItemHover">

                <LevelMenuItemStyles>
                    <asp:MenuItemStyle CssClass="Skin_MenuHeader" />
                    <asp:MenuItemStyle CssClass="Skin_MenuItem" />
                </LevelMenuItemStyles>

      </SharePoint:AspMenu>

I hope somebody know what is wrong or what is missing.

Thanks!
Stefan

adding a new aspx page

Wed, 18 Nov 2009 11:20:17 Z

Hi , Please help me on how to create a new aspx page and i want to insert this page in middle of some other pages in CommerceSharepoitExtensibiltyKit default solution.

I know this solution is built based on ASP.NET MVC and MVP pattern , but still strugling.

Could any one help me on this?

Is there any documentation available like explaining the each item in the Extensibility kit?

commerce server R2

Sat, 21 Nov 2009 06:11:25 Z

Any body know the expected release time of Commerce Server R2?

Thanks,

Sam

Using another service for user data

Thu, 19 Nov 2009 18:26:04 Z

Is it possible to use a third party for user data? They expose several webservices, and they store pretty much all the data i need to store on a user. What would be involved if it was possible?

Thanks,
Jason

Problems using a newly created catalog in new blank site (Commerce Server)

Fri, 20 Nov 2009 14:18:39 Z

I have created a blank site by using "SharePoint Commerce Service Configuration Wizard".
* Hosted all 4 WebServices (oreders, catalog, marketing and profiles) in my site and given admin access to each service via AZMAN.MSC (Running successful)
* Successfully opened all these connection in All Commerce Server Business Application
* Created a Catalog for my site in Catalog Manager.
* Configured site with new Catlog Definition in Channel Configuration.
* Updated Web.Config for site

ALL THESE STEPS WERE REPEATED similar to website (except new catalog) hosted for Sample Web site (Adventure Works).

PROBLEM

When I try to use this new created catalog I get an error message about trying to use this catalog, and the following entry appears in Event Viewer:

======================================================================

An exception of type 'Microsoft.CommerceServer.Catalog.CatalogDatabaseException' occurred and was caught.

---------------------------------------------------------------------------------------------------------

11/20/2009 19:26:03

Type : Microsoft.CommerceServer.Catalog.CatalogDatabaseException, Microsoft.CommerceServer.Catalog, Version=6.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

Message : Could not get the root categories for the catalog.

Source : Microsoft.CatalogServer

Help link :

EntityName : dbo.ctlg_GetRootCategories

EntityType : StoredProcedure

Data : System.Collections.ListDictionaryInternal

TargetSite : Microsoft.CommerceServer.Catalog.CatalogItemsDataSet GetRootCategories(Microsoft.CommerceServer.Catalog.Internal.ExecutionContext, System.String, Boolean, System.String, Microsoft.CommerceServer.Catalog.CatalogSearchOptions, Boolean, Int32 ByRef)

Stack Trace : at Microsoft.CommerceServer.Catalog.Internal.CatalogProducts.GetRootCategories(ExecutionContext executionContext, String catalogName, Boolean isVirtualCatalog, String language, CatalogSearchOptions searchOptions, Boolean getFromCache, Int32& totalRecords)

at Microsoft.CommerceServer.Catalog.Internal.Category.GetChildCategories(CatalogExecutionContext context, String baseCatalogName, Boolean isVirtualCatalog, String catalogName, String categoryName, Int32 oid, CatalogSearchOptions searchOptions, Boolean recursive, String language, Boolean getFromCache, Int32& totalRecords)

at Microsoft.CommerceServer.Catalog.Internal.Category.GetChildCategories(CatalogExecutionContext context, String baseCatalogName, Boolean isVirtualCatalog, String catalogName, String categoryName, Int32 oid, CatalogSearchOptions cso, String swc, String language, Boolean recursive, Boolean getFromCache, Int32& totalRecords)

at Microsoft.CommerceServer.Catalog.Internal.Category.PreLoadCategory(CatalogExecutionContext context, Category category, CategoryConfiguration config, Boolean getFromCache, Boolean relationshipsExist)

at Microsoft.CommerceServer.Catalog.Internal.Category.GetCategoryData(CatalogExecutionContext catalogExecutionContext, String catalogName, String categoryName, String language, Nullable`1 isVC, Nullable`1 validateLanguage, CategoryConfiguration config, Boolean getFromCache)

at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config, Boolean getFromCache, Nullable`1 isVirtualCatalog, Nullable`1 validateLanguage)

at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config)

at Microsoft.CommerceServer.Catalog.Category.Get(CatalogContext catalogContext, String catalogName, String categoryName, String language, CategoryConfiguration config, Nullable`1 isVirtualCatalog, Nullable`1 validateLanguage)

at Microsoft.CommerceServer.Catalog.Category.Get(CatalogContext catalogContext, String catalogName, String categoryName, String language, CategoryConfiguration config)

at Microsoft.CommerceServer.Catalog.CatalogContext.GetRootCategory(String catalogName, CategoryConfiguration config)

at Microsoft.Commerce.Providers.CSHelpers.CatalogHelper.GetCategory(String siteName, String catalogName, String locale, String categoryName, CategoryConfiguration categoryConfiguration)

at Microsoft.Commerce.Providers.Components.CategoryLoader.ExecuteQuery(CommerceQueryOperation queryOperation, OperationCacheDictionary operationCache, CommerceQueryOperationResponse response)

at Microsoft.Commerce.Providers.Components.OperationSequenceComponent.Execute(CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)

at Microsoft.Commerce.Broker.OperationSequence.ExecuteComponentTree(List`1 executionTreeList, CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)

at Microsoft.Commerce.Broker.OperationSequence.Execute(CommerceOperation operation)

at Microsoft.Commerce.Broker.MessageHandler.ProcessMessage(String messageHandlerName, CommerceOperation operation)

at Microsoft.Commerce.Broker.OperationService.InternalProcessRequest(CommerceRequest request)

at Microsoft.Commerce.Broker.OperationService.ProcessRequest(CommerceRequest request)

Additional Info:

MachineName : WIN-7VE0NQFK1YN

TimeStamp : 11/20/2009 1:56:03 PM

FullName : Microsoft.Commerce.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

AppDomainName : /LM/W3SVC/1803929484/ROOT-1-129031941069649441

ThreadIdentity : WIN-7VE0NQFK1YN\Administrator

WindowsIdentity : WIN-7VE0NQFK1YN\Administrator

Inner Exception

---------------

Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Message : Invalid column name 'CategoryPage'.

Source : .Net SqlClient Data Provider

Help link :

Errors : System.Data.SqlClient.SqlErrorCollection

Class : 16

LineNumber : 1

Number : 207

Procedure :

Server : WIN-7VE0NQFK1YN

State : 1

ErrorCode : -2146232060

Data : System.Collections.ListDictionaryInternal

TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)

Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)

at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, CatalogDataSetType catalogDataSetType, SqlParameter[] commandParameters, String outParameterName, Object& outParameterValue)

at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(SqlConnection connection, String spName, CatalogDataSetType catalogDataSetType, Object[] parameterValues, String outParameterName, Object& outParameterValue)

at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(ExecutionContext executionContext, String spName, Object[] parameterValues, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)

at Microsoft.CommerceServer.Catalog.Internal.CatalogCache.GetDataset(ExecutionContext executionContext, CacheItemType cacheItemType, String storedProcedureName, CatalogDataSetType catalogDataSetType, Boolean getFromCache, Object[] parameters, String outParameterName, Object& recordCount, Boolean& obtainedFromCache)

at Microsoft.CommerceServer.Catalog.Internal.CatalogProducts.GetRootCategories(ExecutionContext executionContext, String catalogName, Boolean isVirtualCatalog, String language, CatalogSearchOptions searchOptions, Boolean getFromCache, Int32& totalRecords)

How to show the properties of an variant product on the product.aspx page

Thu, 19 Nov 2009 15:57:54 Z

Hello,

I've got a product with five different variant properties.
For those variant properties, i've got different custom properties.
When I choose a variant property from the dropdown box, i want to show the properties of that variant.
But how do I do that?

I can choose the simple property list web part, but I can get it only work with custom properties. All I want to do is that these propertys change when I choose an other variant property from the dropdown box.

Example dropdownbox:

Producttype:   Product Variant 1
                     Product Variant 2
                     Product Variant 3
                     Product Variant 4
                     Product Variant 5

When I choose Product Variant 2 from the dropdownbox, I want some variant properties to be changed on the product page

I hope somebody has an answer for this?!

Thanks!
Stefan

Product Query Gotcha

Fri, 20 Nov 2009 15:48:22 Z

If you are using the default product query web part that is part of the extensibility kit beware of this little gotcha that recently bit me.

I was doing some virtual catalog testing and even though my virtual catalog was hooked up to an inventory and the virtual catalog name was clearly visible in the query string I could never get an item into a basket.

Upon opening up the configuration of the ProductQuery web part I noticed that the catalog property was set to the base.

I then fired up the debugger and realized the catalog passed to the ShoppingController was actually the catalog property of the webpart not the value of query string catalog parameter.

If you look at the code for the AddToCart method of ProductQuery it clearly uses this._catalog as the parameter passed off to the shopping cart. this._currentCatalog is the variable that houses the query string parameter.

Just a heads up if you find your AddToCart button of the product query web part not working.

SCS Conf Wizard 2009 - the database specified does not have a valid commerce server database

Mon, 16 Nov 2009 12:46:27 Z

Hello,

We have followed the installation and template pack guide to the Sharepoint commerce server configuragtion wizard, it creates the web app etc, but when he starts unpacking the pup we get an error in the log of access denied, sql server does not exist or access denied, in sql profiler there are no login failures.

We are using an alias (sql is not on standard port). Its the same sql of moss.

When we give the name of the machine (we open the standard ports for testing) it gave an error right on the (Next) buttn, before the unpacking screen...

It seems that with the alias he doest 'test' the sql, only after unpacking...

Is there a problem with the wizard using alias or non standard sql ports??

In odbc we can connect to sql and test a connection, the user running wizard is has sql access, runtimeuser has sql access..

We dont know what else to try. any ideas? tks

http://pontodepartilha.blogspot.com

Looking for SharePointRoutingService examples.

Tue, 17 Nov 2009 21:31:39 Z

Does anyone have examples of using the SharePointRoutingService to get catalog data?

TYIA
Eric

Report display no data

Thu, 19 Nov 2009 13:40:50 Z

We istalled DW in our application and if we run any report which use the CSDW_olap datasource no data are dislpay. The Chartcontrol shows the Message " The value for a decimal value is too large or too small". When we run the SQL statments from this reports in the SQL Management Studio we get the right results. We had debug the reports in VS. If we run the report in VS, VS shows the warning

[rsMissingFieldInDataSet] The data set ‘xxx’ contains a definition for the Field ‘xxx’. This field is missing from the returned result set from the data source

and

[rsErrorReadingDataSetField] The data set ‘xxx' contains a definition for the Field ‘xxx’. The data extension returned an error during reading the field. There is no data for the field at position 4.

We use Windows Server 2008 x64 and SQL Server 2008 (both German version) . Can anybody help me?

Regards

Dominik

bug in documentation? Microsoft Commerce Server 2009 Installation and Configuration Guide

Wed, 18 Nov 2009 17:28:30 Z

On Page 88, to create web application, it says after creating web application access site and set anonymous On. How is that possible? Since the site collection doesn't exist yet? This should be corrected. If i misunderstood am sorry.

To create a Web application in SharePoint

1. Access SharePoint Central Administration.

2. Click Application Management, and then click Create or extend Web application.

3. Click Create a new Web application.

4. In the IIS Web Site section, select the appropriate Web site.

5. In the Security Configuration section, select the following:

· Under Authentication provider, select NTLM.

· Under Allow Anonymous, select Yes.

· Under Use Secure Sockets Layer (SSL), select No.

6. In the Application Pool section, select an application pool whose identity you will add to the Windows groups that will be able to access the site's Web services and databases. These databases are created only when you deploy the Default Site. After they are created, you will have to make sure that the identity of the application pool has the correct permissions in SQL Server. Group assignments and permissions are covered in Post-Deployment Procedures.

7. Select other options on the page that suit your business needs.

8. Click OK.

9. In Internet Explorer, access the NTLM zone of the application. The URL is as follows:

http://<host>:<port>/Pages/default.aspx

10. Allow anonymous access for the entire NTLM zone. This is required to set up the extended zone but can be turned off later. The instructions in this guide indicate when you can turn it off. Do all of the following:

· Click Site Actions, click Site Settings, and then click People and Groups.

· In the menu on the left, under All People, click Site Permissions.

· Click Settings, and then click Anonymous Access.

· Select Entire Web Site.

http://pontodepartilha.blogspot.com

Error during Creating New Profile Definition

Thu, 05 Nov 2009 08:48:34 Z

Hi All,

I have create a new profile definition for RetailerInformation . I have follow these steps properly:

1 Create table for RetailerInfo under the mysiteprofile database

2 Create DataObject underGlobalResource --> Profiles(mysiteprofile)-->ProfileCatalog-->DataSource-->profileservice_SQLSource-->DataObjects for RetailerInfo in the Commerce server manager

3 Also define the New Data Members under RetailerInfo Dataobject and map with datacoulmn which I have define in the ReatilerInfo Table.

4 Under profile Definition I create a new Profile defnition for RetailerInfo

5 Add proerties and give proper attributes to properties, under advance attribute map the data with respective datamember, checked exported and serachable checkboxes for each.

6 Also add this profile RetailerInfo in the PresentationFile

7 for athurization run azman and add New Scope for RetailerInfo in profilesystem under the ProfileAthurizationStore.xml

6 Also define Roles (under Role Definition) ProfileWriter_CSR,ProfileWriter_Adapter,ProfileWriter_BussinessManager and define the definition for each role as Profile_Authoring(for ProfileWriter_CSR),ProfileAdvanced authoring(ProfileWriter_Adapter) and Profile authoring (for ProfileWriter_BussinessManager)

7 close the azman.
8 reset the IIs
9 On open the customer and Order manager under profiles it show RetailerInfo and when I try to create the New profile for RetailerInfo it shows window for add the data.
10 when I cicking on Save Button , It show an error message

"An error occured on the server during your operation. Trythe operation again or contact your administrator if the error persists. The details of the error are captured in the event log on the server.

11 when i look into event viewer the following is the description about error.

Description:
Microsoft.CommerceServer.ServerFaultException: Permission denied.
---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Permission denied.
---> Microsoft.CommerceServer.ServerFaultException: Permission denied.

   --- End of inner exception stack trace ---
   at Microsoft.CommerceServer.Profiles.WebService.ProfilesWebService.PropagateOrLogExceptionInternal(Exception ex)
   at Microsoft.CommerceServer.Profiles.WebService.ProfilesWebService.PropagateOrLogException(Exception ex)
   at Microsoft.CommerceServer.Profiles.WebService.ProfilesWebService.CreateProfile(XmlElement& profileXml, Boolean inAdapterContext)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.CommerceServer.Internal.Profiles.ProfilesServiceProxy.AuthorizedInvoke(String methodName, Object[] parameters)
   --- End of inner exception stack trace ---
   at Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception ex, SoapHttpClientProtocol serviceProxy)
   at Microsoft.CommerceServer.Internal.Profiles.ProfilesServiceProxy.AuthorizedInvoke(String methodName, Object[] parameters)
   at Microsoft.CommerceServer.Internal.Profiles.ProfilesServiceProxy.CreateProfile(XmlElement& profileXml, Boolean inAdapterContext)
   at Microsoft.CommerceServer.Profiles.ProfileManagementContext.CreateProfile(XmlElement profileXml, Boolean inAdapterContext)
   at Microsoft.CommerceServer.Profiles.ProfileManagementContext.CreateProfile(XmlElement profileXml)
   at Microsoft.CommerceServer.UI.CustomerAndOrdersManager.ProfilesManagementProxy.TryCreateProfile(XmlElement profileXml)

Vijay Sagar

commerce server defautt site

Wed, 18 Nov 2009 14:16:59 Z

hi,
can anybody please tell me the approach..how i 'll start..starting from the default site..i have followed this link

ms-help://MS.CS07/cs07default/html/7ce6e9e8-507a-4637-9d72-aacd49137d43.htm

but not able to see the default site. please suggest..

thanks
sonu

how to create a commerce web application in visual studio

Wed, 18 Nov 2009 13:00:16 Z

hi,
can any body please tell me..how i'll approach..to create a default website in visual studio. for that what i need to do or is there any other way to do that?

Get The Sale Price of a Product after Marketing manager catalog discount to feed shopping channel?

Tue, 17 Nov 2009 02:40:59 Z

DISCOUNT QUESTION:

I have the following setup:

1. Commerce Server 2009 Enterprise Install

2. Single base catalog

3. Single Virtual Catalog

a. Price rule that adds 2.5%

4. Single Virtual Catalog

a. Various Price rules that add dollar amounts based on a specific category

5. Various Marketing Discounts (Catalog Discounts NOT Cart Discounts) Created in Marketing Manager

a. Example: 10% off SKU A

b. Example: $5 off food products

I have the following CHALLENGE:

I need to create a product/pricing feed for one of my shopping channels that sends the correct price (AFTER Catalog Discounts are applied). What is the SIMPLE way to do this Any thoughts, suggestions would be great.

Commerce server 2009 ebook

Tue, 17 Nov 2009 08:38:24 Z

I am very new to commerce server , could any one tell me a good ebook of Commerce server 2009? , please do not suggest msdn , as i am currently going through ,

Automate DW Import

Fri, 13 Nov 2009 23:19:26 Z

Hi All,

I was having CS 2009 and Analysis Services on SQL Server 2008.

what the current scenaio is every time we need to run DataWarehouse Import Wizard to update data in DataWarehouse according to log files of a web application.

so is there any way to automate this updation of data in DataWarehouse? (so that analysis on this data can be automated)

like data in DW should get updated after certain intervals of time and analysis can be done

Warm Regards, Bhushan Gawale

Trouble Modifying Commerce Server 09 Web Parts

Tue, 17 Nov 2009 04:58:18 Z

Hi All,
    I'm trying to modify the RegisterWizard CS 09 webpart, which I got from the extensibility kit. I'm having trouble deploying it and wonder if I'm missing a step.

I see that the original is in the GAC, so I figured I could just deploy my new DLL into the bin and that version would get used before the GAC version. First problem was that there is no AssemblyInfo file, so the version is 0.0.0.0, which won't jive with the Safe Controls list in the web.config. In most OSS projects, there is a build file that handles copying a shared AssemblyInfo file.

Here's the error I get (I added an assemblyinfo file to get a version). What is the process to make changes to one of these web parts, deploy, and see them in the Contemporary Site?

Thanks,
Corey

PolicyException: Required permissions cannot be acquired.]
   System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission) +7606579
   System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission) +57

[FileLoadException: Could not load file or assembly 'Microsoft.Commerce.Portal.UI.Profiles, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
   System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +43
   System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +127
   System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +142
   System.Reflection.Assembly.Load(String assemblyString) +28
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +46

[ConfigurationErrorsException: Could not load file or assembly 'Microsoft.Commerce.Portal.UI.Profiles, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +613
   System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +203
   System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +105
   System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +178
   System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +54
   System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed) +600
   System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +128
   System.Web.Compilation.BuildManager.CompileResourcesDirectory() +31
   System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +304

[HttpException (0x80004005): Could not load file or assembly 'Microsoft.Commerce.Portal.UI.Profiles, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +58
   System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +512
   System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +729

[HttpException (0x80004005): Could not load file or assembly 'Microsoft.Commerce.Portal.UI.Profiles, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8894031
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +85
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +259

Virtual Catalog, Pricing Rules and Product Feeds (Marketing Sales and product Feeds also)

Tue, 17 Nov 2009 02:34:13 Z

I have the following setup:

1. Commerce Server 2009 Enterprise Install

2. Single base catalog

3. Single Virtual Catalog

a. Price rule that adds 2.5%

4. Single Virtual Catalog

a. Various Price rules that add dollar amounts based on a specific category

I have the following CHALLENGE:

I need to create a product/pricing feed for one of my shopping channels that sends the correct price (AFTER Catalog Pricing rule is applied). What is the SIMPLE way to do this. I already found a complex method, but feel that this should be EASY and just part of the platform.

Any thoughts, suggestions would be great.

Feedback Requested: Commerce Server Best Practices Analyzer (BPA)

Thu, 12 Nov 2009 21:14:01 Z

Greetings all. I'm hoping to solicit some feedback/responses around the Commerce Server Best Practices Analyzer.

1) Have you used it?
2) If you've used it, did you find any value in it?
3) Is there a best practice that you think should be included in the rule set that's currently missing?
4) Any comments or suggestions on what would make the BPA better?

Thanks for any and all feedback!

-jb

How to select the SharePoint group for a user during Registration

Sun, 15 Nov 2009 01:20:42 Z

I asked this question in another post, but I fear that it got lost in my lack of understanding of what I truly needed.

I'm going to be using Commerce services for SharePoint and want to be able to store the user in one of several sharepoint groups based on some chosen criteria during registration. How can I make that happen dynamically? Where is the registration web part? I've combed the SDK but can't seem to find it.

Thanks,
Corey

Using Sharepoint groups to manage users

Fri, 13 Nov 2009 02:39:25 Z

I'm pretty new to Commerce Server 09 and its integration into SharePoint. I have a requirement to use SharePoint groups to manage the CS users. I've got the VPC demo loaded and read about the pipelines, etc., but I'm not quite sure where to start.

Has anybody done this or have any ideas? Anything that help get me going in the right direction would be appreciated.

Thanks,
Corey

How to Sell Access License to Content Site

Fri, 13 Nov 2009 20:48:59 Z

Here's the scenario I need help with. I want to build a site with a lot of content specific to a certain type of industry. I want to sell access to this content in bundles of "access licenses". So someone in charge of company X should be able to buy a subscription that comes with 10 logins. They should be able to reassign those logins whenever they want.

Is something like this possible in CS 09/Sharepoint CommerceServices? Any ideas where to start?

how to browse and return catalog set using commerce entity

Wed, 11 Nov 2009 03:43:19 Z

Hi,

I just want to browse the catalog and wants to return the products in catalog using commerce server entity.

Can anyone help me what has to be done? or any useful links for this?

how to list sub categories / sub to sub categories in CS 2009

Wed, 11 Nov 2009 09:10:34 Z

Hi,

I listed the category list in my catalog using code, and I want to list the sub categories and sub to sub categories if any using code.

Can any one help me or any link to refer for my requirement.

Thanks
Regards,
Sakthivel.S

Email confirmation template in Commerce webshop

Tue, 10 Nov 2009 10:13:24 Z

Hello,

I've got a queston about the email confirmation in Commerce Server 2009? And about the 'Request Approval' option for new customers

First Question;
1. Where can I find the order confirmation email when a customers has placed an order. I want to edit this template. The shop and customer must both get an order confirmation email. And what tools must I use?

Second Question;
If a customer has created an account then I want the account not been active. I want to use the option Approval Request? Can somebody tell me how I do this? Because I want to send an email to the customers when he is allowed to enter the shop... (or something like that)
And where can I find the email template for this?

Many Thanks!
Stefan

MS Commerce Server 2009 VPC

Tue, 10 Nov 2009 16:14:36 Z

Does anybody know if the VPC for MS Commerce Server 2009 is still available for download so I can use it for demonstration purposes.

Thanks in advance

Gijs

Commerce Server 2009 Virtual PC

Wed, 11 Nov 2009 09:48:29 Z

please could someone tell me where i can get a Commerce Server 2009 Virtual PC? i've serached all the microsoft sites and forums i can find and none of the links work.

catherine

Regarding Multi channel commerce foundation

Mon, 08 Jun 2009 09:27:37 Z

Hi all i tried to work on commerce query. i have few query related to my code , code and query are below.

i created one database named MyOnlineShopping site i created catalog entity and when i try to query its shows me error.

this is the code i write for query is

TextBox1.Text =

"clothes";

var query = new CommerceQuery<CatalogEntity, CommerceCatalogFullTextSearchBuilder>();

query.SearchCriteria.Catalogs.Add(

CommerceFoundationServiceAgent.Catalog);

query.SearchCriteria.FirstItemIndex = 1;

query.SearchCriteria.FullTextSearchType =

CommerceFullTextSearchType.FreeText;

query.SearchCriteria.NumberOfItemsToReturn = 100;

query.SearchCriteria.Phrase =

this.TextBox1.Text;

query.SearchCriteria.ReturnTotalItemCount =

true;

query.SearchCriteria.WhereClause =

null;

query.SearchCriteria.SortProperties =

new List<CommerceSortProperty>() { new CommerceSortProperty(Product.ModelNameDefinition, Product.PropertyName.Id, Microsoft.Commerce.Contracts.Messages.SortDirection.Descending) };

query.SearchCriteria.TypesToSearch =

CommerceCatalogEntityTypes.Product;

CommerceResponse response = CommerceFoundationServiceAgent.Execute(query);

CommerceQueryOperationResponse queryResponse = response.OperationResponses[0] as CommerceQueryOperationResponse;

and i create catalog entity class which is used in query builder
i created a class CommerceFoundationServiceAgent whose code is

public

static class CommerceFoundationServiceAgent

{

/// <summary>

/// Sample user Id.

/// </summary>

public const string UserId = "7139F631-D037-493f-A658-0CC75377FB08";

/// <summary>

/// Sample channel name.

/// </summary>

public const string Channel = "SampleChannel";

/// <summary>

/// Catalog name

/// </summary>

public const string Catalog = "MyOnlineShoppingSite";

/// <summary>

/// Service agent instance.

/// </summary>

private static OperationServiceAgent operationServiveAgent = new OperationServiceAgent();

/// <summary>

/// Executes the specified operation.

/// </summary>

/// <param name="operation">The operation.</param>

/// <returns>The response instance.</returns>

public static CommerceResponse Execute(CommerceBaseBuilder operation)

{

ParameterChecker.CheckForNull(operation, "operation");

return CommerceFoundationServiceAgent.operationServiveAgent.ProcessRequest(

GetCurrentRequestContext(), operation.ToRequest());

}

/// <summary>

/// Gets the current request context.

/// </summary>

/// <returns>A request context instance.</returns>

private static CommerceRequestContext GetCurrentRequestContext()

{

CommerceRequestContext requestContext = new CommerceRequestContext()

{

Channel = Channel,

UserId = UserId,

UserLocale =

"en-US",

UserUILocale =

"en-US",

RequestId =

Guid.NewGuid().ToString()

};

return requestContext;

}

which is used in execute query....
my catalogentity class isjust an normal entity class which is similar to catalog entity class provide in multi channel commerce foundation sample code.
now my issue is whenever i run program it shows execption in line

return

CommerceFoundationServiceAgent.operationServiveAgent.ProcessRequest(

GetCurrentRequestContext(), operation.ToRequest());

stataing null reference.

and i more question is tht what is User Id or channel in te commerce entiies i mean i juss copy these values from the multi channel samples.
i want to knew is that from where i cant get the values of user id aur channel name or if have to give any unique random value ....

We Need Your Feedback!

Mon, 06 Apr 2009 16:22:36 Z

Like all product units at Microsoft, we are very interested in your feedback as we plan our next release of Commerce Server.
One of the key themes for our next release is to provide a single, unified setup experience. In order to best do that, we need to optimize which platforms are supported.

Our current proposal for the next release is to support and optimize for the following:

1) Operating system:
The next version of Commerce Server will support Windows Server 2008 and Server 2008 R2, and only the 64-bit version. By doing this, Commerce Server gains the benefits of 64-bit performance, and keeps up to date with Windows Server releases: Windows Server 2008 R2 and all future versions of server software will be 64-bit only. One change we’re proposing will be to drop support for Windows Server 2003, which is moving out of primary support and into extended support in July 2010. By choosing Windows Server 2008, we can also choose to support IIS 7 exclusively, and get the benefits of IIS 7 integrated mode.

2) SQL Server:
The next version of Commerce Server will support SQL Server 2008 only, plus pre-release testing for the next version of SQL. As with the proposed OS support, we’d like to focus on the most current and next releases of SQL Server. This does mean dropping SQL Server 2005 as a supported database platform.

3) SharePoint:
SharePoint 2007 (both MOSS 2007 and WSS 3) will be supported and we also plan to support the next version of SharePoint.

4) BizTalk:
The BizTalk adapters are not changing, and they will be tested for compatibility with the upcoming BizTalk 2009 release.

5) Dev tools and platforms:
Visual Studio 2008 SP1 will continue to be supported (as it was with CS2009) and we’ll add support for the next version of Visual Studio as well. We are also looking at supporting Windows 7 and/or Vista x64 as a development platform.

We value your feedback - please let us know what you think of our platform proposal for the next release of Commerce Server.

Thank you,
The Commerce Server Product Team