Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 889576 - Last Review: March 13, 2007 - Revision: 1.3
You receive the "msmdarch.exe not found" error message when you try to add a Data Warehouse resource to an existing Commerce Server 2002 site
In Microsoft Commerce Server 2002, when you try to add a
Data Warehouse resource to an existing Commerce Server 2002 site, you receive
the following error message:
msmdarch.exe not found,
system may not have the necessary OLAP installations, this will break the OLAP
cubes creation. Its recommended to skip the Data Warehouse installation. You
can install it later on.
In this error message, the word "It's" is misspelled as
"Its."
When you click
OK, you are returned to the
Data Warehouse page of the
Commerce Server Site Packager
dialog box. You receive this error message even if you receive the following
message when you click
Test Connection in the Data Warehouse
page of the
Commerce Server Site Packager dialog box:
Connection Succeeded.
This issue occurs when the following conditions are true:
- Microsoft SQL Server 2000 Analysis Services is not running
on the Web server where you want to unpack the Data Warehouse
resource.
- You specify a remote Analysis server in the
Analysis Server Properties area of the Data
Warehouse page of the Commerce Server Site Packager
dialog box.
Commerce Server 2002 requires that SQL Server 2000 Analysis
Services Service Pack 3 (SP3) be running on the Web server where you want to
unpack the Data Warehouse resource.
Important While Commerce Server 2002 requires that Analysis Services be
running on the Web server where you unpack the Data Warehouse resource, you do
not have to specify the local computer that is running Analysis Services when
you add the Data Warehouse resource. Instead, you can specify a remote computer
that is running Analysis Services when you unpack the Data Warehouse resource.
Therefore, after you unpack the Data Warehouse resource, you can remove
Analysis Services from the local Web server.
To work around this issue, follow these steps:
- On the Web server where you want to unpack the Data
Warehouse resource, install SQL Server 2000 Analysis Services together with SQL
Server 2000 Analysis Services Service Pack 3 (SP3).
- Add the Data Warehouse resource. Specify the remote
computer that is running Analysis Services when you do this.
- Remove Analysis Services from the Web server where you
added the Data Warehouse resource.
For more information about how to add a resource to a
Commerce Server site, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Commerce Server 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate