Hi

I coded a small vb.net app which store a folder listing of all the files and
sub-dir in 2 tables : tblFiles and tblFolders
I made
tblFolders has a parent/child Structure using the SQL identity Seed as
Primary Key and store the folder name
tblFiles store the file name, file size, file date, file owner and ID of the
Folder

I have 3 sahred dimensions:
Date : based on the file date
Owner : based on the file owner
Folder : a Parent/Child dimension

I used the table tblFiles as the fact table and the file size as the
measure.

When I make the first process for each dimensions and the cube it works well
(I stored it in MOLAP) and a excel pivot works instantenously.

When I update the 2 tables, let's say, the following day to have up to date
data, I can't reprocess the Folder dimension, it stays stuck load the memory
and stop working.

I have 1.600.000.000 rows in tblFiles and 120.000 rows in the tblFolders, it
takes 5-6 minutes to make a full process when everythings is empty, but when
there was data before, the process (full or incremental) stops working.

when I say "stop working" I mean the memory is loaded with 1GB of data, and
the CPU is at 0% for 3 hours (I waited that long before killing the OLAP
server). When you compare with the 6 min of the full process, it's not
normal, isn't it?
I watched what happened in the data directory of my application :
it creates a serie of "Folder'S.*" files and they are a bit bigger than the
"Folder.*" files. and it stops here.
when I did the same with the others dimensions, the 'S files replaced the
normal files in a few seconds.

I did found a workaround :
stop OLAP Service
Delete the 2 files containing the data of the 'Folder' Dimension (the 2
big files, not the 2 small ones, I don't remember the extension)
restart OLAP
reprocess
It works fine.

Now, I didn't find a DSO command to do that!!
(I could do an upgrade to my app to kill the olap process, the files,
restart and process, but I'd rather find an "clean" solution)

if it helps, I think the extensions of the big files where ".prop" (50M) and
".tree" (230M)


So, can anyone help me with this problem ?

Christophe
remove nospam to mail me.