MSDN Forums

Hi!I am creating a sample Online shopping cart application with Commerce server 2009. I am getting the below error in the eventviewer asPipeline Error: Unable to initialize logging to file : c:\windows\system32\inetsrv\pipelines\log\basket.pipelog I get this error when I do a Checkout flow with "add items to shopping cart, Register a new user and then Checkout". This error comes when I do getBasket() after successful registration. I had tried out the three solutions below such as1)web.config logging entries all set to true and added full Control to "everyone" User for the /Log folder.2)set LoggingEnabled=false in web.config, build the services, did IISRESET. Still the same error is occuring. 3)Deleted "basket.pipelog" file under "C:\WINDOWS\system32\inetsrv\pipelines\log", thinking if the file had reached the maximum size. The application executed again giving the same error and basket.pipelog file also got created.None of the above 3 solutions worked. I had checked a similar post in this site. Tried it also but did not work. Please suggest me anyother workaround.Thanks in advance,Usha.    

Hi Brad, I have seen lot of posts on your blog and some of these are really helpful. Still I did not get any post to describe the Checkout Behaviour. It will be really helpful to me if you please let me know the way to change the behavior of checkout web part using Extensibility kit. I have gone thru the link on msdn "Extend webpart"  but it is not useful to me. Could you please advice me certain steps to change the checkout webpart behaviour. Thanks Avdhesh  

What I am trying to do is to have a Build dump the copy of the published website in a fixed directory each time (after deleting all the files in the directory).. for example, I would like the Build Agent, "publish" the website build to c:\inetpub\wwwroot each time the build runs. Can anyone point me in the right direction... thanksBrad Foley | www.blfoley.com | blog.blfoley.com

We have setup a VMWare using Win2008 Std 64bit and SQL 2008 Dev (will later move databases to separate server) During the first installation step selecting CS and Directmailer the setup fails on Direct mailer task, an DBNETLIB error referencing database. The MSCS_Admin DB is successfully craeted but not the Directmailer DB. When I check the registry entries are missing. If I do the same without Directmailer Success is reported but still missing entries in registry. Starting Commerce Server Manager fails, referencng DSN not set. How/What is my problem with creating registry keys for CS2007 in this VMWare environment? Tip? Regards Johan Sörlin  

How is the actual PurchaseOrder record created in the PurchaseOrder table when a user submits and confirms an order? I have extended the purchase order and need to set a new property that I added when the order gets created. I am looking in the extensibility kit and I'm not clear when this actually happens.

I am looking an option to change the Checkout Flow in Commercer server 2009 site. I have tried to make these changes in Extensibility kit . Could you please specify the steps to do the changes in extensibility kit and then deploy my changes in the Running site. Problems I am facing : 1) I have done the code changes. 2) Compile the project with a new sign key. 3) Now how can i refer my modified assembly in my currently running site??? Thanks in advance. Regds Avdhesh

helloi have a scatterview with scatterviewitems and i want to localize each item in a different language but i don't know how to do this. The problem is that i only know how to localize the full application in one language but i don't know how to localize different items of my application.please help

Dear all, I am looking sample on building a color picker, any thing around for surface ? thnaks for help regards sergeYour experience is build from the one of others

Does anyone have recommendations on a camera for overhead use to capture what is happening on the Surface. This would be used for capturing fairly high quality demos, and also for some live stream events. I see there are some so-called HD webcams but these generally don't have the appropriate features for quality captures. We don't want to put special lighting in as it may impact the Surface performance. Thanks! -Brian

Hi, We're looking for any third party pipeline components that might be out there. If you know of any, please post a link. For eample, paypal has one for payments: https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/library_plugins_ec_microsoft_cserver   -A    

So i figured i would post this as another question since the other one will probably never be answered since i already marked it Answered.  I created a simple Payment processor which doesnt do anything.  When i look at the orderform dictionary, i do not see a complete credit card number.  I see a maskedcreditcardnumber and a cc_identifier (the last 4 for the cc).  Also i see an order_id property, but its 26 characters long and doesnt exactly match the nice nnnnn number customers get when they place an order.  Am i missing something in order to get those values into my pipeline?Thank youJason

