迁移到新服务器后，多维数据集进程失败 [英] Cube process failing after migration to the new server

问题描述

大家好，

我从（在我当前的服务器SQL SERVER 10.5上恢复）迁移了SSAS数据库。当我处理立方体或昏暗时，它们会失败。 DSV中的Dims是命名查询，它们在新服务器的SSMS中运行良好。当我处理他们没有愚蠢的
错误。

I migrated the SSAS Data base from (restore on my current server SQL SERVER 10.5) . When i process the cubes or dims they are failing. Dims in the DSV are named queries and they run good in SSMS of the new server. When i process they are failing for silly errors.

处理DIM时一个错误的例子（

Example of one errror while processing DIM (

SELECT 

  DISTINCT

  [T_0]。[CaseStatus] AS [tuses0_0]

   FROM [dbo]。[DIM_CaseStatuses] AS [ T_0]）

SELECT 
  DISTINCT
 [T_0].[CaseStatus] AS [tuses0_0]
   FROM [dbo].[DIM_CaseStatuses] AS [T_0])

错误消息：

OLE DB错误：OLE DB或ODBC错误：查询（5,34）解析器：'的语法' AS'不正确。 （

  SELECT 

  DISTINCT

  [T_0]。[CaseStatus] AS [tuses0_0]

   FROM [dbo]。[DIM_CaseStatuses] AS [T_0]）..

OLE DB error: OLE DB or ODBC error: Query (5, 34) Parser: The syntax for 'AS' is incorrect. (
  SELECT 
  DISTINCT
 [T_0].[CaseStatus] AS [tuses0_0]
   FROM [dbo].[DIM_CaseStatuses] AS [T_0] )..

请参阅下面的版本

CURRENT版本

Microsoft SQL Server Management Studio 10.50.6560.0

Microsoft Analysis Services客户端工具< span style ="white-space：pre"> 10.50.6560.0

Microsoft数据访问组件（MDAC） 6.1 .7601.17514

Microsoft MSXML 3.0 6.0 

Microsoft Internet Explorer 8.0.7601.24000

Microsoft .NET Framework 2.0.50727.8793

操作系统 6.1.7601

Microsoft SQL Server Management Studio 10.50.6560.0
Microsoft Analysis Services Client Tools 10.50.6560.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0 
Microsoft Internet Explorer 8.0.7601.24000
Microsoft .NET Framework 2.0.50727.8793
Operating System 6.1.7601

新服务器版本：

Microsoft SQL Server Management Studio 14.0.17285.0

Microsoft Analysis Services客户端工具 14.0.1016.283

Microsoft数据访问组件（MDAC） 10.0.14393.0

Microsoft MSXML 3.0 6.0  

Microsoft Internet Explorer 9.11.14393.0

Microsoft .NET Framework 4.0.30319.42000

操作系统 6.3.14393

Microsoft SQL Server Management Studio 14.0.17285.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0 
Microsoft Internet Explorer 9.11.14393.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.14393

请建议。 DIM命名查询在新服务器SSMS中运行良好

Please suggest. The DIM Named queries run good in the new server SSMS

谢谢

推荐答案

您好thinkingeye，

Hi thinkingeye,

感谢您的提问。

我试图像你在我的SSAS 2016实例中所说的那样重现这个问题，但我不能。一切都按预期工作，见下面我实验室测试的图像：

I was trying to reproduce this issue as you said in my SSAS 2016 instance, but i can not. Everything just worked as expected, see below images tested in my lab:

这篇关于迁移到新服务器后，多维数据集进程失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！