OLAP Cube build failure – What is the meaning of the queue job err

S

Sylvia de Hart

OLAP Cube build failure – What is the meaning of the queue job error details?
On my demo virtual server (Project Server 2007), after having successfully
built the OLAP cubes, it suddenly has become impossible to view or edit the
Data Analysis Views or create a new one.
When trying to rebuild the cubes, this process fails.

I have pasted the Queue Job Error Details below. What action should be taken
on this error-message?

Error summary/areas:
CBS message processor failed
CBSASConnectionFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="52c7ad5b-6d71-4022-bea3-9e41a623dc5d" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=epm2007demo
ASDBName=SBB_ProjectServer_Analysis2 ASExtraNetAddress= RangeChoice=0
PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=06/16/2009 13:40:26
ToDate=06/16/2009 13:40:26 HighPriority=False" Error="De Analysis
Services-sessie is mislukt met de volgende fout: Kan geen verbinding maken
met de Analysis Services-server epm2007demo. Fout: File system error: The
following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft
SQL Server\MSSQL.2\OLAP\Data\SBB_ProjectServer_Analysis.0.db\Resource Base
Calendar.0.dim\1.Resource Base Calendar.(All).sstore. Logical file .
Errors
in the metadata manager. An error occurred when loading the Resource Base
Calendar dimension, from the file, '\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\SBB_ProjectServer_Analysis.0.db\Resource Base
Calendar.1.dim.xml'.
Errors in the metadata manager. An error occurred when
loading the Assignment Non Timephased cube, from the file, '\\?\C:\Program
Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\SBB_ProjectServer_Analysis.0.db\Assignment Non
Timephased.1.cub.xml'.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="c2debd77-80b4-41d8-9c62-41a9e872b426"
JobUID="f0fdb33a-a3ec-4913-9fad-07ceeb852d62" ComputerName="EPM2007DEMO"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>
 
S

Sylvia de Hart

One of my colleagues has advised me to delete the OLAP database entirely and
empty the OLAP object table within the repository database.
Upon trying to delete the OLAP database, however, exactly the same error
message is returned and I cannot delete the OLAP database

Does anybody have any ideas?

Error message when trying to delete the OLAP database:
Cannot show requested dialog.
Additional information
File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\SBB_ProjectServer_Analysis.0.db\Resource Base
Calendar.0.dim\1.Resource Base Calendar.(All).sstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Resource
Base Calendar dimension, from the file, '\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\SBB_ProjectServer_Analysis.0.db\Resource Base
Calendar.1.dim.xml'.
Errors in the metadata manager. An error occurred when loading the
Assignment Non Timephased cube, from the file, '\\?\C:\Program
Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\SBB_ProjectServer_Analysis.0.db\Assignment Non
Timephased.1.cub.xml'.
 
W

Wharton Computer Consulting

Hello Sylvia,

It's really hard to determine from the information that project is
providing. I would suggest either openning the OLAP cube from SQL Server
Analysis Server and reviewing the cube, possible looking for corrected
measures or dimensions or better yet, I would import the OLAP cube into MS
Visual Studio 2008 and review all the objects within the cube.

MS Visual Studio is my tool of choice of determine what the problem is and
then it's a little easier to fix.

My initial guess is that the resource calendar is corrupt or has something
wrong in thhere, a possible a custom field is having an effect.
 
M

Muthukkumaran

I'm also getting the same error!

Any idea?

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server EPMS.
Error: File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date
attribute.dstore. Logical file . Errors in the metadata manager. An error
occurred when loading the Deliverable Created Date dimension, from the file,
'\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.1.dim.xml'. Errors in the metadata manager. An error occurred when
loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft
SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.

Thanks in advance.
 
S

Sylvia de Hart

Hello Wharton Computer Consulting,

As I have not (as yet) sufficient knowledge of the OLAP cube in order to be
able to review it and detect any aberrations, I have requested a colleague of
mine to execute your suggestion.
My colleague found that neither reviewing the OLAP cube in Analysis Server
nor in Visual Studio provides any information as to what exactly would be
wrong with the file being identified as corrupted in the error message.
Entirely deleting said file only leads to another error message during Cube
Building, saying that that particular file cannot be opened.

Nevertheless, of course thank you for your input.
 
R

remindkumar

I am also having same error. Any help!


The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000
Detailed error below - send it to the administrator for more detailed troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure" uid="d99eb82f-aa7f-406d-b26b-3a3c1c9a37bb" QueueMessageBody="Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=EPMS ASDBName=EPMS_Analysis_New ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=10/09/2009 14:37:22 ToDate=10/09/2009 14:37:22 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server EPMS. Error: File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date attribute.dstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Deliverable Created Date dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.1.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="58a5f5a1-18f2-4e26-87eb-4272ea1c63cf" JobUID="61b29462-9fb2-44bf-bb87-16177f158bf2" ComputerName="EPMS" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>


Thanks in advance.

Muthu



Muthukkumara wrote:

=?Utf-8?Q?RE:_OLAP_Cube_build_failure_=E2=80=93_Wh?= =?Utf-8?Q?at_is_the_meaning_of_the_queue_j?= =?Utf-8?Q?ob_err?=
26-Jun-09

I'm also getting the same error!