Hello All,             I am implementing MVVM framework in my sample surface App.             Now the problem is, how can i use or make sure of e.contact.IsFingerRecognized value in my viewmodel since i am using commandbindings for my surfacebuttons. Any ideas to implement is really appreciated. :) Thanks, -Khan.

Im currently working on extending the profile system in CS2009 and have created a profile with a list of delivery addresses and a preferred delivery address and that works fine.but now I need to add a relation to a single address for the Invoice Address I tested that my profile schema works in Customers and Order Manager but I just cant get it to work on the site in CS2009are there anything special I need to do in the CustomRelatedProfileProcessor i created to enable retriving a single related item?should i override the ProcessQuery method on the RelatedProfileProcessorBase and create my own implementation for this to work?Right now I have implemented the abstract properties and I have also set the isMultipleItems in the MetaDataDefinitions.xml to false for the InvoiceAddress relationshipbut when I run the code on the site It just gives me the following error 03/18/2009 14:21:50   Type : System.InvalidCastException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089   Message : Unable to cast object of type 'System.String' to type 'System.Object[]'.   Source : Microsoft.Commerce.Providers   Help link :    Data : System.Collections.ListDictionaryInternal   TargetSite : Boolean Initialize(Microsoft.CommerceServer.Runtime.Profiles.Profile)   Stack Trace :    at Microsoft.Commerce.Providers.Components.RelatedProfileOperationSequenceComponent.Initialize(Profile parentCommerceProfile)      at Microsoft.Commerce.Providers.Components.RelatedProfileOperationSequenceComponent.ExecuteQuery(CommerceQueryOperation queryOperation, OperationCacheDictionary operationCache, CommerceQueryOperationResponse response)      at Microsoft.Commerce.Providers.Components.OperationSequenceComponent.Execute(CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)      at Microsoft.Commerce.Providers.Components.ProfileOperationSequenceComponent.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) 

From what I understand from several blogpostings it's virtually impossible to deploy multiple sites each based on the extensibilitykit to a single server. Anyone who has experienced this? What would be the best way to go?Duin

Hi All, I have just started working on Commerce Server 09.  I need to add new discount type (say, buy product of $350.00 or above and get an item for free).  Is there a way to do this? Thank you all in advance.    

Hi everyone, I am new to Commerce Server and I was wondering if anyone out there has implemented Commerce Server 2009 for a munufacturing company? You see we don't really have any products, everthing is custom made. I would need to implement some kind of wizard to gather the specs from a customer and then add the result to a cart. Any ideas?

Hi, Using MCF, can I include a condition based on category property to search for a product? Basically I need for find all products which are part of any category with category.SamplePropertyName=3 Thank you, Allan

I have a property on a product definition which i would like to access from the pipeline component (for those following along, I have a property on my product definition called IsFood to help determine tax cost).

I am trying to find the best situation for recycling the Commerce Server APP pools. Mostly looking at the sites app pool but wouldn't mind the web service app pool settings as well?mikedopp

I need access to the Profile service from a pipeline.  Is that located hanging off any of the IDictionaries?  What type is it?  I need to retrieve a profile (GetProfile)

HI Team, I am able to create product relations using object model, Can any one tell me how to create category associations for a product using object model. Thanks in advance.

I want to upgarde our Surface to SP1, how to get/remove the hard disk in the Surface, I want to do full hard disk backup. Thanks a lot.2aoixrxi

