commerce server 2007
September 29, 2011 | 
Author 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.
Posted in commerce server 2007, Commerce Server 2009, Troubleshoot | 
Tags: 102, Customer & Order Manager, Exception | 
No Comments »
Commerce server 2007 product which was released in the year 2006 grab bigger market with in ecommerce space Three weeks before, Microsoft has stopped mainstream support & provided only extended support till 2016 to this product. So, going forward you can’t
1. request to change the product design & features
2. Complimentary support included with license, licensing program & other no-charge support programs.
3. Other non-security hotfixes (available only with purchase of extended hotfix support agreement.
These are the services provided (as part of extended support) for next five years are
1. Security updates
2. Paid support (including pay-per-incident premier & essential support).
Free access to online content such as knowledge base articles, online product information, & online support webcasts, etc. will continue to have.
| Product Released | General Availability Date | Mainstream Support End date | Extended Support End date | Service Pack Support End Date |
| Commerce Server 2007 Developer Edition | 6/16/2006 | 7/12/2011 | 7/12/2016 | 7/8/2008 |
| Commerce Server 2007 Enterprise Edition | 6/16/2006 | 7/12/2011 | 7/12/2016 | 7/8/2008 |
| Commerce Server 2007 Service Pack 1 | 6/22/2007 | Not Applicable | Not Applicable | 7/14/2009 |
| Commerce Server 2007 Service Pack 2 | 5/29/2008 | |||
| Commerce Server 2007 Standard Edition | 6/16/2006 | 7/12/2011 | 7/12/2016 | 7/8/2008 |
Click here to go to product life cycle page.
Microsoft will continue its mainstream support to Commerce server 2009 till July 2014,
If you like this post, please click on our sponsor advertisement.
Posted in commerce server 2007, Commerce Server 2009, Troubleshoot | Tags: 102, Customer & Order Manager, Exception | No Comments »
A virtual catalog will load price from the base catalog but it allows business users to override it. So, on every rebuild, the updated price will not be overridden. sometimes you want to reset the price to the base catalog price. Reset price can happen on product level or at catalog level.
To reset a product price, you need to right click on the product and select “Reset Price”.
To reset all products prices of a virtual catalog, you need to right click on the virtual catalog and select “Reset product prices” or click on virtual catalog and from the task pane click on “Reset product prices”.
If you like this post, please click on our sponsor advertisement.
Posted in commerce server 2007, Commerce Server 2009, Troubleshoot | Tags: 102, Customer & Order Manager, Exception | No Comments »
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.
Posted in commerce server 2007, Commerce Server 2009, Troubleshoot | Tags: 102, Customer & Order Manager, Exception | No Comments »
Many of us doesn’t know that we can able to access SQL connection strings from commerce context. Commerce server has resources and each resources have connection string property. You can view them using commerce server manager.
Recently, while reviewing an application, I found that they are accessing data from custom tables stored in profile database and the connection string is reading from appsettings in web.config, This is not required. We can get the connection strings easily using runtime API. Thought of sharing the code to the blog users so that they can also implement the same in their application if they are loading connection strings from app settings.
|
private static string ProfileConnectionString
private static string CatalogConnectionString Note: Same thing applies to other resources. |
If you like this post, please click on our sponsor advertisement.
Posted in commerce server 2007, Commerce Server 2009, Troubleshoot | Tags: 102, Customer & Order Manager, Exception | No Comments »
