PS 2007 Cube failure

[Mike Mahoney]

I have documented similar issue in the past. This is the latest variant. In
PS2007 having multilevel codes fields makes the system unusable unless you
are a dedicated planner prepared to work with a randomly performing
application.

I am therefore in the proces of flattening my hierarchical codes, which
works fine until you try to build a cube which fails (see details below).
Clearly there are elements in the reporting database which have not been
refreshed by the code changes and this is fatal to the cube. My solution is
to republish every plan. I suspect I don't need to do every plan but error
reporting does not help me focus on plans contributing to the problem. With
the current number of plans this is doable (and fixes the cube build
problem). Therefore the request i(aside from a more robust s/w( is for a
more focussed error message to resolve the issue more quickly.

Mike


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

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17004" name="CBSOlapProcessingFailure"
uid="8d2ba150-948a-4530-ac02-376289ed21e2" QueueMessageBody="Setting

UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=ccm-prdprj01
ASDBName=ProjectServer ASExtraNetAddress=ccm-prdprj01 RangeChoice=0

PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=04/26/2007 17:23:59
ToDate=04/26/2007 17:23:59 HighPriority=True" Error="Analysis Services

session failed with the following error: Failed to process the Analysis
Services database ProjectServer on the ccm-prdprj01 server. Error: "

/>
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="36b99e77-bc69-4074-8abc-94f29f93d2ff"
JobUID="0ae43e60-f121-40a0-8a59-4b561bc796d1"

ComputerName="CCM-PRDPRJ01" GroupType="CBSRequest"
MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...04fed16060&dg=microsoft.public.project.server

 

[Sharry Heberer [MSFT]]

Mike - multileveled codes (now called Lookup Tables in PS 2007) should work
fine as far as the Reporting Database goes, and you should be getting all
edits to those fields. If you are having issues with the Reporting Database
with Lookup Table edits failing in the Queue, I would love to help if you
would like to pursue it. Just let me know what problems in the RDB and/or
Queue you are seeing and I can try and provide some assistance.

As for which plans need republishing, a quick query of the Publish DB should
tell you which projects are using a particular Custom Field (as long as you
know which Custom Fields are using the impacted Lookup Table).

Thanks,
Sharry