We’ve got a Surface with serial number: 107685028 that I’m having some trouble with today.   We had the same device running all last week at an exhibition with no problems. Since getting it back, I’ve had a run of Blue Screen of Deaths.   To try to resolve this, I ran Windows Update and installed anything that was Vista related. But to no avail, in fact it seems to be getting worse.   I can’t quite pin down what causes the issue, however in the logs is an error from “atikmdag”, the task category is CPLIB. This occurs over 30 times, and coincides approximately with the time just before the blue screen occurred.   The BSOD error was Kernel Stack Inpage Error – or at least those words, not necessarily in that order! I'm also getting out of sytem memory errors in an app that again, was running fine last week.   Defrag runs every night, and I ran a scheduled disk check, which didn’t find any errors.   When the errors/blue screens occurred, the Surface was running in admin mode with Surface Input running.   Any thoughts??

Dear all, When showing demos to potential customers on Surface, all of them was requesting if it is possible to browse the web from a Surface app. I told them that nothing is imposiible but I understood that this is not the goal of surface apps. IN case I really need to implement such thing how this can be handle ? For example is tehre a possibility to place a kind of browser control in a Scatterview ? Does the WPF browseer control could do that ? Thnaks for samples regards sergeYour knowledge is enhanced by that of others.

I originally posed a question about the Profile Cache which I marked as resolved before I finished testing. The original post is at   http://social.msdn.microsoft.com/Forums/en-US/commserver2009/thread/89a73a33-7f32-4a81-b7c5-97195b61f2b8   To summarize I am having caching issues. Basically I want changes in the managers or web service updates to refresh the cache of the profile if they have a cached UserProfile record on the shopping site. It was proposed to use an update trigger that calls a CLR database object which in turn would pass the user id to a web method to refresh the cache. So I got the CLR database object all set up and a tirgger on the UserObject table. In my CLR database method I simply send a post to an HTTP handler in the shopping site. However I never seem to find the UserProfile cache item. I look for the cache key as defined in the ProfileController class of the extensibility kit but never find it in the HttpContext. Any thoughts on what I might be doing wrong?

