Hi,
I had a sales cube in which i am showing the data for last 5 years.
So when i process the cube it takes long time.
So i am doing incremetal update.
Now i want to automate it so, i did it from DTS Package but when i execute
the package it show Error that procress terminated.
When i see the error task file : The error is as follows
--------------------------------------------------------------
Error = 1 (00000001), Description = 6/22/2005 1:47:45 PM 10711
Processing Partition 'CustSaleRpt_update' Start time: 1:47:45 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:45 PM 10711
Initializing Partition 'CustSaleRpt_update'
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
Partition 'CustSaleRpt_update' Execute : SELECT
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ACCOUNTNUM",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ACCOUNTNAME" ,
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."CUSTGROUP",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."CUSTGROUPNAM E",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ITEMNAME",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."DLVMODE",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."EPI_TAXPACK_NO",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."INVENTSIZE",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ITEMGROUPID" ,
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ITEMGROUPNAM E",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ITEMID",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."MODELGROUPNAME",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."MODELNAME",
"OLAPAIC22_OLAPTIMEBYDAY"."YEAR", "OLAPAIC22_OLAPTIMEBYDAY"."QUARTER",
"OLAPAIC22_OLAPTIMEBYDAY"."MONTH", "OLAPAIC22_OLAPTIMEBYDAY"."WEEK",
"OLAPAIC22_OLAPTIMEBYDAY"."DAY",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."SALEMANNAME" ,
"OLAPAIC22_OLAPTIMEBYDAY"."YEAR", "OLAPAIC22_OLAPTIMEBYDAY"."MONTH",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."SALESUNIT",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."SALESGROUP",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."SALESID",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."CONFIGID",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."INVENTSIZEID ",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."ITEMNAME",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."EPI_SA_SUPERVISO RNAME",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."EPI_FREEQTY" ,
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."VALUEMST",
"OLAPAIC22_OLAP_CUSTPACKING_SAL"."QTY" FROM "OLAPAIC22_OLAP_CUSTPACKING_SAL",
"OLAPAIC22_OLAPTIMEBYDAY" WHERE
("OLAPAIC22_OLAP_CUSTPACKING_SAL"."DELIVERYDATE " =
"OLAPAIC22_OLAPTIMEBYDAY"."OLAPDATE")
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
A member with key 'ZINC OXIDE ACTIVE' was found in the fact table but was not
found in the level 'Description' of the dimension 'Description_OLAPAIC22_'.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
The maximum number of dimension key processing errors has been exceeded.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
A member with key 'NORDEL MG NDR 46140.01' was found in the fact table but
was not found in the level 'Description' of the dimension
'Description_OLAPAIC22_'.; Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
The maximum number of dimension key processing errors has been exceeded.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
A member with key 'A-06258/05' was found in the fact table but was not found
in the level 'Epi Tax Pack No' of the dimension 'Epi_taxpack_no_OLAPAIC22_'.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
The maximum number of dimension key processing errors has been exceeded.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
A member with key 'K35329' was found in the fact table but was not found in
the level 'Epi Tax Pack No' of the dimension 'Epi_taxpack_no_OLAPAIC22_'.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
The maximum number of dimension key processing errors has been exceeded.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
A member with key 'A-06257/05' was found in the fact table but was not found
in the level 'Epi Tax Pack No' of the dimension 'Epi_taxpack_no_OLAPAIC22_'.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:46 PM 10711
The maximum number of dimension key processing errors has been exceeded.;
Time:6/22/2005 1:47:46 PM
Error = 1 (00000001), Description = 6/22/2005 1:47:50 PM 10711
Processing Partition 'CustSaleRpt_update' failed. No changes have been made
to the database.
Error = 1 (00000001), Description = 6/22/2005 1:47:50 PM 10711
Rolling back transaction in Database 'aicnav'

What does this error trying to explain.

--
waiting for solution
from
Sufian

If you are using shared dimensions, process them before doing incremental
update.

Francesco Anti

"Mohd Sufian" <sufian (AT) aeroflex (DOT) co.th> ha scritto nel messaggio
news:23C148FC-B152-4F21-B5B1-1433E268BFC4 (AT) microsoft (DOT) com...