Open File Error - 64 Bit Analysis Services -
06-01-2004
, 10:32 PM
Hi All,
We are currently experiencing a rather frustrating error with the 64 bit
Analysis Services software when running processes in parallel. Just in
case anyone is wondering the version of the Analysis Services executable is
8.0.760.0 .
We have 3 cubes with each cube containing 48 partitions.
Whenever we attempt to process all three cubes in their entirety, running
around 3-4 partitions concurrently we are experiencing a locking error of
sorts. Below is the extract from the log file.
1/06/04 18:41:54 3359 Initiating transaction in Database
'RAPTORE_200308_TST'
1/06/04 18:41:54 3359 Processing Partition 'flex_post_key_124_h24' Start
time: 18:41:54
1/06/04 18:41:54 5250 Processing Partition 'flex_post_key_122_h22' Start
time: 18:41:54
1/06/04 18:42:00 3359 Initializing Partition 'flex_post_key_124_h24'
1/06/04 18:42:04 5250 Initializing Partition 'flex_post_key_122_h22'
1/06/04 18:42:07 19800 Partition 'flex_post_key_123_h23' Execute :
(SQL Removed)
1/06/04 18:42:07 3359 Partition 'flex_post_key_124_h24' Execute :
(SQL Removed)
1/06/04 18:42:07 3359 Analysis Server Error: File error [during the
Open operation] 'E:\Program Files\Microsoft Analysis
Services\Data\RAPTORE_200308_TST\Physical_Key^Cate gory.dim The process
cannot access the file because it is being used by another process. ' ;
Time:1/06/04 18:42:07
1/06/04 18:42:07 19800 Completed Processing Partition
'flex_post_key_123_h23'. End time: 18:42:07 Duration: 0:00:23 Rows
processed: 0
1/06/04 18:42:08 5250 Partition 'flex_post_key_122_h22' Execute :
(SQL Removed)
1/06/04 18:42:08 3359 Analysis Server Error: File error [during the
Open operation] 'E:\Program Files\Microsoft Analysis
Services\Data\RAPTORE_200308_TST\Physical_Key^Cate gory.dim The process
cannot access the file because it is being used by another process. ' ;
Time:1/06/04 18:42:08
1/06/04 18:42:08 19800 Committing transaction in Database
'RAPTORE_200308_TST'
1/06/04 18:42:08 5250 Completed Processing Partition
'flex_post_key_122_h22'. End time: 18:42:08 Duration: 0:00:14 Rows
processed: 0
1/06/04 18:42:09 3359 Processing Partition 'flex_post_key_124_h24'
failed. No changes have been made to the database.
1/06/04 18:42:11 19800 Committed transaction in Database
'RAPTORE_200308_TST'
1/06/04 18:42:11 5250 Committing transaction in Database
'RAPTORE_200308_TST'
1/06/04 18:42:14 5250 Committed transaction in Database 'RAPTORE_200308_TST'
1/06/04 18:42:14 3359 Rolling back transaction in Database
'RAPTORE_200308_TST'
Below is another extract of a error that was generated previously.
1/06/04 15:19:16 7232 Initiating transaction in Database
'RAPTORE_200308_TST'
1/06/04 15:19:18 7232 Processing Partition 'flex_post_key_ss_124_h24'
Start time: 15:19:18
1/06/04 15:19:21 28423 Initializing Partition
'flex_post_key_ss_123_h23'
1/06/04 15:19:25 7232 Initializing Partition
'flex_post_key_ss_124_h24'
1/06/04 15:19:44 28423 Partition 'flex_post_key_ss_123_h23' Execute
: (SQL Removed)
1/06/04 15:19:45 7232 Partition 'flex_post_key_ss_124_h24' Execute :
(SQL Removed)
1/06/04 15:19:45 28423 Analysis Server Error: File error [during the
Open operation] 'E:\Program Files\Microsoft Analysis
Services\Data\RAPTORE_200308_TST\Physical_Key_SS^C ategory.dimtree The
process cannot access the file because it is being used by another process.
' ; Time:1/06/04 15:19:45
1/06/04 15:19:46 7232 Completed Processing Partition
'flex_post_key_ss_124_h24'. End time: 15:19:45 Duration: 0:00:27 Rows
processed: 0
1/06/04 15:19:49 28423 Analysis Server Error: File error [during the
Open operation] 'E:\Program Files\Microsoft Analysis
Services\Data\RAPTORE_200308_TST\Physical_Key_SS^C ategory.dimtree The
process cannot access the file because it is being used by another process.
' ; Time:1/06/04 15:19:46
1/06/04 15:19:50 7232 Committing transaction in Database
'RAPTORE_200308_TST'
1/06/04 15:19:51 28423 Processing Partition 'flex_post_key_ss_123_h23'
failed. No changes have been made to the database.
1/06/04 15:19:56 7232 Committed transaction in Database 'RAPTORE_200308_TST'
1/06/04 15:19:56 28423 Rolling back transaction in Database
'RAPTORE_200308_TST'
Any help would be greatly appreciated. The machine has plenty of disk
spaces and memory resources are more than adequate at the time of the error.
Thanks in advance!!
Josh |