WingingIT

Hi, I've had this error on 2 separate sites (CsharpSite and StarterSite). Am really struggling to resolve it. Looks like the AllowedStatusTable is expecting data but doesn't have any. I've found another post on the forum for the same problem http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1083101&SiteID=1 but he didn't get an answer. I'm sure we'd both appreciate some help. Thanks very much.

Server Error in '/OrdersWebService' Application.
The specified value for the newOrderStatus attribute is not valid. The value provided was: 'NewOrder'. Please make sure an entry for this value exists in the AllowedStatus table in the transaction config database.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Configuration.ConfigurationErrorsException: The specified value for the newOrderStatus attribute is not valid. The value provided was: 'NewOrder'. Please make sure an entry for this value exists in the AllowedStatus table in the transaction config database.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ConfigurationErrorsException: The specified value for the newOrderStatus attribute is not valid. The value provided was: 'NewOrder'. Please make sure an entry for this value exists in the AllowedStatus table in the transaction config database.]
Microsoft.CommerceServer.Runtime.Orders.OrderContext.Initialize(String transactionResourceConnectionString, String transactionConfigResourceConnectionString) +733
Microsoft.CommerceServer.Runtime.Orders.OrderContext.Create(String transactionResourceConnectionString, String transactionConfigResourceConnectionString) +114
Microsoft.CommerceServer.Runtime.Orders.CommerceOrderModule.CreateOrderContext() +68
Microsoft.CommerceServer.Runtime.Orders.CommerceOrderModule.get_OrderContext() +87
Microsoft.CommerceServer.Runtime.Orders.CommerceOrderModule.OnBeginRequest(Object sender, EventArgs e) +18
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.62



Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

Paul Tew

Hi

The following values are in the AllowedStatus table in our database:

Cancelled

InProcess

NewOrder

Rejected

Shipped

Submitted

It sounds like part of your installation of the StarterSite failed.

Paul





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

WingingIT

Thanks very much Paul. I'll put those in and see what happens. You may be right about the installation failing, but I didn't see any obvious sign of that. Probably too late to look in the error log - it's stuffed with errors from my other problems ;-)



Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

Paul Tew

No problem. Let me know how it goes. Did you run the SampleDataImport application

Paul





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

WingingIT

Oh yeah, the sample data import ... (see below). However, the "server error in /orderswebservice" problem I've had with the CSharpSite, so it's not simply a data import problem (although it would be nice if I could get that working ...)

Thanks.

Adding encryption keys to web.config: Done.
Adding encryption keys to web.config for the ProfilesWebService:

Importing catalog:Warning: The following errors occured during import:
You are not authorized to perform the import operation. Ensure that you have adequate permissions to perform the import operation before running this tool.
Done.

Updating Inventory resource:
Importing inventory catalog:
Warning: The following errors occured during import:
You are not authorized to perform the import operation. Ensure that you have adequate permissions to perform the import operation before running this tool.
Done.





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

Paul Tew

It sounds like the databases needs the correct user permissions adding. Have you set the following permissions:

http://download.microsoft.com/download/d/b/e/dbe333fd-6cbe-4850-b24c-8da3704d6190/Commerce%20Server%202007%20Starter%20Site%20Installation%20Guide.htm#Associate_Database_Accounts

Paul





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

WingingIT

Absolutely, emphatically, yes. I even re-created that page in an Excel spreadsheet so I would be sure not to miss anything. Looks like I missed something ....

I'm going to bin the lot and start again - thanks very much for your help - don't go too far! ;-)





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

Paul Tew

OK I've got exactly the same issue on our test server now. I've gone through the permissions repeatedly to make sure I haven't missed anything.

One thing I've noticed is that the SampleDataImport expects the CatalogWebService to be in the wwwroot folder, but mine isn't.

When I use the web service from my browser the GetCatalogs operation returns a SOAP error. I've tried tracing it with Fiddler but there isn't anything obvious.

Any help would be hugely appreciated.





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

Sudha Raghavan - MSFT

You need to add Authorization permissions using Azman to the CatalogAuthorizationStore.xml file. Check out

http://msdn2.microsoft.com/en-us/library/ms914867.aspx





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

Paul Tew

One thing I've noticed is that Azman complains that it can't find the previously opened authorization stores when I first run it. The stores open ok, but I can't help but feel that might be related to my problem.

I've assigned the user roles to all of the stores, but the problem keeps occuring. I then added the domain administrator account to the "Administrator" role in the catalog store.





Re: Commerce Server 2007 Server Error in '/OrdersWebService' Application.

WingingIT

On unpacking yet another startersite, I found this error in the log:

"8004E024:COM+ activation failed because the activation could not be completed in the specified amount of time. (Exception from HRESULT: 0x8004E024)"

On searching Google, I found this document:

http://go.microsoft.com/fwlink/ linkid=57013 (The CS2007 "readme")

It explains:

Unpacking a site might not populate the AllowedStatus table

The following error message might occur in the site packager log file:

"8004E024:COM+ activation failed because the activation could not be completed in the specified amount of time. (Exception from HRESULT: 0x8004E024)"

This error message indicates that Commerce Server could not populate the AllowedStatus table in the transactionconfig database. To populate the AllowedStatus table, open SQL Server Management Studio (open SQL Query Analyzer if you are using SQL Server 2000), and run the regiondata SQL script against the transactionconfig database. The regiondata script is located at %COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate\.

So there you have it. Only took me 2 weeks to resolve it ...