none
AS 2000的FoodMart 2000迁移到AS 2008后处理时遇到的错误。 RRS feed

  • 问题

  • 迁移后处理时遇到两个错误:

    1:处理 分区“Sales”失败。
        开始时间: 2010-5-5 14:06:36;结束时间: 2010-5-5 14:06:36;持
    续时间: 0:00:00
        错误消息 1
         后端数据库访问模块中存在错误。 OLE DB 报告列 4 的状
    态为“8”(一种未知状态)。 OLAP 存储引擎中存在错误: 处理“Sales”分区时出错,该分区属于
    FoodMart 2000 数据库的“Sales”多维数据集的“Sales”度量值组。
        SQL 查询 1
         SELECT [T_0].[_19970_0] AS [_19970_0],[T_0].
    [_19970_1] AS [_19970_1],[T_0].[_19970_2] AS [_19970_2],[T_0].[_19970_3] AS [_19970_3],
    [T_0].[_19970_4] AS [_19970_4],[T_0].[_19970_5] AS [_19970_5],[T_0].[_19970_6] AS
    [_19970_6],[T_0].[_19970_7] AS [_19970_7],[T_0].[_19970_8] AS [_19970_8]
      FROM
         (
       
        SELECT [unit_sales] AS [_19970_0],[store_cost] AS [_19970_1],[store_sales] AS
    [_19970_2],[product_id] AS [_19970_3],"store_sales"-"store_cost"   AS [_19970_4],[time_id]
    AS [_19970_5],[promotion_id] AS [_19970_6],[customer_id] AS [_19970_7],[store_id] AS
    [_19970_8]
      FROM [sales_fact_1997] AS [sales_fact_1997]
         )
         AS [T_0]

    2:处理 分区“Warehouse”失败。
        开始时间: 2010-5-5 14:21:00;结束时间: 2010-5-5 14:21:01;持续时间: 0:00:01
        错误消息 1
         OLE DB 错误: OLE DB 或 ODBC 错误 : 查询语法错误。查询子句不完整。; 3450。
        SQL 查询 1
         SELECT [T_0].[_19970_0] AS [_19970_0],[T_0].[_19970_1] AS [_19970_1],[T_0].[_19970_2] AS [_19970_2],[T_0].[_19970_3] AS [_19970_3],[T_0].[_19970_4] AS [_19970_4],[T_0].[_19970_5] AS [_19970_5],[T_0].[_19970_6] AS [_19970_6],[T_0].[_19970_7] AS [_19970_7],[T_0].[_19970_8] AS [_19970_8],[T_0].[_19970_9] AS [_19970_9],[T_0].[19970_10] AS [19970_10]
      FROM
         (
       
        SELECT [store_invoice] AS [_19970_0],[supply_time] AS [_19970_1],[warehouse_cost] AS [_19970_2],[warehouse_sales] AS [_19970_3],[units_shipped] AS [_19970_4],[units_ordered] AS [_19970_5],"warehouse_sales"-"warehouse_Cost"   AS [_19970_6],[time_id] AS [_19970_7],[store_id] AS [_19970_8],[warehouse_id] AS [_19970_9],[product_id] AS [19970_10]
      FROM
       (
     
    SELECT "inventory_fact_1997"."store_invoice", "inventory_fact_1997"."supply_time", "inventory_fact_1997"."warehouse_cost", "inventory_fact_1997"."warehouse_sales", "inventory_fact_1997"."units_shipped", "inventory_fact_1997"."units_ordered", "warehouse_sales"-"warehouse_Cost" AS "Column1", "inventory_fact_1997"."product_id", "inventory_fact_1997"."warehouse_id", "inventory_fact_1997"."store_id", "inventory_fact_1997"."time_id" FROM "inventory_fact_1997", "time_by_day" WHERE "inventory_fact_1997"."time_id"="time_by_day"."time_id" AND "time_by_day"."the_year"=1997
       )
       AS [inventory_fact_1997]
         )
         AS [T_0]
    响应中的错误和警告
     内部错误: 操作未能成功,已终止。
     内部错误: 操作未能成功,已终止。
     OLE DB 错误: OLE DB 或 ODBC 错误 : 查询语法错误。查询子句不完整。; 3450。
     OLAP 存储引擎中存在错误: 处理“Warehouse”分区时出错,该分区属于 FoodMart 2000 数据库的“Warehouse”多维数据集的“Warehouse 度量值组”度量值组。
     服务器: 操作已取消。

    各位父老乡亲,给指点指点吧,谢谢!如何修改维度和度量值呢,谢谢!

    2010年5月5日 7:12

答案