Hi! While trying to install Commerce Server 2009, I am getting the error as mentioned in the section below "Error from Log File". The firewall is disabled and I am able to connect SQL Server using the SQL Server Administrator. The user is a domain administrator having system administrator rights on SQL Server. Please help with any pointers.Error from Log File[7:03:41 PM Info Configuration Framework]Entering function IsAdminRequiredForConfig.[7:03:41 PM Info Configuration Framework]Leaving function IsAdminRequiredForConfig.[7:03:41 PM Info Configuration Framework]Entering function UseSplashScreen.[7:03:41 PM Info Configuration Framework]Leaving function UseSplashScreen.[7:03:41 PM Info Configuration Framework]Entering function LoadXmlFromModules()[7:03:41 PM Info Configuration Framework]Leaving function LoadXmlFromModules()[7:03:41 PM Info Configuration Framework]Entering function IsDefaultConfigRequired.[7:03:41 PM Info Configuration Framework]Leaving function IsDefaultConfigRequired.[7:03:41 PM Info Configuration Framework]Entering function StartConfigDlg_Load.[7:03:41 PM Info Configuration Framework]Entering function GetLocalRunningSQLServerName.[7:03:41 PM Info Configuration Framework]Entering function IsServiceRunning.[7:03:41 PM Info Configuration Framework]Leaving function IsServiceRunning.[7:03:41 PM Info Configuration Framework]Leaving function GetLocalRunningSQLServerName.[7:03:41 PM Info Configuration Framework]Leaving function StartConfigDlg_Load.[7:04:02 PM Info Configuration Framework]Entering function ValidateSqlCredentials.[7:04:17 PM Warning Configuration Framework]Sql Exception occurred in ValidateSqlCredentials(). Detail Error: Index #0, Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server), LineNumber: 0, Source: .Net SqlClient Data Provider, Procedure: .[7:06:45 PM Info Configuration Framework]Entering function ValidateSqlCredentials.[7:06:45 PM Info Configuration Framework]Leaving function ValidateSqlCredentials.[7:06:45 PM Info Configuration Framework]Entering function ServiceLogOnHelper.[7:06:45 PM Info Configuration Framework]Leaving function ServiceLogOnHelper.[7:06:45 PM Info Configuration Framework]Entering function IsAdmin.[7:06:45 PM Info Configuration Framework]Leaving function IsAdmin.[7:06:46 PM Info Configuration Framework]Entering function LoadXmlFromModules()[7:06:46 PM Info Configuration Framework]Leaving function LoadXmlFromModules()[7:06:46 PM Info Configuration Framework]Entering function ValidateOlapServer.[7:06:46 PM Info Configuration Framework]Leaving function ValidateOlapServer.[7:06:46 PM Info Configuration Framework]Entering function ValidateFeatures().[7:06:46 PM Info Configuration Framework]*** Starting final validation pass ***[7:06:46 PM Info Configuration Framework]*** Ending Final validation pass. ***[7:06:46 PM Info Configuration Framework]Leaving function ValidateFeatures().[7:06:46 PM Info Configuration Framework][StartDiaglog_Configuration] thread started.[7:06:46 PM Info Configuration Framework]Entering function ConfigWizardFrame_Load.[7:06:46 PM Info Configuration Framework]Configuration Wizard Mode: 0.[7:06:46 PM Info Configuration Framework]Entering function ConfigWizardSummary_Load.[7:06:47 PM Info Configuration Framework]Leaving function ConfigWizardSummary_Load.[7:06:47 PM Info Configuration Framework]Leaving function ConfigWizardFrame_Load.[7:06:48 PM Info Configuration Framework]Entering function WizardStep_NextStepChanged.[7:06:48 PM Info Configuration Framework]Entering function IsServiceRunning.[7:06:48 PM Info Configuration Framework]Leaving function IsServiceRunning.[7:07:04 PM Info Configuration Framework]Calling CSConfig[7:07:04 PM Info Configuration Framework]TYMED_FILE = C:\Users\ADMINI~1.AVE\AppData\Local\Temp\1\ConfigLog(2010-02-26 19h06m48s).log[7:07:04 PM Info Configuration Framework][19:06:48 INFO] Logging has been initialized.[7:07:04 PM Info Configuration Framework][19:06:48 INFO] GetProductLanguageId returning '1033'.[7:07:04 PM Info Configuration Framework][19:06:48 INFO] Not changing the thread's CurrentUICulture from LCID '1033'.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Loading installed features.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.Core' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.Marketing' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.Admin' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.Catalog' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.PCGN' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.Misc' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.Orders' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.PerfCounters' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.DirectMailer' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature 'Feature.MS.CS.CsStaging' is installed.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Loading features that are installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.Core is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.Marketing is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.Admin is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.Catalog is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.PCGN is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.Misc is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.Orders is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.PerfCounters is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.DirectMailer is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Feature: Feature.MS.CS.CsStaging is installed but not configured.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Completed validation of command line options. Operation Mode: 'Configure'[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Loading XML file: C:\Program Files (x86)\Microsoft Commerce Server 9.0\ConfigLaunch.xml.[7:07:04 PM Info Configuration Framework][19:06:49 INFO] Beginning validation of feature Administration Database (Feature.MS.CS.Admin).[7:07:04 PM Info Configuration Framework][19:07:04 ERROR] Error occured during validation of feature Administration Database (Feature.MS.CS.Admin).[7:07:04 PM Info Configuration Framework][19:07:04 ERROR] Exception occured during feature validation: Microsoft.CommerceServer.Internal.Config.ValidationException: Unable to connect to the specified database. Please make sure of the following settings:[7:07:04 PM Info Configuration Framework]    The server name is a computer running Microsoft SQL Server.[7:07:04 PM Info Configuration Framework]    The server is accessible from this computer.[7:07:04 PM Info Configuration Framework]    You have permissions to connect to the server and the database.[7:07:04 PM Info Configuration Framework]    If the database does not exist and you want to create it, you need 'System Administrator' privileges on the server.[7:07:04 PM Info Configuration Framework][7:07:04 PM Info Configuration Framework]Error Summary:[7:07:04 PM Info Configuration Framework]A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)[7:07:04 PM Info Configuration Framework] ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)[7:07:04 PM Info Configuration Framework]   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)[7:07:04 PM Info Configuration Framework]   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)[7:07:04 PM Info Configuration Framework]   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)[7:07:04 PM Info Configuration Framework]   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)[7:07:04 PM Info Configuration Framework]   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)[7:07:04 PM Info Configuration Framework]   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)[7:07:04 PM Info Configuration Framework]   at System.Data.SqlClient.SqlConnection.Open()[7:07:04 PM Info Configuration Framework]   at Microsoft.CommerceServer.Internal.Config.DBConfig.DatabaseExists(String connectionStringToMaster, String dbName)[7:07:04 PM Info Configuration Framework]   --- End of inner exception stack trace ---[7:07:04 PM Info Configuration Framework]   at Microsoft.CommerceServer.Internal.Config.DBConfig.DatabaseExists(String connectionStringToMaster, String dbName)[7:07:04 PM Info Configuration Framework]   at Microsoft.CommerceServer.Internal.Config.AdminConfig.Validate(Boolean interactive)[7:07:04 PM Info Configuration Framework]   at Microsoft.CommerceServer.Internal.Config.ConfigurationDriver.Validate(FeatureConfig feature).[7:07:04 PM Info Configuration Framework][19:07:04 INFO] CSConfig Application exit - Exit Code 1.[7:07:04 PM Info Configuration Framework]CSConfig complete[7:07:04 PM Info Configuration Framework]Leaving function WizardStep_NextStepChanged.[7:07:04 PM Info Configuration Framework]Entering function ConfigureFeatures().[7:07:04 PM Info Configuration Framework]Leaving function ConfigureFeatures().[7:07:04 PM Info Configuration Framework]Entering function WizardStep_NextStepChanged.[7:07:04 PM Info Configuration Framework]Entering function ConfigWizardResult_Load.[7:07:04 PM Info Configuration Framework]Leaving function ConfigWizardResult_Load.[7:07:04 PM Info Configuration Framework]Leaving function WizardStep_NextStepChanged.

