Commerce Server General - Data Warehouse resource will not add to site on CS 2007 Std

Author

Data Warehouse resource will not add to site on CS 2007 Std

Jamie

2006-09-25, 1:38 am

Hi,

I am attempting to add the data warehouse (DW.pup) resource to an
existing CS2007 STD site but it keeps failing with the following in the
PUP.LOG; "The required Data Warehouse components could not be found.
The Data Warehouse resource will not be created."

I have followed the on line installation instructions to the letter
without any success. I have tried it in 2 scenarios, one where the
reporting and analysis server in an another server in the domain and the
other where it is local to the web server. I have also installed the
CS2007 hot fix on the web server along with analysis services 2005 with
no avail.

I would appreciate any pearls of wisdom on this as I am at a total loss
along with the developers.

Many thanks, Jamie

Brian Blum [MSFT]

2006-09-25, 7:26 pm

If the version of SQL that you're trying to unpup to is SQL 2000, you need
to have Analysis Services installed on the pup machine until the DW is
finished unpupping. This is because the cubes are created using the AS
2000 archive/restore mechanism. Once the DW is unpupped, you can remove AS
2000 from the unpup box.

If you're unpupping to a SQL 2005 machine, you need to have SQL Client
tools on the pup machine.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Date: Sun, 24 Sep 2006 12:34:14 +0100
From: Jamie <jamie@mistral.net>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Subject: Data Warehouse resource will not add to site on CS 2007 Std
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <us5Ve183GHA.5000@TK2MSFTNGP02.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: 217.154.227.114
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18518
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi,

I am attempting to add the data warehouse (DW.pup) resource to an
existing CS2007 STD site but it keeps failing with the following in the
PUP.LOG; "The required Data Warehouse components could not be found.
The Data Warehouse resource will not be created."

I have followed the on line installation instructions to the letter
without any success. I have tried it in 2 scenarios, one where the
reporting and analysis server in an another server in the domain and the
other where it is local to the web server. I have also installed the
CS2007 hot fix on the web server along with analysis services 2005 with
no avail.

I would appreciate any pearls of wisdom on this as I am at a total loss
along with the developers.

Many thanks, Jamie

Jamie

2006-09-26, 7:23 am

Hi Brian,

Thanks for your response although I am using SQL 2005 and the SQL client
tools are installed on the web server where I am trying to unpup DW.

Any ideas?

Thanks again, Jamie

Brian Blum [MSFT] wrote:
> If the version of SQL that you're trying to unpup to is SQL 2000, you need
> to have Analysis Services installed on the pup machine until the DW is
> finished unpupping. This is because the cubes are created using the AS
> 2000 archive/restore mechanism. Once the DW is unpupped, you can remove AS
> 2000 from the unpup box.
>
> If you're unpupping to a SQL 2005 machine, you need to have SQL Client
> tools on the pup machine.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Date: Sun, 24 Sep 2006 12:34:14 +0100
> From: Jamie <jamie@mistral.net>
> User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
> MIME-Version: 1.0
> Subject: Data Warehouse resource will not add to site on CS 2007 Std
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
> Message-ID: <us5Ve183GHA.5000@TK2MSFTNGP02.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: 217.154.227.114
> Lines: 1
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18518
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
>
> I am attempting to add the data warehouse (DW.pup) resource to an
> existing CS2007 STD site but it keeps failing with the following in the
> PUP.LOG; "The required Data Warehouse components could not be found.
> The Data Warehouse resource will not be created."
>
> I have followed the on line installation instructions to the letter
> without any success. I have tried it in 2 scenarios, one where the
> reporting and analysis server in an another server in the domain and the
> other where it is local to the web server. I have also installed the
> CS2007 hot fix on the web server along with analysis services 2005 with
> no avail.
>
> I would appreciate any pearls of wisdom on this as I am at a total loss
> along with the developers.
>
> Many thanks, Jamie
>

Brian Blum [MSFT]

2006-09-27, 7:30 pm

