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 »
Last week, Commerce Server 2009 R2 is included in MSDN subscription downloads, that means soon the product is going to hit RTM. If you have MSDN subscription then you can download the software under servers section (as shown below).
What next (expectation from the community)?
- Commerce server help on MSDN
- Separate forums for R2.
- Commerce server roadmap
- Commerce server videos in channel 9.
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 »
As you might be knowing that all commerce site details are stored in MSCS_Admin databases. At runtime, commerce server loads this information. The connection string to this database is in the registry in encrypted format.
If you want to know what all resources pointed to which database, either you can use commerce server manager to see the connection strings or you can run below query which provides you the connection strings for available commerce server site resources.
use MSCS_admingo DECLARE @siteName NVARCHAR(20)SET @siteName ='StarterSite' where s_Name = @siteName)) AND s_PropertyName IN ('connstr_db_Transactions','connstr_db_TransactionConfig', 'connstr_db_Catalog', 'connstr_db_Marketing', 'connstr_db_Lists') UNION SELECT s_PropertyName,CAST( s_Value as NVARCHAR(200)) FROM ResourceProps where i_ResourceID = (SELECT i_ResourceID from Resources where s_DisplayName IN (siteName)) AND s_PropertyName ='s_RefResource' and s_Value like '%Profile%')) AND s_PropertyName = 's_ProfileServiceConnectionString'
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 »
Almost three years back, I created a post which explains how to delete commerce server site in CS2007. At that time, people are not aware on how to delete a site & they used to do the mistakes.
http://microsoftblog.co.in/commerceserver/how-to-delete-commerce-server-site/
You can also find clear steps mentioned in MSDN now. Microsoft has provided tools to import or export commerce server sites but it doesn’t provide any tool to delete commerce server site. I have attempted to delete commerce server site on single click. I have assumed few things to make this tool work (ideal way is to read MSCS_Admin database to read commerce site configurations & delete them accordingly). Feel free to use the code to customize according to your needs.
Here is the snapshot of how the tool looks like.
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 »
When you create a virtual catalog from one or more base/virtual catalogs, the data from base/virtual catalog is propagated into newly created virtual catalog. In the newly created virtual catalog, you can override few of the properties such as display name, price, description, ranking etc. Whenever there is a change in any one of the property data in base catalog, the virtual catalog needs to get rebuild in order to get those modified data. So, when you click on any virtual catalog in catalog manager, you will see a dialog box asking whether to rebuild the catalog now.
You might be wondering, in some instances even though the data is changed in the base catalog, the virtual catalog will not ask for rebuild. This is because the data rows you have changed in the base catalogs are materialized in virtual catalogs( this virtual catalog data is modified from the catalog manager). In such instances, any data changes in the base catalog will not be propagated to the virtual catalogs. Run below query to check the rows that got materialized in the virtual catalog.
| select * from [ADVC_CatalogProducts] where [#MaterializationNeeded]=1 – Note: ADVC is the virtual catalog name. |
Commerce server runtime has provided few methods by which we can rebuild all virtual catalogs (irrespective of any change / no change in the base catalog data). But these materialized rows will not get disturbed with that rebuild. If you want to get the base catalog data on rebuild, you need to set back the #MaterializationNeeded flag to 0. Note: if you change this bit flag, you may end up loosing materialized row data in the virtual catalog.
|
UPDATE [ADVC_CatalogProducts] SET [#MaterializationNeeded]=0 where [#MaterializationNeeded]=1 AND ProductID=’19393838′ |
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 »