Any idea?

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server EPMS.
Error: File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date
attribute.dstore. Logical file . Errors in the metadata manager. An error
occurred when loading the Deliverable Created Date dimension, from the file,
'\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.1.dim.xml'. Errors in the metadata manager. An error occurred when
loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft
SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.

Thanks in advance.


:

EggHeadCafe - Software Developer Portal of Choice
Vista Glass Effect NotifyIcon CPU / Memory Meter
http://www.eggheadcafe.com/tutorial...c-e250825c8c39/vista-glass-effect-notify.aspx
 
M

Muthukkumaran Ramalingam

I am also having same error. Any help!


The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000
Detailed error below - send it to the administrator for more detailed troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure" uid="d99eb82f-aa7f-406d-b26b-3a3c1c9a37bb" QueueMessageBody="Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=EPMS ASDBName=EPMS_Analysis_New ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=10/09/2009 14:37:22 ToDate=10/09/2009 14:37:22 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server EPMS. Error: File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date attribute.dstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Deliverable Created Date dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.1.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="58a5f5a1-18f2-4e26-87eb-4272ea1c63cf" JobUID="61b29462-9fb2-44bf-bb87-16177f158bf2" ComputerName="EPMS" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>


Thanks in advance.

Muthu



Muthukkumara wrote:

=?Utf-8?Q?RE:_OLAP_Cube_build_failure_=E2=80=93_Wh?= =?Utf-8?Q?at_is_the_meaning_of_the_queue_j?= =?Utf-8?Q?ob_err?=
26-Jun-09

I'm also getting the same error

Any idea

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server EPMS.
Error: File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date
attribute.dstore. Logical file . Errors in the metadata manager. An error
occurred when loading the Deliverable Created Date dimension, from the file,
'\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.1.dim.xml'. Errors in the metadata manager. An error occurred when
loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft
SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.

Thanks in advance

:

EggHeadCafe - Software Developer Portal of Choice
Transparent NTLM Authentication With ADSI and ASP
http://www.eggheadcafe.com/tutorial...a-dd1b21b626c3/transparent-ntlm-authenti.aspx
 
M

Muthukkumaran Ramalingam

I am also getting the same error.

Any Help!

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure" uid="d99eb82f-aa7f-406d-b26b-3a3c1c9a37bb" QueueMessageBody="Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=EPMS ASDBName=EPMS_Analysis_New ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=10/09/2009 14:37:22 ToDate=10/09/2009 14:37:22 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server EPMS. Error: File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date attribute.dstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Deliverable Created Date dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.1.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="58a5f5a1-18f2-4e26-87eb-4272ea1c63cf" JobUID="61b29462-9fb2-44bf-bb87-16177f158bf2" ComputerName="EPMS" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>


Thanks in Advance.



Muthukkumara wrote:

=?Utf-8?Q?RE:_OLAP_Cube_build_failure_=E2=80=93_Wh?= =?Utf-8?Q?at_is_the_meaning_of_the_queue_j?= =?Utf-8?Q?ob_err?=
26-Jun-09

I'm also getting the same error

Any idea

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server EPMS.
Error: File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date
attribute.dstore. Logical file . Errors in the metadata manager. An error
occurred when loading the Deliverable Created Date dimension, from the file,
'\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.1.dim.xml'. Errors in the metadata manager. An error occurred when
loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft
SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'.

Thanks in advance

:

EggHeadCafe - Software Developer Portal of Choice
Getting Started With ASP.NET
http://www.eggheadcafe.com/tutorial...e5-09bb108f1317/getting-started-with-asp.aspx
 
A

Andre Venter

What version of SQL are you using ? What version of project Server
--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member


Muthukkumaran Ramalingam said:
I am also getting the same error.

Any Help!

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure" uid="d99eb82f-aa7f-406d-b26b-3a3c1c9a37bb" QueueMessageBody="Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=EPMS ASDBName=EPMS_Analysis_New ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=10/09/2009 14:37:22 ToDate=10/09/2009 14:37:22 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server EPMS. Error: File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created Date.0.dim\1.Deliverable Created Date attribute.Deliverable Created Date attribute.dstore. Logical file
Click to expand...
Errors in the metadata manager. An error occurred when loading the Deliverable Created Date dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverable Created
Date.1.dim.xml'
Errors in the metadata manager. An error occurred when loading the Deliverables cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\Deliverables.1.cub.xml'
" />
 
G

Greg W

I also had this problem, and googling around found the following solution
that worked for me:

Something could be corrupted in the AS files at:
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\EPMS_Analysis.0.db\

You can try the following:

1)Stop the AS service;

2)Take a backup of the contents of the above folder;

3)Delete all files and folders that are contained in the folder that I
mentioned above. Ensure nothing is in that folder before you move to the next
step;

4)Restart the AS service;

This worked for me. Advice copied from:
http://social.technet.microsoft.com.../thread/1517ca05-e285-41cf-a706-9f86fdbc36c4/

Good luck,
Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLAP Cube Build Issue 3
PS2007. Cube Build Failure. Failed to connect to the Analysis Serv 2
Failed to build OLAP Cubes. 2
OLAP queue job error: 'Your queue job CBSRequest failed' 2
Cube failed to build due to 'Assignment Timephased' 1
Olap Cube Build Error...can't seem to get the cube to build 5
Cube Build Failure 7
Failed to process the Analysis Services database XX_Cube on the se 3

Top