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
Server Error in '/OrdersWebService' Application.
isal
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.
gokce
matheny
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.
GroZZleR
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
Darren King
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.
Npotnis
No problem. Let me know how it goes. Did you run the SampleDataImport application
Paul
kkos
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 ...
Ian Tanner
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! ;-)
nhaas
You need to add Authorization permissions using Azman to the CatalogAuthorizationStore.xml file. Check out
http://msdn2.microsoft.com/en-us/library/ms914867.aspx
aybe
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