PS2007 Reporting problem: job failed: could not find stored proc

P

PedroJose

Hello,

I am having a problem with publising projects into the reporting database.
This started after we installed SP1 on our single server env. The error
message is:

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="843a80c5-61b5-4457-8fee-054a20bb834e" QueueMessageBody="Project
UID='6ab821dd-c973-4370-aa53-8dced828ccf0'. PublishType='ProjectPublish'"
Error="Could not find stored procedure
'MSP_Epm_DeleteUnassignedAssignmentsTimephasedData'." />


If it helps, the Manage Queue page under server settings is not accessible,
it just does not open and an "unknown error" is provided. Also the
Administrative restore page is not accessible with a different error. All
this started after ionstalling SP1.

Please help.

Thanks.
 
S

Srini

Hi PedroJose,

I have seen your previous posts regarding the problems with publishing the
projects. I am having similar issue of FOREIGN KEY CONSTRAINT violation. Can
you please help me how to resolve this kind of issues.
Error message is given below.

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="5965c3c4-dcd0-4908-b03f-0e8fce96504d" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Violation of PRIMARY KEY constraint 'PK__#TBL_CFDeleteEnt__48840E2D'.
Cannot insert duplicate key in object 'dbo.#TBL_CFDeleteEntityUidArray'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="dd4edbaf-ac60-4d0c-a2d9-9b1ffa965f69" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="109c5663-ab5f-42a1-ac7f-f720f92be455" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="a1d2ed65-e056-4ed6-84cf-15db1f5499dc" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f73c2b42-c5bd-4999-bb41-6940519992a3" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="c83bff8b-411c-484e-a80f-d90732bc764c" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="c6739675-be32-4e63-92e0-abfa7a40ad17"
JobUID="2648674f-0c2d-403d-a41c-813f96d9b029" ComputerName="INVG2158"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
 
Top