Hi Gary,
The Cube was built successfully, but I got the following message in my
'Queue':
Error summary/areas:
Reporting message processor failed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
Queue
GeneralQueueJobFailed
Error details:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting message processor failed">
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f099dbea-7c27-4bb2-9c36-6a08953ae0d8" QueueMessageBody="Project
UID='f1b4b6b3-7a70-4e4c-b7bb-3dfa5598a56b'. PublishType='All'"
Error="The
INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="78757170-8fb3-45b1-acdd-1e2455390953" QueueMessageBody="Project
UID='f1b4b6b3-7a70-4e4c-b7bb-3dfa5598a56b'. PublishType='All'"
Error="The
INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="5f08365a-81c6-4a50-8195-eab09a4d9959" QueueMessageBody="Project
UID='f1b4b6b3-7a70-4e4c-b7bb-3dfa5598a56b'. PublishType='All'"
Error="The
INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="b62492a2-4a32-42fb-b341-e8653d3a2600" QueueMessageBody="Project
UID='f1b4b6b3-7a70-4e4c-b7bb-3dfa5598a56b'. PublishType='All'"
Error="The
INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e739d962-cbce-4aad-ac79-9a3fe67a68cc" QueueMessageBody="Project
UID='f1b4b6b3-7a70-4e4c-b7bb-3dfa5598a56b'. PublishType='All'"
Error="The
INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="bcc82e8d-2ee6-450e-b86b-df227dc1346a" QueueMessageBody="Project
UID='f1b4b6b3-7a70-4e4c-b7bb-3dfa5598a56b'. PublishType='All'"
Error="The
INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="a595f442-2341-4ae1-a061-fa71ee8e38c4"
JobUID="23263d7f-f2fd-4da8-9b17-d6210d3a41c8" ComputerName="PROJECTS"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
:
Thank you so much Gary!! After completing the steps you gave me, I got
the
following message:
===== Process Completed =====
[5/19/2009 10:50 AM] Cube build request completed successfully.
:
Anum:
Let's try rebuilding your reporting database and see if that helps.
To
force
a rebuild, backup your custom fields, and then restore them using
the
Administrative Backup feature. Wait for the reporting database
refresh
to
complete and then try building the cube again.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting:
http://www.msprojectexperts.com
Project Server Training:
http://www.projectservertraining.com
Project Server FAQS:
http://www.projectserverexperts.com
Project Server Help Blog:
http://www.projectserverhelp.com
OLAP Cube is giving the error when building:
Failed to create the internal OLAP database structure. Error:
Invalid
call
to GetJoinForCustomFieldDimension. Cannot join "Task Non
Timephased"
fact
with a custom field of entity Assignment
What could be causing this? How can I resolve this? Thanks!
