Sajid_mansoori

Hi All,

Here is my situation. I installed Starter site for Commerce Server 2007 on windows 2003 machine using the default database name (StarterSite_transaction, etc.). I was able to open the website and select items and add them to orders. I also added our company's catalog and was even able to process complete order. So far so good.... We later decided that we need to change the default databases created by StarterSite wizard. I packaged the site into a pup file, deleted the IIS website and renamed the old folder so that the pup package wizard can write the files in the same location. I unpacked the site giving a new database (eCommerce) name and then finished the wizard without any errors. I setup the permissions on the new database as directed by the startersite documents. Now comes the problem : When i open the website it gives me the following errors:

-------------------------------------------------------------------------

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 5/25/2007
Time: 1:16:17 PM
User: N/A
Computer: COMMERCE
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/25/2007 1:16:17 PM
Event time (UTC): 5/25/2007 5:16:17 PM
Event ID: 5c766f5f5b5847e699f1c9cd795b874f
Event sequence: 2
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/w3svc/873375705/Root/5oClock-1-128245869675095090
Trust level: Full
Application Virtual Path: /5oClock
Application Path: D:\webs\5oclock\5oClock\
Machine name: COMMERCE

Process information:
Process ID: 3880
Process name: w3wp.exe
Account name: LINKNET\RunTimeUser

Exception information:
Exception type: COMException
Exception message: One or more errors occurred during processing of command.


Request information:
Request URL: http://commerce:8080/5oclock/default.aspx
Request path: /5oclock/default.aspx
User host address: 192.168.3.120
User:
Is authenticated: False
Authentication Type:
Thread account name: LINKNET\RunTimeUser

Thread information:
Thread ID: 1
Thread account name: LINKNET\RunTimeUser
Is impersonating: False
Stack trace: at Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.GetProfileByKey(String bstrKeyMemberName, Object sValue, String bstrType, Boolean bReturnError)
at Microsoft.CommerceServer.Runtime.Profiles.Profile..ctor(ProfileContext profileService, String keyName, String keyValue, String profileType)


Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-------------------------------------------------------------------------

The error occurs on line 44 of \5oClock\App_Code\BusinessObjects\CurrentUser.cs

Profile profile = CommerceContext.Current.UserProfile;

I've looked at the permissions and they look fine to me as it was working pervioulsy. All i changed was the database (which was assigned the required permission) and the directory. Can anyone please help me here

Regards

Sajid

FYI : Database is SQL Server 2005



Re: Commerce Server 2007 Failed to retrieve profile

Max Akbar

There are two files you need to run from the Starter Site directory profileSQL_Starter.xml and profileSQL_Starter.sql. The sql file will create the database structure and the xml file will create the schema.

Good luck,

-Max






Re: Commerce Server 2007 Failed to retrieve profile

Sajid_mansoori

Hi,

How do I run the profileSQL_Starter.xml file on the database I've executed the .sql using the management studio. Sorry for my ignorance.

Sajid





Re: Commerce Server 2007 Failed to retrieve profile

Sajid_mansoori

Never mind. I was able to import the schema into the database and it WORKED!!!!

Thanks a lot

Sajid

PS:For newbies here is the URL ms-help://MS.CS07/cs07default/html/19ce6b88-737a-4fa1-ab48-b4418656b049.htm





Re: Commerce Server 2007 Failed to retrieve profile

Max Akbar

You are welcome and thanks for the link .

-Max






Re: Commerce Server 2007 Failed to retrieve profile

Baloo

Hi

sorry if I try to ask you some help.

I have (I believe) the same kind of problem.

Moved a site, running on a machine, to another machine. CS2007, SQL Server 2005, IIS5.

I read all the documents about that, controlled the accounts and so on.

So, when I call the site (localhost/sitename) I obtain the same error at the 44 line.

I control the logs and I have the same text you report. Some exception are the account name, in my case is <PC name>\ASPNET, the process name in my case is aspnet_wp.exe and the excpetion type is a COMException. Furthermore the message is teh follow, HRESULT:0xC1004004 (that in the message error list report a profile probelm)

I have all the profiles reported in the documents, RunTimeUser and so on.

I tried to find the help document you reported but without success.

Do you have some idea to help me

Thank in advance from Italy.

Regards





Re: Commerce Server 2007 Failed to retrieve profile

Max Akbar

Are you talking about having the error in Starter Site Can you post the error details

-Max






Re: Commerce Server 2007 Failed to retrieve profile

Sajid_mansoori

Baloo,

You can copy and paste that link in Commerce Server Help window. It will not work on IE. I hope it helps.

Sajid