July 8, 2011, 10:14 am
Anyone who has worked with Microsoft Commerce Server over the years has learned that a busy commerce site results in a VERY busy Catalog Scratch database.
Microsoft has included a tool with the Commerce Server install called CatalogCleanup.VBS. This script will essentially delete all of the temporary tables from the Catalog Scratch database.
It is recommended that this be done weekly.
A quick look at the script results in seeing this simple SQL statement which is run against the Catalog Database.
EXEC dbo.ctlg_DropPersistentTablesInScratchDB 0
So I say, why not create a SQL Server Job that runs this weekly. Just my two pennies.
December 28, 2009, 3:51 pm
When you attempt to access your Catalog Web Service,
http://localhost/DefaultSite_CatalogWebService/CatalogWebService.asmx?op=GetServiceVersion
Click the Invoke Button
A new window will open displaying the following error:
System.Web.Services.Protocols.SoapException: The catalog Web service does not have write access to the authorizationPolicyPath. Verify that the file exists and that it has the appropriate permissions. —> Microsoft.CommerceServer.ServerFaultException: The catalog Web service does not have write access to the authorizationPolicyPath. Verify that the file exists and that it has the appropriate permissions.
— End of inner exception stack trace —
at Microsoft.CommerceServer.Catalog.Internal.WebServiceUtility.PropagateOrLogException(Exception except)
at Microsoft.CommerceServer.Catalog.Internal.WebServiceUtility.Initialize()
at Microsoft.CommerceServer.Catalog.Internal.WebServiceUtility.get_CatalogExecutionContext()
at Microsoft.CommerceServer.Catalog.WebService.CatalogWebService..ctor()
What you need to do to fix this, simply grant Modify permissions to the CatalogAutorizationStore.xml file in the Web Service directory to the user for the Catalog Web Service Application Pool.
For example if the application pool runs as DOMAINCommerceService then you will need to ensure that that user has access to write to the CatalogAuthorizationStore.xml file.
