Troubleshoot
After configuring the default site using SharePoint Commerce Services Configuration Wizard tool & when I try to browse the application, the application throws back a wired exception & it says “The module ‘SharePointCommerceProfileModule’ depends on the site resource ‘Biz Data Service’ which does not exist in the Commerce Server administration database.” (as shown below).
After analyzing, I found that this is due to not proper configuration of profile system. I suspect there might be a problem with the tool while configuring profile resource. When I saw the application in commerce server manager, profile catalog is not seen (as shown below).
RESOLUTION : Add commerce server profile resources manually.
- Open commerce server manager.
- Deleted Profiles and CS Authentication from commerce server site.
- Right click site node and Add Resource.
- Select MicrosoftCommerceDefaultSiteNoData.pup and click ok
- Select CSAuthentication and Profiles, add them.
After creating profile resources, the site started working property.![]()
If you like this post, please click on our sponsor advertisement.
After installing commerce server , sometimes you will notice that your event log is flooded with lot of commerce server performance counter errors. The exception is shown below
|
Event Type: Error Description: |
These are CS2007 Performance Counters. You can either ignore these event messages or attempt to unregister/re-register the CSPerfCounters.dll (found in c:\program files\common files\Microsoft shared\enterprise servers\commerce server folder) which will solve the problem. You should be able to use the regsvr32 /i command to register the DLL.
If you like this post, please click on our sponsor advertisement.
Yesterday, I faced very wired issue. I got crazy & doubt my code why it is not working
. I extended line item as mentioned in my blog – Steps involved in extended commerce server 2009 Systems. When I run the code in Extended line item class, I am getting wired error in GetObject() method. The error is
“Member NewColumn was not found”.
The newColumn in the exception message is the newly added column to the line item table/class. I verified that the column already present in database, OrderObjectMapping.xml, OrderPipeline xml, translator, entity & extended line item but still I am getting the error. I thought this can be an environment issue & I have tested my code on my peer box & found the same issue is repeating. For some time I doubt whether I have done all the code changes properly.
After analyzing for some time, I found the root cause. If you already have LineItem objects in the database (for example baskets), when these objects are deserialized as instances of the Extended LineItem class, they will not have a value for the newly column property. In my system, I have many user baskets & these user baskets doesn’t have newly added columns as the baskets are weakly type & are before extending line item. If any change to the schema, commerce server will not modify it & only option left for me is to delete the baskets from my database.
| USE StarterSite_Transactions GO DELETE OrderTemplatesAndBaskets GI |
Once changes are done, my application is working fine. If you want to overcome this problem & effectively address them in production then better to keep try catch for all variables access in GetObject() method (sample shown below).
| protected ExtendedLineItem (SerializationInfo info, StreamingContext context) : base(info, context) { try { NewColumn = info.GetString("NewColumn"); } catch (SerializationException se) { NewColumn = "No Description"; } } |
If you like this post, please click on our sponsor advertisement.
Suddenly my customer & orders Manager application "crashed" when opened on the client’s workstation(no error displayed) . It way working last night but today when I try to open the customer & order manager, it crashes & it will log 102 error code in the event log. You may not get out of this error if you re-install .NET framework or business tools.
You should remember one thing, that for the first time when the user try to open customer and order manager tool it creates a user config xml file. This user.config file contains all connection strings and parameters necessary for the business app to function. Once you add a connection string to
the appropriate web services, this information is stored in the user.config file. For every user which users customer & order manager tool from that machine, a separate user.config file created on that machine. Every time the user start the business app, it will utilize the information in this file for startup and initialization. If this file gets corrupt, then the app will have problems with the information within. When you un-install .NET framework or business tools this file is not removed/deleted, which could explain why removing and re-installing does not clear the problem.
To fix this issue, the computer needs to have Visual Studio’s command line utility on it. If so, follow below steps
- Open Visual Studio’s Command Prompt
- Change to the \Documents and Settings\<User ID>\Local Settings\Application Data\Microsoft Corporation directory (example: cd c:\documents and setting\ravi\local settings\application data\Microsoft corporation where ravi is my sample user id)
- Change to the directory CustomerAndOrdersManager… (example cd \customerandorders*)
- Change to the directory 6.0.1.0 (example cd \6.0.1.0)
- Either rename (ren user.config temp.config) or delete (del user.config) the user.config file within this directory.
- Startup the Customer and Orders Manager Business Application. It will create a new blank user.config file.
Hope this will resolve your problem.
If you like this post, please click on our sponsor advertisement.
We have couple of servers in the commerce server farm. After installing commerce server, when we try to configure it, we encounter a strange error in configuration process. It says “The DirectMailer Resource is already configured on another computer. Only one Direct Mailer resource is supported per deployment). On OK button click, the configuration process roll backs the configuration process.
Marketing direct mailer can be installed only on one server in the farm. To avoid this error, I figured out couple of options.
Option 1: Open command prompt. Navigate to “c:\Program Files (x86)\Microsoft Commerce Server 2007\” folder and run below command.
Run CSConfig /r Feature.MS.CS.Server
This will reconfigure only the admin database (not the direct mailer nor staging – other available features are Feature.MS.CS.DirectMailer, Feature.MS.CS.PCW, Feature.MS.CS.CsStaging and Feature.MS.CS.HealthMonitoring).
or
Option 2. From the existing commerce server site, delete direct mailer resource (from commerce server manager) and run below command.
Run CSConfig /f
This will reconfigure only the admin database (not the direct mailer nor staging.).
I opted second option and it worked for me.
If you like this post, please click on our sponsor advertisement.