Has anyone implemented a different version of the ProfileController cahce structure. Currently the ProfileController creates a cache entry using the user_id or live_id of the profile. This however is not the desired affect I was looking for. If a business user updates a profile in either a manager app or the webservice the profile site cache has to be refreshed in order for the change to be visible in the shopping site. I was thinking I need to query to see if the profile has changed since the cache copy was created, but this would mean a database query each time I need to access the UserProfile to ensure I am dealing with the most recent copy. Does anyone else have any suggestion?  

Hi   I want to retrieve Image File Name .How to do that ..following is my code .. Microsoft.CommerceServer.Catalog.CatalogContext catalogContext = CommerceContext.Current.CatalogSystem; Microsoft.CommerceServer.Catalog.CatalogSearch catalogSearch = catalogContext.GetCatalogSearch(); catalogSearch.SearchOptions = new CatalogSearchOptions(); catalogSearch.Language = ddlLanguage.SelectedValue.Trim(); catalogSearch.SearchOptions.ClassTypes = CatalogClassTypes.ProductClass | CatalogClassTypes.ProductFamilyClass; catalogSearch.SearchOptions.PropertiesToReturn = "ProductId,DisplayName,Description,DefinitionName"; catalogSearch.SearchOptions.SetPaging(1, 25); catalogSearch.SearchOptions.SortDescending = false; catalogSearch.SearchOptions.SortProperty = "ProductId,DisplayName"; //catalogSearch.SqlWhereClause = "Description like %" + KeyWord.Text +"%"; string searchPhrase = @"N'*" + KeyWord.Text + "*'"; catalogSearch.FreeTextSearchPhrase = searchPhrase; //catalogSearch.Cate int totalRecords; CatalogItemsDataSet searchResults = catalogSearch.Search(out totalRecords); this.Products.DataSource = searchResults; this.Products.DataBind();  Pritesh Gandhi http://www.google.com/profiles/pritesh.b.gandhi http://www.gandhipritesh.com/ P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

