使用SQL Server 2008 R2在Commerce Server 2009 R2中添加DW.pup资源时出现问题 [英] Problem Adding DW.pup Resource in Commerce Server 2009 R2 with SQL Server 2008 R2

问题描述

我正在尝试在Commerce Server 2009中添加DW.pup资源，但我无法。

I am trying to add DW.pup resource in Commerce Server 2009 but I am unable to.

日志中的错误是：

[23:16:38]文件解压完成

[23:16:38]为全局数据仓库创建全局资源

3/27/2011 11:16:52 PM  PupLogFileName：C：\ Pup.log

3/27/2011 11:16:52 PM  IsDBExisting：服务器：JARJARBINKS，dbname：SolutionStorefrontSite_datawarehouse

3/27/2011 11:16:52 PM 连接到服务器：JARJARBINKS

[23:16:38] File decompression is complete
[23:16:38] Creating global resource for Global Data Warehouse
3/27/2011 11:16:52 PM  PupLogFileName: C:\Pup.log
3/27/2011 11:16:52 PM  IsDBExisting: server: JARJARBINKS, dbname: SolutionStorefrontSite_datawarehouse
3/27/2011 11:16:52 PM  Connecting to server: JARJARBINKS

时间= 2011年3月27日星期日23:16:52网站= SolutionStorefrontSite 资源=全球数据仓库  Function =（null）

数据仓库模式已存在于指定的数据库中。模式不会被重新创建。

时间= 2011年3月27日星期日23:16:52网站= SolutionStorefrontSite 资源=全球数据仓库  Function = COLAPStore :: CreateSchema

OLAP数据库的日志&可以在C：\ CommerceOlap.log找到多维数据集创建

Time=Sunday, March 27, 2011 23:16:52 Site=SolutionStorefrontSite  Resource=Global Data Warehouse   Function=(null)
Data warehouse schema already exist in the specified database. Schema will not be recreated.
Time=Sunday, March 27, 2011 23:16:52 Site=SolutionStorefrontSite  Resource=Global Data Warehouse   Function=COLAPStore::CreateSchema
The log for OLAP database & cube creation could be found at C:\CommerceOlap.log

时间= 2011年3月27日星期日23:16:52 Site = SolutionStorefrontSite 资源=全球数据仓库  Function = COLAPStore :: CreateSchema

C：\Program Files（x86）\ Microsoft Commerce Server 9.0 \ Data\CommerceOlap.xmla3 / 27/2011 11:16:52 PM 初始化：服务器：JARJARBINKS，cubeFileName：C：\Program Files（x86）\ Microsoft Commerce Server 9.0 \ Data\CommerceOlap.xmla，pupLogFileName：C：\ Pup.log

3 / 27/2011 11:16:52 PM 连接到服务器：JARJARBINKS

Time=Sunday, March 27, 2011 23:16:52 Site=SolutionStorefrontSite  Resource=Global Data Warehouse   Function=COLAPStore::CreateSchema
C:\Program Files (x86)\Microsoft Commerce Server 9.0\Data\CommerceOlap.xmla3/27/2011 11:16:52 PM  Initialize: server: JARJARBINKS, cubeFileName: C:\Program Files (x86)\Microsoft Commerce Server 9.0\Data\CommerceOlap.xmla, pupLogFileName: C:\Pup.log
3/27/2011 11:16:52 PM  Connecting to server: JARJARBINKS

时间= 2011年3月27日星期日23:16:52网站= SolutionStorefrontSite 资源=全球数据仓库  Function = HrDispCall

无法执行方法CreateCubes

无法加载文件或程序集'Microsoft.AnalysisServices，Version = 9.0.242.0，Culture = neutral，PublicKeyToken = 89845dcd8080cc91'或其中一个依赖项。系统找不到指定的文件。

时间= 2011年3月27日星期日23:16:52网站= SolutionStorefrontSite 资源=全球数据仓库 函数=（null）

无法在Microsoft.CommerceServer.Internal.Analysis.PupHelper.CubeInstaller上调用方法CreateCubes。

时间= 2011年3月27日星期日23:16 ：52 Site = SolutionStorefrontSite 资源=全球数据仓库  Function =（null）

无法创建olapStore模式。[23:16:52]错误：无法创建全局资源。可能会发生此错误，因为已存在具有相同名称的全局资源。有关更多详细信息，请参阅跟踪信息（上文）。

[23:16:52]为站点数据仓库添加配置数据

[23:16:52] Extracting Config流内容并放入C：\ Users \Administrator \ AppData \ Local \Temp \\\\ Site Data Warehouse_Config.blb file

[23:16:52]提取对象来自Config的站点数据仓库的数据

[23:16:52]从流数据获取站点数据仓库的对象数据

[23:16:52]提取数据流内容和放入C：\ Users \Administrator \ AppData \ Local \Temp \\\\Site Data Warehouse.blb file

[23:16:53]操作已完成

[23:16:54]显示最终信息屏幕

Time=Sunday, March 27, 2011 23:16:52 Site=SolutionStorefrontSite  Resource=Global Data Warehouse   Function=HrDispCall
Failed to execute method CreateCubes
Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Time=Sunday, March 27, 2011 23:16:52 Site=SolutionStorefrontSite  Resource=Global Data Warehouse   Function=(null)
Failed to call method CreateCubes on Microsoft.CommerceServer.Internal.Analysis.PupHelper.CubeInstaller.
Time=Sunday, March 27, 2011 23:16:52 Site=SolutionStorefrontSite  Resource=Global Data Warehouse   Function=(null)
Failed to create olapStore schema.[23:16:52] Error: Could not create the global resource. This error may occur because a global resource with the same name already exists. See the trace information (above) for more details.
[23:16:52] Adding config data for Site Data Warehouse
[23:16:52] Extracting Config stream contents and putting in C:\Users\Administrator\AppData\Local\Temp\1\Site Data Warehouse_Config.blb file
[23:16:52] Extracting object data for Site Data Warehouse from Config
[23:16:52] Getting object data for Site Data Warehouse from stream Data
[23:16:52] Extracting Data stream contents and putting in C:\Users\Administrator\AppData\Local\Temp\1\Site Data Warehouse.blb file
[23:16:53] Operation Completed
[23:16:54] Displaying Final information screen

你能帮我吗？

 

谢谢。

最好的问候，

 

  ;

推荐答案

您之前是否创建了DW？因为错误告诉"架构存在"。

Have you previously created the DW? since the error tells "schema exists".

 

您可以打开商务经理并删除所有DW资源。您也可以打开Sql Server Management Studio并删除以前创建的DW数据库。

You can open the commerce manager and delete all DW resources. Also you can open Sql Server Management Studio and delete previously created DW databases.

 

然后您可以尝试再次添加DW资源  ;使用PUP文件

Then you can try to add the DW resource again using the PUP file

 

这篇关于使用SQL Server 2008 R2在Commerce Server 2009 R2中添加DW.pup资源时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！