|
ProcessAdd на партиции -- кто-нб имел дело с этим?
#38736241
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: Москва
Сообщения: 4 636
|
|
Запускаю ProcessAdd на партиции. SSAS на 2012
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<KeyNotFound>IgnoreError</KeyNotFound>
<NullKeyNotAllowed>IgnoreError</NullKeyNotAllowed>
<KeyErrorLimit>-1</KeyErrorLimit>
</ErrorConfiguration>
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>GoodsMoves</DatabaseID>
<CubeID>Goods Moves</CubeID>
<MeasureGroupID>Vw GOODS MOVES</MeasureGroupID>
<PartitionID>Facts_GoodsMoves_201407</PartitionID>
</Object>
<ObjectDefinition>
<Partition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<ID>Facts_GoodsMoves_201407</ID>
<Name>Facts_GoodsMoves_201407</Name>
<Source xsi:type="QueryBinding">
<DataSourceID>Wildberries RU</DataSourceID>
<QueryDefinition>
SELECT [TableID] = [TableID] + 100
,[MoveDirection]
,[_Version]
,[pk_date]
,[doc_number]
,[Line_No]
,[shk_id]
,[chrt_id]
,[Wh_Code_from]
,[Wh_Code_to]
,[Amount_Rub] = -[Amount_Rub]
,[Price] = -[Price]
,[brand_cod]
,[collection_id]
,[f1]
,[gi_id]
,[IMT_id]
,[NM_id]
,[kind_id]
,[subject_id]
,[supplier_id]
,[tpsize_id]
,[TS_id]
,[IsNew]
,[When_Was_Supplied_Interval]
,[When_Was_Supplied]
FROM [WildberriesRU].[Facts].[Vw_GOODS_MOVES] F
WHERE F.pk_date BETWEEN
[Facts].[udf_PartitionStartDate]('GoodsMoves', 'GoodsMoves', 201407) AND
[Facts].[udf_PartitionEndDate] ('GoodsMoves', 'GoodsMoves', 201407)
AND shk_id % 10000 = 0
UNION ALL
SELECT [TableID] = [TableID] + 200
,[MoveDirection]
,[_Version]
,[pk_date]
,[doc_number]
,[Line_No]
,[shk_id]
,[chrt_id]
,[Wh_Code_from]
,[Wh_Code_to]
,[Amount_Rub] = + 1.1 * [Amount_Rub]
,[Price] = -1.1 * [Price]
,[brand_cod]
,[collection_id]
,[f1]
,[gi_id]
,[IMT_id]
,[NM_id]
,[kind_id]
,[subject_id]
,[supplier_id]
,[tpsize_id]
,[TS_id]
,[IsNew]
,[When_Was_Supplied_Interval]
,[When_Was_Supplied]
FROM [WildberriesRU].[Facts].[Vw_GOODS_MOVES] F
WHERE F.pk_date BETWEEN
[Facts].[udf_PartitionStartDate]('GoodsMoves', 'GoodsMoves', 201407) AND
[Facts].[udf_PartitionEndDate] ('GoodsMoves', 'GoodsMoves', 201407)
AND shk_id % 10000 = 0
</QueryDefinition>
</Source>
<StorageMode>Molap</StorageMode>
<ProcessingMode>Regular</ProcessingMode>
<Slice>[Даты].[Месяц].&[201407]</Slice>
<ProactiveCaching>
<SilenceInterval>-PT1S</SilenceInterval>
<Latency>-PT1S</Latency>
<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
<Source xsi:type="ProactiveCachingInheritedBinding" />
</ProactiveCaching>
<EstimatedRows>499999</EstimatedRows>
</Partition>
</ObjectDefinition>
</Alter>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<Object>
<DatabaseID>GoodsMoves</DatabaseID>
<CubeID>Goods Moves</CubeID>
<MeasureGroupID>Vw GOODS MOVES</MeasureGroupID>
<PartitionID>Facts_GoodsMoves_201407</PartitionID>
</Object>
<Type>ProcessAdd</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Batch>
Получаю
Началось чтение данных секции "Facts_GoodsMoves_201407_INCR_UPDATE_TEMP_vns2s_".
Чтение данных секции "Facts_GoodsMoves_201407_INCR_UPDATE_TEMP_vns2s_" завершено.
Запись данных для секции "Facts_GoodsMoves_201407_INCR_UPDATE_TEMP_vns2s_" завершена.
Начато построение агрегатов и индексов для секции "Facts_GoodsMoves_201407_INCR_UPDATE_TEMP_vns2s_".
Построение агрегатов и индексов для секции "Facts_GoodsMoves_201407_INCR_UPDATE_TEMP_vns2s_" завершено.
Выполнение завершено
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
<return xmlns="urn:schemas-microsoft-com:xml-analysis">
<results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
<root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
<Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" />
<Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
<Error ErrorCode="3238002710" Description="Внутренняя ошибка: Возникло непредвиденное исключение." Source="Службы Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
<Error ErrorCode="3239837702" Description="Сервер: Текущая операция отменена, поскольку другая операция в данной транзакции завершилась ошибкой." Source="Службы Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
<Error ErrorCode="3238002710" Description="Внутренняя ошибка: Возникло непредвиденное исключение." Source="Службы Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
</Messages>
</root>
</results>
</return>
Выполнение команд по отдельности ничего не меняет. Задача пока тестовая -- испытать инкрементальное обновление + - к данным партиции. |
|
|
