Event ID - 32794

Event Id32794
SourceCommerce Server 2000
DescriptionDescription 1.
Error state: 1, Severity: 14, Server: <Server Name>, Line#: 1, msg: CREATE TABLE permission denied in database <Site>_dw.
Description 2.
Could not bind to connection string <string>
Event InformationAccording to Microsoft:
CAUSE:
The system may be configured with a large quantity of physical memory. Tools such as Task Manager and Performance Monitor may indicate that a large portion of that memory is available. For example, if the system is configured with four gigabytes of physical memory, less than one gigabyte of this memory may be in use. However, if the virtual memory for the Internet Information Services (IIS) DLLHost process for Medium Isolation mode approaches two gigabytes, problems start to occur. Even if the server has large memory resources that are available to the system, the virtual memory of the IIS process may become fragmented. Various errors may be reported, indicating that memory resources have been used up.
The Commerce Server OLE DB provider typically uses the SQL OLE DB provider to perform database operations. In a large E-Commerce site, the Commerce Profile services must continually retrieve data from the SQL database. The SQL OLE DB provider tries to allocate large contiguous blocks on demand to perform these operations. These allocations are performed in the virtual memory address space of the IIS process. If this process is approaching the process limit for virtual memory that is established by Microsoft Windows 2000, errors result. If no blocks of contiguous virtual memory are available because of fragmentation, the application may return error messages indicating that no memory is available.
RESOLUTION:
The user should seek the assistance of the SQL Database Administrator to obtain the appropriate db_owner role for the Data Warehouse.
If you are a Commerce Server administrator, you can supply the Global Resource for the sites Date Warehouse with another SQL ID that has the db_owner role. To do this, follow these steps:
1. Open the Commerce Server Manager.
2. Click to expand the Global Resources.
3. Right-click the Data Warehouse for your site, and then select Properties.
4. On the Connecti
Reference LinksCannot import product catalog information into the Commerce Server 2000 or Commerce Server 2002 Data Warehouse

Commerce Profile Services returns E_OutofMemory

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.