Re: LIMIT OF FACT TABLE DATA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Fernando Ponte (FernandoPonte_at_discussions.microsoft.com)
Date: 07/27/04

• Next message: anonymous_at_devdex.com: "COUNT help with JOIN"
• Previous message: Indyyan: "Process Cube"
• In reply to: Akber: "Re: LIMIT OF FACT TABLE DATA"
• Messages sorted by: [ date ] [ thread ]

---

Date: Tue, 27 Jul 2004 11:03:02 -0700

Hi all.

I guess that an Unspecified Error is happening because each line in the log file has the following text

Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM 14103 * User: NT AUTHORITY\SYSTEM
Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM 14103 * Time Processing started: 7/19/2004 11:50:17 AM
Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM 14103 * Log ID: 14103
...

If this is true then is this happening because the datasource is not an SQL Server database? Why the process didn't stop?
Dave, please let us know your point of view.

Sorry, If I am bringing more questions than answers, but I am trying to find a solution. Some day I will have to work with Oracle datasources again.

-- 
Ponte
"Akber" wrote:
> My log file for the cube processing gives the following information. If anybody of you gurus found any important point in the log that could help rectifying my problem please do comment.
> 
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    **************************************************************************
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    Processing Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    Server: BIS
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    User: NT AUTHORITY\SYSTEM
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    Time Processing started: 7/19/2004 11:48:58 AM
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    Log ID: 29571
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    *    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    **************************************************************************
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571    Initiating transaction in Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571        Processing Dimension 'Location' Start time: 11:48:58 AM
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571            Process information for Dimension 'Location': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571            Initializing Dimension 'Location'
> Error = 1 (00000001), Description = 7/19/2004 11:48:58 AM    29571            Dimension 'Location' Execute : SELECT DISTINCT "BIS_DWH"."D_AREA"."AREA_NAME", "BIS_DWH"."D_STATION"."STATION_NAME" FROM "BIS_DWH"."D_STATION", "BIS_DWH"."D_AREA" WHERE ("BIS_DWH"."D_STATION"."AREA_ID"="BIS_DWH"."D_AREA"."AREA_ID")
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571        Completed Processing Dimension 'Location'. End time: 11:49:01 AM  Duration: 0:00:03  Rows processed: 411
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571        Processing Dimension 'PRODUCT' Start time: 11:49:01 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Process information for Dimension 'PRODUCT': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Initializing Dimension 'PRODUCT'
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Dimension 'PRODUCT' Execute : SELECT DISTINCT "BIS_DWH"."D_PRODUCT"."PRODUCT_CATEGORY", "BIS_DWH"."D_PRODUCT"."PRODUCT_ID", "BIS_DWH"."D_PRODUCT"."PRODUCT_NAME" FROM "BIS_DWH"."D_PRODUCT"
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571        Completed Processing Dimension 'PRODUCT'. End time: 11:49:01 AM  Duration: 0:00:00  Rows processed: 35
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571        Processing Dimension 'DATE' Start time: 11:49:01 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Process information for Dimension 'DATE': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Initializing Level 'Year'
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Initializing Level 'Quarter'
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Initializing Level 'Month'
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Initializing Level 'Day'
> Error = 1 (00000001), Description = 7/19/2004 11:49:01 AM    29571            Initializing Dimension 'DATE'
> Error = 1 (00000001), Description = 7/19/2004 11:49:02 AM    29571            Dimension 'DATE' Execute : SELECT DISTINCT {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}, {fn QUARTER("BIS_DWH"."D_DATE"."D_DATE")}, {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}||' Q ' ||{fn QUARTER("BIS_DWH"."D_DATE"."D_DATE")}, {fn MONTH("BIS_DWH"."D_DATE"."D_DATE")}, {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}||'/'||{fn MONTHNAME("BIS_DWH"."D_DATE"."D_DATE")}, TO_CHAR("BIS_DWH"."D_DATE"."D_DATE", 'YYYY-MM-DD'), substr(TO_CHAR("BIS_DWH"."D_DATE"."D_DATE", 'Day'),0,3)||' ' ||TO_CHAR("BIS_DWH"."D_DATE"."D_DATE", 'DD')||'/'||TO_CHAR("BIS_DWH"."D_DATE"."D_DATE", 'Mon')||'/'||{fn YEAR("BIS_DWH"."D_DATE"."D_DATE")} FROM "BIS_DWH"."D_DATE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:02 AM    29571            Dimension 'DATE' Execute : SELECT DISTINCT {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}, "BIS_DWH"."D_DATE"."WORKING_DAY", "BIS_DWH"."D_DATE"."D_DATE", "BIS_DWH"."D_DATE"."YEAR", "BIS_DWH"."D_DATE"."QUARTER", "BIS_DWH"."D_DATE"."MONTH" FROM "BIS_DWH"."D_DATE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:03 AM    29571            Dimension 'DATE' Execute : SELECT DISTINCT {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}, {fn QUARTER("BIS_DWH"."D_DATE"."D_DATE")}, "BIS_DWH"."D_DATE"."D_DATE", "BIS_DWH"."D_DATE"."YEAR", "BIS_DWH"."D_DATE"."QUARTER", "BIS_DWH"."D_DATE"."MONTH", "BIS_DWH"."D_DATE"."WORKING_DAY" FROM "BIS_DWH"."D_DATE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:03 AM    29571            Dimension 'DATE' Execute : SELECT DISTINCT {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}, {fn QUARTER("BIS_DWH"."D_DATE"."D_DATE")}, {fn MONTH("BIS_DWH"."D_DATE"."D_DATE")}, "BIS_DWH"."D_DATE"."WORKING_DAY", "BIS_DWH"."D_DATE"."D_DATE", "BIS_DWH"."D_DATE"."YEAR", "BIS_DWH"."D_DATE"."MONTH", "BIS_DWH"."D_DATE"."QUARTER" FROM "BIS_DWH"."D_DATE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:03 AM    29571            Dimension 'DATE' Execute : SELECT DISTINCT {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}, {fn QUARTER("BIS_DWH"."D_DATE"."D_DATE")}, {fn MONTH("BIS_DWH"."D_DATE"."D_DATE")}, TO_CHAR("BIS_DWH"."D_DATE"."D_DATE", 'YYYY-MM-DD'), "BIS_DWH"."D_DATE"."WORKING_DAY", "BIS_DWH"."D_DATE"."D_DATE", "BIS_DWH"."D_DATE"."YEAR", "BIS_DWH"."D_DATE"."QUARTER", "BIS_DWH"."D_DATE"."MONTH" FROM "BIS_DWH"."D_DATE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:03 AM    29571        Completed Processing Dimension 'DATE'. End time: 11:49:03 AM  Duration: 0:00:02  Rows processed: 4000
> Error = 1 (00000001), Description = 7/19/2004 11:49:03 AM    29571        Processing Dimension 'Payment Mode' Start time: 11:49:03 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Process information for Dimension 'Payment Mode': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Initializing Dimension 'Payment Mode'
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Dimension 'Payment Mode' Execute : SELECT DISTINCT "BIS_DWH"."D_PAYMENT_MODE"."PAYMENT_MODE_NAME" FROM "BIS_DWH"."D_PAYMENT_MODE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571        Completed Processing Dimension 'Payment Mode'. End time: 11:49:04 AM  Duration: 0:00:01  Rows processed: 14
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571        Processing Dimension 'Division' Start time: 11:49:04 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Process information for Dimension 'Division': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Initializing Dimension 'Division'
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Dimension 'Division' Execute : SELECT DISTINCT "BIS_DWH"."VIEW_ORG_UNIT"."ORG_UNIT_NAME", "BIS_DWH"."D_DIVISION"."DIVISION_NAME" FROM "BIS_DWH"."D_DIVISION", "BIS_DWH"."VIEW_ORG_UNIT" WHERE ("BIS_DWH"."D_DIVISION"."ORG_UNIT_ID"="BIS_DWH"."VIEW_ORG_UNIT"."ORG_UNIT_ID")
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571        Completed Processing Dimension 'Division'. End time: 11:49:04 AM  Duration: 0:00:00  Rows processed: 20
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571        Processing Dimension 'Weight Group' Start time: 11:49:04 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Process information for Dimension 'Weight Group': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:04 AM    29571            Initializing Dimension 'Weight Group'
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Dimension 'Weight Group' Execute : SELECT DISTINCT "BIS_DWH"."D_WEIGHT_GROUP"."WEIGHT_FROM", "BIS_DWH"."D_WEIGHT_GROUP"."DESCRIPTION" FROM "BIS_DWH"."D_WEIGHT_GROUP"
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571        Completed Processing Dimension 'Weight Group'. End time: 11:49:05 AM  Duration: 0:00:01  Rows processed: 83
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571        Processing Dimension 'Service' Start time: 11:49:05 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Process information for Dimension 'Service': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Initializing Dimension 'Service'
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Dimension 'Service' Execute : SELECT DISTINCT "BIS_DWH"."D_SERVICE"."SERVICE_NAME" FROM "BIS_DWH"."D_SERVICE"
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571        Completed Processing Dimension 'Service'. End time: 11:49:05 AM  Duration: 0:00:00  Rows processed: 21
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571        Processing Dimension 'Price Group' Start time: 11:49:05 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Process information for Dimension 'Price Group': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Initializing Dimension 'Price Group'
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Dimension 'Price Group' Execute : SELECT DISTINCT "BIS_DWH"."D_PRICE_GROUP"."PRICE_FROM", "BIS_DWH"."D_PRICE_GROUP"."DESCRIPTION" FROM "BIS_DWH"."D_PRICE_GROUP"
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571        Completed Processing Dimension 'Price Group'. End time: 11:49:05 AM  Duration: 0:00:00  Rows processed: 123
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571        Processing Dimension 'Sector' Start time: 11:49:05 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:05 AM    29571            Process information for Dimension 'Sector': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:06 AM    29571            Initializing Dimension 'Sector'
> Error = 1 (00000001), Description = 7/19/2004 11:49:06 AM    29571            Dimension 'Sector' Execute : SELECT DISTINCT "BIS_DWH"."D_SECTOR"."SECTOR_NAME" FROM "BIS_DWH"."D_SECTOR"
> Error = 1 (00000001), Description = 7/19/2004 11:49:06 AM    29571        Completed Processing Dimension 'Sector'. End time: 11:49:06 AM  Duration: 0:00:01  Rows processed: 6
> Error = 1 (00000001), Description = 7/19/2004 11:49:06 AM    29571        Processing Dimension 'Customer' Start time: 11:49:06 AM
> Error = 1 (00000001), Description = 7/19/2004 11:49:06 AM    29571            Process information for Dimension 'Customer': An incremental dimension update is performed
> Error = 1 (00000001), Description = 7/19/2004 11:49:06 AM    29571            Initializing Dimension 'Customer'
> Error = 1 (00000001), Description = 7/19/2004 11:49:07 AM    29571            Dimension 'Customer' Execute : SELECT DISTINCT "BIS_DWH"."VIEW_AREA"."AREA_NAME", "BIS_DWH"."VIEW_STATION"."STATION_NAME", "BIS_DWH"."D_CUSTOMER"."CUSTOMER_NAME" FROM "BIS_DWH"."VIEW_STATION", "BIS_DWH"."VIEW_AREA", "BIS_DWH"."D_CUSTOMER" WHERE ("BIS_DWH"."VIEW_STATION"."AREA_ID"="BIS_DWH"."VIEW_AREA"."AREA_ID") AND ("BIS_DWH"."D_CUSTOMER"."STATION_ID"="BIS_DWH"."VIEW_STATION"."STATION_ID")
> Error = 1 (00000001), Description = 7/19/2004 11:49:11 AM    29571        Completed Processing Dimension 'Customer'. End time: 11:49:11 AM  Duration: 0:00:05  Rows processed: 36545
> Error = 1 (00000001), Description = 7/19/2004 11:49:11 AM    29571        Committing transaction in Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    29571    Committed transaction in Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    **************************************************************************
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    Processing Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    Server: BIS
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    User: NT AUTHORITY\SYSTEM
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    Time Processing started: 7/19/2004 11:50:17 AM
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    Log ID: 14103
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    *    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    **************************************************************************
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103    Initiating transaction in Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 11:50:17 AM    14103        Processing Cube 'ACTUAL SALES' Start time: 11:50:17 AM
> Error = 1 (00000001), Description = 7/19/2004 11:50:18 AM    14103            Initializing Cube 'ACTUAL SALES'
> Error = 1 (00000001), Description = 7/19/2004 11:50:18 AM    14103            Processing Partition 'ACTUAL SALES' Start time: 11:50:18 AM
> Error = 1 (00000001), Description = 7/19/2004 11:50:18 AM    14103                Initializing Partition 'ACTUAL SALES'
> Error = 1 (00000001), Description = 7/19/2004 11:50:20 AM    14103                Partition 'ACTUAL SALES' Execute : SELECT "BIS_DWH"."D_AREA"."AREA_NAME", "BIS_DWH"."D_STATION"."STATION_NAME", "BIS_DWH"."D_PRODUCT"."PRODUCT_ID", {fn YEAR("BIS_DWH"."D_DATE"."D_DATE")}, {fn QUARTER("BIS_DWH"."D_DATE"."D_DATE")}, {fn MONTH("BIS_DWH"."D_DATE"."D_DATE")}, TO_CHAR("BIS_DWH"."D_DATE"."D_DATE", 'YYYY-MM-DD'), "BIS_DWH"."D_PAYMENT_MODE"."PAYMENT_MODE_NAME", "BIS_DWH"."VIEW_ORG_UNIT"."ORG_UNIT_NAME", "BIS_DWH"."D_DIVISION"."DIVISION_NAME", "BIS_DWH"."D_WEIGHT_GROUP"."WEIGHT_FROM", "BIS_DWH"."D_SERVICE"."SERVICE_NAME", "BIS_DWH"."D_PRICE_GROUP"."PRICE_FROM", "BIS_DWH"."D_SECTOR"."SECTOR_NAME", "BIS_DWH"."VIEW_AREA"."AREA_NAME", "BIS_DWH"."VIEW_STATION"."STATION_NAME", "BIS_DWH"."D_CUSTOMER"."CUSTOMER_NAME", "BIS_DWH"."V_F_SALES"."SALES_AMT", "BIS_DWH"."V_F_SALES"."NUMBER_OF_SHIPMENTS" FROM "BIS_DWH"."V_F_SALES", "BIS_DWH"."D_STATION", "BIS_DWH"."D_AREA", "BIS_DWH"."D_PRODUCT", "BIS_DWH"."D_DATE", "BIS_DWH"."D_PAYMENT_MODE", "BIS_DWH"."D_DIVISION", "BIS_DWH"."VIEW_ORG_UNIT", "BIS_DWH"."D_WEIGHT_GROUP", "BIS_DWH"."D_SERVICE", "BIS_DWH"."D_PRICE_GROUP", "BIS_DWH"."D_SECTOR", "BIS_DWH"."VIEW_STATION", "BIS_DWH"."VIEW_AREA", "BIS_DWH"."D_CUSTOMER" WHERE ("BIS_DWH"."D_STATION"."AREA_ID"="BIS_DWH"."D_AREA"."AREA_ID") AND ("BIS_DWH"."V_F_SALES"."STATION_ID"="BIS_DWH"."D_STATION"."STATION_ID") AND ("BIS_DWH"."V_F_SALES"."PRODUCT_ID"="BIS_DWH"."D_PRODUCT"."PRODUCT_ID") AND ("BIS_DWH"."V_F_SALES"."DATE_ID"="BIS_DWH"."D_DATE"."DATE_ID") AND ("BIS_DWH"."V_F_SALES"."PAYMENT_MODE_ID"="BIS_DWH"."D_PAYMENT_MODE"."PAYMENT_MODE_ID") AND ("BIS_DWH"."D_DIVISION"."ORG_UNIT_ID"="BIS_DWH"."VIEW_ORG_UNIT"."ORG_UNIT_ID") AND ("BIS_DWH"."V_F_SALES"."DIVISION_ID"="BIS_DWH"."D_DIVISION"."DIVISION_ID") AND ("BIS_DWH"."V_F_SALES"."WEIGHT_GROUP_ID"="BIS_DWH"."D_WEIGHT_GROUP"."WEIGHT_GROUP_ID") AND ("BIS_DWH"."V_F_SALES"."SERVICE_ID"="BIS_DWH"."D_SERVICE"."SERVICE_ID") AND ("BIS_DWH"."V_F_SALES"."PRICE_GROUP_ID"="BIS_DWH"."D_PRICE_GROUP"."PRICE_GROUP_ID") AND ("BIS_DWH"."V_F_SALES"."SECTOR_ID"="BIS_DWH"."D_SECTOR"."SECTOR_ID") AND ("BIS_DWH"."VIEW_STATION"."AREA_ID"="BIS_DWH"."VIEW_AREA"."AREA_ID") AND ("BIS_DWH"."D_CUSTOMER"."STATION_ID"="BIS_DWH"."VIEW_STATION"."STATION_ID") AND ("BIS_DWH"."D_CUSTOMER"."CUSTOMER_ID"="BIS_DWH"."V_F_SALES"."CUSTOMER_ID")
> Error = 1 (00000001), Description = 7/19/2004 11:56:05 AM    14103                Writing data of Partition 'ACTUAL SALES' (segment  1). Rows processed: 467000
> Error = 1 (00000001), Description = 7/19/2004 12:00:01 PM    14103                Writing data of Partition 'ACTUAL SALES' (segment  2). Rows processed: 463000
> Error = 1 (00000001), Description = 7/19/2004 12:04:42 PM    14103                Writing data of Partition 'ACTUAL SALES' (segment  3). Rows processed: 463000
> Error = 1 (00000001), Description = 7/19/2004 12:09:59 PM    14103                Writing data of Partition 'ACTUAL SALES' (segment  4). Rows processed: 458000
> Error = 1 (00000001), Description = 7/19/2004 12:15:30 PM    14103                Writing data of Partition 'ACTUAL SALES' (segment  5). Rows processed: 464000
> Error = 1 (00000001), Description = 7/19/2004 12:18:41 PM    14103                Writing data of Partition 'ACTUAL SALES' (segment  6). Rows processed: 238597
> Error = 1 (00000001), Description = 7/19/2004 12:18:43 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  1)
> Error = 1 (00000001), Description = 7/19/2004 12:18:43 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  2)
> Error = 1 (00000001), Description = 7/19/2004 12:18:43 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  3)
> Error = 1 (00000001), Description = 7/19/2004 12:18:43 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  4)
> Error = 1 (00000001), Description = 7/19/2004 12:18:44 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  5)
> Error = 1 (00000001), Description = 7/19/2004 12:18:44 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  6)
> Error = 1 (00000001), Description = 7/19/2004 12:18:44 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  7)
> Error = 1 (00000001), Description = 7/19/2004 12:18:44 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  8)
> Error = 1 (00000001), Description = 7/19/2004 12:18:45 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  9)
> Error = 1 (00000001), Description = 7/19/2004 12:18:45 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  10)
> Error = 1 (00000001), Description = 7/19/2004 12:18:45 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  11)
> Error = 1 (00000001), Description = 7/19/2004 12:18:45 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  12)
> Error = 1 (00000001), Description = 7/19/2004 12:18:45 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  13)
> Error = 1 (00000001), Description = 7/19/2004 12:18:46 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  14)
> Error = 1 (00000001), Description = 7/19/2004 12:18:46 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  15)
> Error = 1 (00000001), Description = 7/19/2004 12:18:46 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  16)
> Error = 1 (00000001), Description = 7/19/2004 12:18:46 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  17)
> Error = 1 (00000001), Description = 7/19/2004 12:18:46 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  18)
> Error = 1 (00000001), Description = 7/19/2004 12:18:47 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  19)
> Error = 1 (00000001), Description = 7/19/2004 12:18:47 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  20)
> Error = 1 (00000001), Description = 7/19/2004 12:18:47 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  21)
> Error = 1 (00000001), Description = 7/19/2004 12:18:47 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  22)
> Error = 1 (00000001), Description = 7/19/2004 12:18:48 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  23)
> Error = 1 (00000001), Description = 7/19/2004 12:18:48 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  24)
> Error = 1 (00000001), Description = 7/19/2004 12:18:48 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  25)
> Error = 1 (00000001), Description = 7/19/2004 12:18:48 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  26)
> Error = 1 (00000001), Description = 7/19/2004 12:18:48 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  27)
> Error = 1 (00000001), Description = 7/19/2004 12:18:49 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  28)
> Error = 1 (00000001), Description = 7/19/2004 12:18:49 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  29)
> Error = 1 (00000001), Description = 7/19/2004 12:18:49 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  30)
> Error = 1 (00000001), Description = 7/19/2004 12:18:49 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  31)
> Error = 1 (00000001), Description = 7/19/2004 12:18:49 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  32)
> Error = 1 (00000001), Description = 7/19/2004 12:18:50 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  33)
> Error = 1 (00000001), Description = 7/19/2004 12:18:50 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  34)
> Error = 1 (00000001), Description = 7/19/2004 12:18:50 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  35)
> Error = 1 (00000001), Description = 7/19/2004 12:18:50 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  36)
> Error = 1 (00000001), Description = 7/19/2004 12:18:51 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  37)
> Error = 1 (00000001), Description = 7/19/2004 12:18:51 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  38)
> Error = 1 (00000001), Description = 7/19/2004 12:18:51 PM    14103                Writing aggregations and indexes of Partition 'ACTUAL SALES' (segment  39)
> Error = 1 (00000001), Description = 7/19/2004 12:18:51 PM    14103            Completed Processing Partition 'ACTUAL SALES'. End time: 12:18:51 PM  Duration: 0:28:33  Rows processed: 2553597
> Error = 1 (00000001), Description = 7/19/2004 12:18:56 PM    14103            Processing Cube 'SALES' Start time: 12:18:56 PM
> Error = 1 (00000001), Description = 7/19/2004 12:18:58 PM    14103                Initializing Cube 'SALES'
> Error = 1 (00000001), Description = 7/19/2004 12:19:01 PM    14103            Completed Processing Cube 'SALES'. End time: 12:19:01 PM  Duration: 0:00:05
> Error = 1 (00000001), Description = 7/19/2004 12:19:01 PM    14103        Completed Processing Cube 'ACTUAL SALES'. End time: 12:19:01 PM  Duration: 0:28:44
> Error = 1 (00000001), Description = 7/19/2004 12:19:01 PM    14103        Committing transaction in Database 'BIS'
> Error = 1 (00000001), Description = 7/19/2004 12:19:08 PM    14103    Committed transaction in Database 'BIS'
> -- 
> Thanks
> Akber.
> 
> 
> "Dave Wickert [MSFT]" wrote:
> 
> > So . . . based on this.. from the system-wide processing logfile, what does
> > the SQL statement look like?
> > -- 
> > Dave Wickert [MSFT]
> > dwickert@online.microsoft.com
> > Program Manager
> > BI SystemsTeam
> > SQL BI Product Unit (Analysis Services)
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > 
> > "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
> > news:eApzojAcEHA.1048@tk2msftngp13.phx.gbl...
> > > There is no limit on the size of the fact table in Analysis Services. To
> > use
> > > a coined by Carl Sagan, I've seen partitions with BILLIONS and BILLIONS of
> > > fact rows in them.
> > >
> > > I would suggest that you look at some of the suggestions raised in the
> > > Analysis Services Operations Guide
> > >
> > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
> > > One of its recommendations (in the section titled "Processing Log File")
> > is
> > > to enable the system-wide processing log file option and retain long term
> > > history of the processing done on your system. In the log file are all of
> > > the processing requests, the SQL statement used and the final row counts
> > > resulting from processing.
> > > -- 
> > > Dave Wickert [MSFT]
> > > dwickert@online.microsoft.com
> > > Program Manager
> > > BI SystemsTeam
> > > SQL BI Product Unit (Analysis Services)
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Akber" <Akber@discussions.microsoft.com> wrote in message
> > > news:0BC3A29C-C530-45CF-98CA-B4899C12CF5F@microsoft.com...
> > > > My Warehouse Data is basically in Oracle and I am using SQL Server DTS
> > for
> > > ETL and SQL Server Analysis Services for viewing the cube.
> > > >
> > > > I dont think so that the cube joins are the problem because the same
> > cube
> > > was working fine previously. I think that there is some MOLAP memory issue
> > > in the Analysis Server.
> > > > Well I can try ur steps but how I can grab the T-SQL that Analysis
> > Server
> > > sends to SQL Server while processing the cube
> > > > -- 
> > > > Thanks
> > > > Akber.
> > > >
> > > >
> > > > "Akber" wrote:
> > > >
> > > > > I am using MOLAP storage for my cube.
> > > > > The problem which I am getting is that the cube stops showing the data
> > > for the month which it was showing correctly previously. I have populated
> > my
> > > fact table with the data from the previous year i.e: from JUN 2003 till
> > > todate and is being updated every year. Last week the cube was displaying
> > > the data correctly for all the months but now it is not displaying any
> > > figures for the 2003 although my fact table in the database has data
> > > corresponding to that period. I am using full process method to process
> > the
> > > cube.
> > > > > Whats the solution ?
> > > > > Is there any size limit on the MOLAP type cude data storage ? Might be
> > > that is the main problem but not sure. You gurus must be knowing best.
> > > > >
> > > > > -- 
> > > > > Thanks
> > > > > Akber.
> > >
> > >
> > 
> > 
> > 

