Troubleshoot: Code 3005 in Profiles.ProfileContext

ravikanth | October 21, 2009

Some times, when you try to load the Commerce Site you  may receive an ASP.Net Warning followed by Commerce Server Error 3005. The Commerce Server Error (below) didn’t really gave me much to start with. but ASP.Net Warning shows that the error has happened at commerce server profiles:

 

Here is ASP.NET 2.0 Warning Information

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/19/2009 3:36:38 PM
Event time (UTC): 10/19/2009 10:36:38 PM
Event ID: 6f6751d3aeab44c99df3624cfa784138
Event sequence: 8
Event occurrence: 7
Event detail code: 0
Application information: 
    Application domain: /LM/w3svc/1/root-1-129001196432722277 
    Trust level: Full 
    Application Virtual Path: / 
    Application Path: C:\inetpub\wwwroot\ 
    Machine name: CSTrainingVPC

Process information: 
    Process ID: 5764 
    Process name: w3wp.exe 
    Account name: CSTrainingVPC\trainer

Exception information: 
    Exception type: COMException 
    Exception message: Unspecified error
Request information: 
    Request URL: http://localhost/Error.aspx
    Request path: /Error.aspx 
    User host address: 127.0.0.1 
    User:  
    Is authenticated: False 
    Authentication Type:  
    Thread account name: CSTrainingVPC\trainer

Thread information: 
    Thread ID: 1 
    Thread account name:  CSTrainingVPC\trainer
    Is impersonating: False 
    Stack trace:    at Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.Initialize(String sConfigStore, String sCatalog)
   at Microsoft.CommerceServer.Runtime.Profiles.ProfileContext..ctor(String profileServiceConnectionString, String providerConnectionString, String bdaoConnectionString, DebugContext debugContext)

Here is Commerce Server Error

The description for Event ID ( 16389 ) in Source ( Commerce Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .

Using Commerce Server Manager I double checked and found that the connections to the database are correct, and that the application pool is running under an identity which has access to the database. 

After some investigation what I found is – If you are accessing the “Internal” site using Windows Authentication, then your user account needs access to the CS databases. When I gave SQL permission to the windows account, the error is fixed. The approach you should take is to create an Active directory group for CS users, and grant it the same SQL permissions as the CSRunTime user according to the CS deployment document. The “External” site, with anonymous access, will use the App Pool account (e.g. CSRunTime) for SQL DB access.  If you are attempting to access the external site, be sure to validate CSRunTime has the correct SQL DB access per the CS deployment document.

Categories
commerce server 2007
Comments rss
Comments rss
Trackback
Trackback

« Ecommerce Effort Estimation Catalog Search – Ascending on first property and descending on second property »

One Response to “Troubleshoot: Code 3005 in Profiles.ProfileContext”

  1. Finbar Ryan says:
    November 13, 2009 at 4:17 am

    Hello,

    This sounds very like an issue that we have recently released a fix for.

    Error message when you open a Commerce Server 2009 Web site that is integrated into SharePoint when the SQL Server and the Commerce Server are installed on different computers: “Server Error in ‘/’ Application”
    http://support.microsoft.com/kb/975603

    I think this might also resolve your issue and would mean that you do not need to give users permissions on the database.

    Thanks,

    Finbar

    Reply

Leave a Reply

Powered by WP Hashcash