I need to change the name of the column on the BasketDetail of the starterSite to spanish. ¿How can I do that?. It's possible to using on a .resx? In the Component I can see a collections of string called ColumnNames with something like this: ComponentResources.BasketDetail_QuantityColumnName But. Where is the ComponentResources? Thanks

We have extended the microsoft line item(MSlLineItem), Basket(MSBasket)  and Order template(MSOrderTemplate). In our commerce application all are working fine. We have requirment for converting the basket from LOB to Commerce server DB. Previously the basket data are in different db(oracle table). we migrating to commerce db. Here we are using consle application, using Microsoft.CommerceServer.Runtime.Orders; using MS.Commerce.Portal.CommerceExtensions;             static void Main(string[] args)         {                        Guid UserID = new Guid("{094D3F64-C3F8-4751-A0BD-315B725R69C1}");                         OrderContext orderContext = OrderContext.Create(transaction Connection String, transaction Config String);             OrderTemplate orderTemplate = orderContext.CreateOrderTemplate(UserID);                         //MSLineItem             MSLineItem msLineItem = new MSLineItem();                         msLineItem.Description = "ABCD Description";             msLineItem.DisplayName = "ABCD Description";             msLineItem.ExtendedPrice = 12M;             msLineItem.MSSubTotal = 0M;             msLineItem.MSTotal = 12M;             msLineItem.InStockQuantity = 22;             msLineItem.ListPrice = 78.89M;             msLineItem.PlacedPrice = 76.89M;             msLineItem.PreorderQuantity = 1;             msLineItem.ProductCatalog = "Adventure Works Catalog";             msLineItem.ProductId = "1245";             msLineItem.Quantity = 1;             msLineItem.TaxTotal = 12;                         //OrderForm             OrderForm orderform = new OrderForm();             orderform.HandlingTotal = 0M;             orderform.ShippingTotal = 0M;             orderform.SubTotal = 0M;             orderform.TaxTotal = 12M;             orderform.Total = 32M;                       orderform.LineItems.Add(msLineItem);             //MSOrderTemplate             MSOrderTemplate msOrderTemplate = new MSOrderTemplate();                                    msOrderTemplate.Status = "InProcess";             msOrderTemplate.OrderForms.Add(orderform);                        orderTemplate = (OrderTemplate)msOrderTemplate;             orderTemplate.Save();  } OrderTemplate.Save() method is throwing error "Failed to convert parameter value from a string to Int32" But PurchaseOrder po = msOrderTemplate.ConvertToBasket().SaveAsOrder(); is executed correctly. Please give me a solution       -------------------------------------------------------------------------------- Prabu.T

Is there a CS09 way of doing this: http://msdn.microsoft.com/en-us/library/aa545704(CS.70).aspx or http://msdn.microsoft.com/en-us/library/aa545295(CS.70).aspx?  I would like to get an exact copy of a basket (with shipping and payment information)

I using commerce server 2009 I wrote pipeline for credit card payment when I debug in it credit number and validation code was empty other properties of payment has correct values in  dictionay same satuation is for Saved credit card and for credit card that user give in checkout process. what is the problem please help.  

Hi, The following article suggests installing CS2009 on each developer box: http://msdn.microsoft.com/en-us/library/dd451889(CS.90).aspx Based on my understanding the core of Commerce server services are a series of .asmx web services. Can I leave commerce server on a separated machine and have my development workstations just point to the .asmx web services? Thank you, Allan  

Hi all. I have a problem with the StarterSite when I going to confirm the order. the application is stoped and the show me an error; initialy was this:   Message="Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool." And then I went to the component services and selected "Network DTC Access", "Allow Remote Clients", "Allow Remote Administratation", "Allow inbound", "Allow outbound", "No Authentication required" and "Enable XA Transactions". And then the problem showed was: "The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)" And I did the same on the database server. But now the problem is: "Communication with the underlying transaction manager has failed." And, I have disabled the windows Firewall, and I have a physical firewall but it have the port 135 enabled. And I can see the request and response passing OK. So, ¿what more can I do?

Hi Is it possible to extend the discount framework ? We need to add more properties to a discount (for example add diffrent images associate to a  specific discount) Thanks Arikarik

I am trying to manage already placed orders.  Each time I query a group of orders in Commerce Foundation (ie "CF") it wants me to specify a specific UserId.  However, I am trying to query over many different users in order to manager a group of (say unfilled) orders.  How do I do this efficiently in CF?  Pls.advise.  And if not available efficiently using CF (my first choice), how do I do this using the Core Systems?  I would like to return a group of orders (with all the order info included namely order form, line item, payment info, etc.) for many different users using different search criteria (like date range only, or an unfilled status only, etc.).  This must be a basic/common thing to do.  Pls.advise.  Thank you.

Hi, Is it safe to use CS2009 with SQL 2008 R2? Thank you, Allan

Hi, When I want to edit a user control file in the _layouts/commerceserver directory on the server, i get an error on the FBA website. WebPart can not be displayed. Error loading the user control file This is only on the FBA site, not on the Windows Authentication site. And the error comes when I just change a letter in the document, for instance i change <div class="Skin_h3_Replacement"> in <div class="Skin_h4_Replacement"> , i'll get this error. This is the error in the Server Manager Application Log An exception of type 'System.Web.HttpCompileException' occurred and was caught. ------------------------------------------------------------------------------- 05/06/2010 11:46:41 Type : System.Web.HttpCompileException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Message : c:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\db102326\1da4fb39\App_Web_orderhistory_cartridge.ascx.9f8b1841.cmihks2j.0.cs(212): error CS0012: The type 'Microsoft.Commerce.Portal.UI.Profiles.UserControls.CommerceTimePicker' is defined in an assembly that is not referenced. You must add a reference to assembly 'Microsoft.Commerce.Portal.UI.Profiles, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Source : System.Web Help link : Results : System.CodeDom.Compiler.CompilerResults SourceCode : ErrorCode : -2147467259 Data : System.Collections.ListDictionaryInternal TargetSite : System.CodeDom.Compiler.CompilerResults Compile() Stack Trace : at System.Web.Compilation.AssemblyBuilder.Compile() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at Microsoft.Commerce.Portal.Common.BaseUserControlWebPart.CreateChildControls() FullName : Microsoft.Commerce.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 AppDomainName : /LM/W3SVC/4/ROOT-2-129176116899552109  

Hi, Is there any easy way to extracts the profile, catalog and order schemas in a reportable - or preferably printable - format? Thank you, Allan  

Hi, I have two web servers ("load balanced" using a CCS (Cisco content switch)). We can call them Srv1 and Srv2. In Srv1 I will install a SQL Server 2008 instance where I will have the CS datbases. When Installing CS2007 Enterprice in Srv1 I run the database wizard that creates all datbases. But in Srv2 I just install CS, i dont run the database wizard (since the databases are alread created from installation in Srv1). Now when I go to CS Manager I just get the error message you can read below. I can't do anything. I get the error all the time. I thought that I could configure the conection to SQL Server on Srv1 from CS Manager without running the db wizard. Isnt that possible? I want to do it like this, since I don't want the installation on Srv2 to recreate the databases. The error message: Could not connect to the Commerce Server Administration database.  Please make sure you have configured Commerce Server by running the Configuration Wizard. If you have already configured your server, verify that the Administration database connection string settings are correct.  To adjust the settings, right click on the Commerce Server Manager root node, then click properties.  To verify the settings, right click on the Commerce Server Manager root node, then click Refresh.