dbTalk Databases Forums  

Open File Error - 64 Bit Analysis Services

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Open File Error - 64 Bit Analysis Services in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Josh Lawrence
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.