I just reread your original post and realized that DW is not supported on
CS 2007 STD edition. The error message you're seeing is because the pup
package is looking for a file that isn't installed on STD.

DW is part of Developer Edition for prototyping and Enterprise Edition.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Date: Tue, 26 Sep 2006 07:56:26 +0100
From: Jamie <jamie@mistral.net>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Subject: Re: Data Warehouse resource will not add to site on CS 2007 Std
References: <us5Ve183GHA.5000@TK2MSFTNGP02.phx.gbl>
<GRB#A2L4GHA.400@TK2MSFTNGXA01.phx.gbl>
In-Reply-To: <GRB#A2L4GHA.400@TK2MSFTNGXA01.phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <uyqpjjT4GHA.1256@TK2MSFTNGP04.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: 217.154.227.114
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18533
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi Brian,

Thanks for your response although I am using SQL 2005 and the SQL client
tools are installed on the web server where I am trying to unpup DW.

Any ideas?

Thanks again, Jamie

Brian Blum [MSFT] wrote:
> If the version of SQL that you're trying to unpup to is SQL 2000, you
need
> to have Analysis Services installed on the pup machine until the DW is
> finished unpupping. This is because the cubes are created using the AS
> 2000 archive/restore mechanism. Once the DW is unpupped, you can remove
AS
> 2000 from the unpup box.
>
> If you're unpupping to a SQL 2005 machine, you need to have SQL Client
> tools on the pup machine.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBuisness Server Team
> --------------------
> Date: Sun, 24 Sep 2006 12:34:14 +0100
> From: Jamie <jamie@mistral.net>
> User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
> MIME-Version: 1.0
> Subject: Data Warehouse resource will not add to site on CS 2007 Std
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
> Message-ID: <us5Ve183GHA.5000@TK2MSFTNGP02.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: 217.154.227.114
> Lines: 1
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18518
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
>
> I am attempting to add the data warehouse (DW.pup) resource to an
> existing CS2007 STD site but it keeps failing with the following in the
> PUP.LOG; "The required Data Warehouse components could not be found.
> The Data Warehouse resource will not be created."
>
> I have followed the on line installation instructions to the letter
> without any success. I have tried it in 2 scenarios, one where the
> reporting and analysis server in an another server in the domain and the
> other where it is local to the web server. I have also installed the
> CS2007 hot fix on the web server along with analysis services 2005 with
> no avail.
>
> I would appreciate any pearls of wisdom on this as I am at a total loss
> along with the developers.
>
> Many thanks, Jamie
>

Jamie

2006-09-28, 7:22 pm

Hi Brian,

Many thanks for this. Really do appreciate your time.

Jamie

Brian Blum [MSFT] wrote:
> I just reread your original post and realized that DW is not supported on
> CS 2007 STD edition. The error message you're seeing is because the pup
> package is looking for a file that isn't installed on STD.
>
> DW is part of Developer Edition for prototyping and Enterprise Edition.
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Date: Tue, 26 Sep 2006 07:56:26 +0100
> From: Jamie <jamie@mistral.net>
> User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
> MIME-Version: 1.0
> Subject: Re: Data Warehouse resource will not add to site on CS 2007 Std
> References: <us5Ve183GHA.5000@TK2MSFTNGP02.phx.gbl>
> <GRB#A2L4GHA.400@TK2MSFTNGXA01.phx.gbl>
> In-Reply-To: <GRB#A2L4GHA.400@TK2MSFTNGXA01.phx.gbl>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
> Message-ID: <uyqpjjT4GHA.1256@TK2MSFTNGP04.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: 217.154.227.114
> Lines: 1
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18533
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi Brian,
>
> Thanks for your response although I am using SQL 2005 and the SQL client
> tools are installed on the web server where I am trying to unpup DW.
>
> Any ideas?
>
> Thanks again, Jamie
>
> Brian Blum [MSFT] wrote:
> need
> AS
> rights.
>

Jamie

2006-09-28, 7:22 pm

Jamie

2006-09-28, 7:22 pm