I have a VB application that creates several hundred local cubes. It has
been working fine until SP1 for Windows Server 2003 was installed. Now, it
runs fine until it reaches a specific group of local cubes, at which it
randomly fails with a Dr Watson. One pass it processed only 18 local cubes,
and the very next it processed all 245. The app uses an ADO connection to
execute the Create Cube statement, and each time it has failed, it has been
on the Open method. Has anyone else experienced this?

Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 7/26/2005
Time: 5:29:03 PM
User: N/A
Computer: HATHOR
Description:
The application, C:\Program Files\MakeCube\MakeCube.exe, generated an
application error The error occurred on 07/26/2005 @ 17:29:03.530 The
exception generated was c0000005 at address 02AA6919
(msmdgd80!DllUnregisterServer)

07/26/2005 17:03:40 - Starting up MakeCube (PID 5352)
07/26/2005 17:03:40 - Windows Server 2003 (build 3790)
07/26/2005 17:03:40 - CPU 0: x86 Family 15 Model 5 Stepping 10 AuthenticAMD
~2396 MHz
07/26/2005 17:03:40 - CPU 1: x86 Family 15 Model 5 Stepping 10 AuthenticAMD
~2396 MHz
07/26/2005 17:03:40 - CPU 2: x86 Family 15 Model 5 Stepping 10 AuthenticAMD
~2396 MHz
07/26/2005 17:03:40 - CPU 3: x86 Family 15 Model 5 Stepping 10 AuthenticAMD
~2396 MHz
07/26/2005 17:03:40 - Total Physical Memory: 2,097,151KB
07/26/2005 17:03:40 - Total Available Physical Memory: 2,097,151KB
07/26/2005 17:03:40 - Total Virtual Memory: 2,097,024KB
07/26/2005 17:03:40 - Total Available Virtual Memory: 2,073,524KB
07/26/2005 17:03:40 - Drive C: (NTFS) 12,416,248KB Free / 17,409,340 KB
Total
07/26/2005 17:03:40 - Drive D: (NTFS) 16,078,468KB Free / 18,147,820 KB
Total
07/26/2005 17:03:40 - Drive E: (NTFS) 583,035,980KB Free / 583,679,996 KB
Total
07/26/2005 17:03:40 - Drive F: (NTFS) 588,089,288KB Free / 588,173,308 KB
Total
07/26/2005 17:03:40 - Checking File Versions...
07/26/2005 17:03:40 - ADO: msado15.dll - 2.82.1830.0
07/26/2005 17:03:40 - ADOMD: msadomd.dll - 2.82.1830.0
07/26/2005 17:03:40 - PTS: msolap80.dll - 8.0.2039.0