---

• Next message: anonymous_at_devdex.com: "COUNT help with JOIN"
• Previous message: Indyyan: "Process Cube"
• In reply to: Akber: "Re: LIMIT OF FACT TABLE DATA"
• Messages sorted by: [ date ] [ thread ]

---

Relevant Pages Re: LIMIT OF FACT TABLE DATA ... There is no limit on the size of the fact table in Analysis Services. ... "Akber" wrote in message ... ETL and SQL Server Analysis Services for viewing the cube. ... (microsoft.public.sqlserver.datawarehouse) Re: LIMIT OF FACT TABLE DATA ... My log file for the cube processing gives the following information. ... > SQL BI Product Unit ... >> There is no limit on the size of the fact table in Analysis Services. ... (microsoft.public.sqlserver.datawarehouse) Re: Error processing cube : Login failed for user NT AUTHORITYANONYMOUS LOGON ... account which can access your data; or you need to switch to using standard ... SQL BI Product Unit (Analysis Services) ... Own cubeprocess exe program to process the cube. ... What is the service pack of SQL Server? ... (microsoft.public.sqlserver.olap) Re: LIMIT OF FACT TABLE DATA ... SQL BI Product Unit ... > There is no limit on the size of the fact table in Analysis Services. ... >> My Warehouse Data is basically in Oracle and I am using SQL Server DTS ... > ETL and SQL Server Analysis Services for viewing the cube. ... (microsoft.public.sqlserver.datawarehouse) Re: LIMIT OF FACT TABLE DATA ... > Answer to Fernando Questions. ... My cube fact and dimension tables are in Oracle Database. ... Enable the system-wide processing log file and check the results. ... >>> There is no limit on the size of the fact table in Analysis Services. ... (microsoft.public.sqlserver.datawarehouse)

---

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint

www.tech-archive.net  > Archive  > SQL-Server  > microsoft.public.sqlserver.datawarehouse  > 2004-07