Troubleshoot: Code 3005 in Profiles.ProfileContext

October 21, 2009 |

Author ravikanth

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.

If you like this post, please click on our sponsor advertisement.

Posted in commerce server 2007

Finbar Ryan:

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

Commerce Server Blog

Troubleshoot: Code 3005 in Profiles.ProfileContext

Related Articles

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

Leave a Reply