07/26/2005 17:03:41 - LOCATION=d:\cubes\retailsalescustsku\77771sales.cu b;
SOURCE_DSN="Provider=MSOLAP;Data Source=DNB;Initial Catalog=DWRS";
CREATECUBE=CREATE CUBE [77771sales]
(
DIMENSION [Date],
LEVEL [All Dates] TYPE ALL,
LEVEL [Year Desc] OPTIONS(SORTBYKEY),
LEVEL [Quarter Desc] OPTIONS(SORTBYKEY),
LEVEL [Month Desc] OPTIONS(SORTBYKEY),
LEVEL [Day Desc] OPTIONS(SORTBYKEY),
DIMENSION [Product],
LEVEL [All Products] TYPE ALL,
LEVEL [Comm Desc] OPTIONS(SORTBYNAME),
LEVEL [Pgrp Desc] OPTIONS(SORTBYNAME),
LEVEL [Mgrp Desc] OPTIONS(SORTBYNAME),
LEVEL [Sku Desc] OPTIONS(SORTBYNAME),
DIMENSION [Customer],
LEVEL [All Customers] TYPE ALL,
LEVEL [Store Num] OPTIONS(SORTBYNAME),
LEVEL [Cust] OPTIONS(SORTBYNAME),
DIMENSION [Sales_Type],
LEVEL [All Types] TYPE ALL,
LEVEL [Type Desc] OPTIONS(SORTBYNAME),
DIMENSION [Status],
LEVEL [All Status] TYPE ALL,
LEVEL [Status] OPTIONS(SORTBYNAME),
DIMENSION [Week],
LEVEL [All Weeks] TYPE ALL,
LEVEL [Year Desc] OPTIONS(SORTBYKEY),
LEVEL [Quarter Desc] OPTIONS(SORTBYKEY),
LEVEL [Period Desc] OPTIONS(SORTBYKEY),
LEVEL [Week Desc] OPTIONS(SORTBYKEY),
LEVEL [Day Desc] OPTIONS(SORTBYKEY),
DIMENSION [Weekday],
LEVEL [All Weekdays] TYPE ALL,
LEVEL [Weekday Desc] OPTIONS(SORTBYKEY),
MEASURE [u] Function SUM FORMAT 'Standard' TYPE DBTYPE_R8 HIDDEN,
MEASURE [S] Function SUM FORMAT 'Currency' TYPE DBTYPE_CY HIDDEN,
MEASURE [C] Function SUM FORMAT 'Currency' TYPE DBTYPE_CY HIDDEN,
COMMAND (CREATE MEMBER [77771sales].Measures.[Sales] AS '[Measures].[S]',
FORMAT_STRING = 'Currency'),
COMMAND (CREATE MEMBER [77771sales].Measures.[Units] AS '[Measures].[u]',
FORMAT_STRING = '#,#')
);
INSERTINTO=INSERT INTO [77771sales]
(
[Date].[Year Desc].NAME, [Date].[Year Desc].KEY,
[Date].[Quarter Desc].NAME, [Date].[Quarter Desc].KEY,
[Date].[Month Desc].NAME, [Date].[Month Desc].KEY,
[Date].[Day Desc].NAME, [Date].[Day Desc].KEY,
[Product].[Comm Desc].NAME, [Product].[Comm Desc].KEY,
[Product].[Pgrp Desc].NAME, [Product].[Pgrp Desc].KEY,
[Product].[Mgrp Desc].NAME, [Product].[Mgrp Desc].KEY,
[Product].[Sku Desc].NAME, [Product].[Sku Desc].KEY,
[Customer].[Store Num].NAME, [Customer].[Store Num].KEY,
[Customer].[Cust].NAME, [Customer].[Cust].KEY,
[Sales_Type].[Type Desc].NAME, [Sales_Type].[Type Desc].KEY,
[Status].[Status].NAME, [Status].[Status].KEY,
[Week].[Year Desc].NAME, [Week].[Year Desc].KEY,
[Week].[Quarter Desc].NAME, [Week].[Quarter Desc].KEY,
[Week].[Period Desc].NAME, [Week].[Period Desc].KEY,
[Week].[Week Desc].NAME, [Week].[Week Desc].KEY,
[Week].[Day Desc].NAME, [Week].[Day Desc].KEY,
[Weekday].[Weekday Desc].NAME, [Weekday].[Weekday Desc].KEY,
[Measures].[u],
[Measures].[S],
[Measures].[C]
)
SELECT
[Retail Sales Cust_SKU].[Date:Year Desc], [Retail Sales
Cust_SKU].[Date:Year Desc!KEY],
[Retail Sales Cust_SKU].[Date:Quarter Desc], [Retail Sales
Cust_SKU].[Date:Quarter Desc!KEY],
[Retail Sales Cust_SKU].[Date:Month Desc], [Retail Sales
Cust_SKU].[Date:Month Desc!KEY],
[Retail Sales Cust_SKU].[Dateay Desc], [Retail Sales
Cust_SKU].[Dateay Desc!KEY],
[Retail Sales Cust_SKU].[Product:Comm Desc], [Retail Sales
Cust_SKU].[Product:Comm Desc!KEY],
[Retail Sales Cust_SKU].[Product:Pgrp Desc], [Retail Sales
Cust_SKU].[Product:Pgrp Desc!KEY],
[Retail Sales Cust_SKU].[Product:Mgrp Desc], [Retail Sales
Cust_SKU].[Product:Mgrp Desc!KEY],
[Retail Sales Cust_SKU].[Product:Sku Desc], [Retail Sales
Cust_SKU].[Product:Sku Desc!KEY],
[Retail Sales Cust_SKU].[Customer:Store Num], [Retail Sales
Cust_SKU].[Customer:Store Num!KEY],
[Retail Sales Cust_SKU].[Customer:Cust], [Retail Sales
Cust_SKU].[Customer:Cust!KEY],
[Retail Sales Cust_SKU].[Sales_Type:Type Desc], [Retail Sales
Cust_SKU].[Sales_Type:Type Desc!KEY],
[Retail Sales Cust_SKU].[Status:Status], [Retail Sales
Cust_SKU].[Status:Status!KEY],
[Retail Sales Cust_SKU].[Week:Year Desc], [Retail Sales
Cust_SKU].[Week:Year Desc!KEY],
[Retail Sales Cust_SKU].[Week:Quarter Desc], [Retail Sales
Cust_SKU].[Week:Quarter Desc!KEY],
[Retail Sales Cust_SKU].[Week:Period Desc], [Retail Sales
Cust_SKU].[Week:Period Desc!KEY],
[Retail Sales Cust_SKU].[Week:Week Desc], [Retail Sales
Cust_SKU].[Week:Week Desc!KEY],
[Retail Sales Cust_SKU].[Weekay Desc], [Retail Sales
Cust_SKU].[Weekay Desc!KEY],
[Retail Sales Cust_SKU].[Weekday:Weekday Desc], [Retail Sales
Cust_SKU].[Weekday:Weekday Desc!KEY],
[Retail Sales Cust_SKU].[Measures:Units],
[Retail Sales Cust_SKU].[Measures:Sales],
[Retail Sales Cust_SKU].[Measures:Cost]
FROM [Retail Sales Cust_SKU]
WHERE ([Retail Sales Cust_SKU].[Date:Year Desc] = '[Date].[All
Dates].[Fiscal Year 2005]'
OR [Retail Sales Cust_SKU].[Date:Year Desc] = '[Date].[All Dates].[Fiscal
Year 2006]')
AND [Retail Sales Cust_SKU].[Store:Level 08] = '[Store].[All Stores].[A -
Southern States Cooperative, Inc.].[B - Retail Services].[A - Ag Retail
Services - Miller].[A - Open Ag Services].[A Region 1 & 2 Servs -
Ebert].[Dist 01A Ag Servs - Kemp].[77771 Middletown DE Service]'