MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Project Fails in the "Reporting(Project Publish) Step

  • Follow


We are running MS Project Server 2007 SP2 with AUG09 MS CU.

One of our projects is always failing on the "Reporting(Project
Publish) step with the following error.  I am not an SQL expert, and
the person who does our SRS reports is not able to figure it out.

Does anyone have any idea what is happening?


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="b74b102f-37ca-4848-8c99-49b6a0c94f38" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
terminated." />
      <error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f33f9dad-29f0-46a0-81a3-5ee3f0745e5f" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
terminated." />
      <error id="24006" name="ReportingProjectChangeMessageFailed"
uid="d8bf9a30-25e2-432d-b87a-3454ac5911dd" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
terminated." />
      <error id="24006" name="ReportingProjectChangeMessageFailed"
uid="fc353334-7ea7-446c-b906-438e9d3e0d64" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
terminated." />
      <error id="24006" name="ReportingProjectChangeMessageFailed"
uid="bf52b3a8-ee78-4937-8223-c54c487f966c" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
terminated." />
      <error id="24006" name="ReportingProjectChangeMessageFailed"
uid="8f54f92e-b83f-4e84-8955-9821244458d2" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
terminated." />
    </class>
    <class name="Queue">
      <error id="26000" name="GeneralQueueJobFailed"
uid="5ecdb417-6c78-473a-b0ce-41bae141fd41"
JobUID="f35eb12b-0743-4970-8254-12d4fe8dd54a" ComputerName="C352"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
    </class>
  </general>
</errinfo>



Thankis,
0
Reply BruceFFIC 4/21/2010 11:30:14 PM 

Bruce:

Try this therapy and see if it helps, most often it does the trick:


http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/forcerebuildofprojectserverreportingdatabase.aspx


-- 
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"BruceFFIC" <breynold@ffic.com> wrote in message 
news:9239e9e3-891b-4f92-a2ff-c8f275f1182e@k5g2000prg.googlegroups.com...
> We are running MS Project Server 2007 SP2 with AUG09 MS CU.
>
> One of our projects is always failing on the "Reporting(Project
> Publish) step with the following error.  I am not an SQL expert, and
> the person who does our SRS reports is not able to figure it out.
>
> Does anyone have any idea what is happening?
>
>
> 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="b74b102f-37ca-4848-8c99-49b6a0c94f38" QueueMessageBody="Project
> UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> PublishType='ProjectPublish'" Error="The INSERT statement conflicted
> with the FOREIGN KEY constraint
> &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> terminated." />
>      <error id="24006" name="ReportingProjectChangeMessageFailed"
> uid="f33f9dad-29f0-46a0-81a3-5ee3f0745e5f" QueueMessageBody="Project
> UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> PublishType='ProjectPublish'" Error="The INSERT statement conflicted
> with the FOREIGN KEY constraint
> &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> terminated." />
>      <error id="24006" name="ReportingProjectChangeMessageFailed"
> uid="d8bf9a30-25e2-432d-b87a-3454ac5911dd" QueueMessageBody="Project
> UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> PublishType='ProjectPublish'" Error="The INSERT statement conflicted
> with the FOREIGN KEY constraint
> &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> terminated." />
>      <error id="24006" name="ReportingProjectChangeMessageFailed"
> uid="fc353334-7ea7-446c-b906-438e9d3e0d64" QueueMessageBody="Project
> UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> PublishType='ProjectPublish'" Error="The INSERT statement conflicted
> with the FOREIGN KEY constraint
> &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> terminated." />
>      <error id="24006" name="ReportingProjectChangeMessageFailed"
> uid="bf52b3a8-ee78-4937-8223-c54c487f966c" QueueMessageBody="Project
> UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> PublishType='ProjectPublish'" Error="The INSERT statement conflicted
> with the FOREIGN KEY constraint
> &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> terminated." />
>      <error id="24006" name="ReportingProjectChangeMessageFailed"
> uid="8f54f92e-b83f-4e84-8955-9821244458d2" QueueMessageBody="Project
> UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> PublishType='ProjectPublish'" Error="The INSERT statement conflicted
> with the FOREIGN KEY constraint
> &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> terminated." />
>    </class>
>    <class name="Queue">
>      <error id="26000" name="GeneralQueueJobFailed"
> uid="5ecdb417-6c78-473a-b0ce-41bae141fd41"
> JobUID="f35eb12b-0743-4970-8254-12d4fe8dd54a" ComputerName="C352"
> GroupType="ReportingProjectPublish"
> MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
>    </class>
>  </general>
> </errinfo>
>
>
>
> Thankis,
0
Reply Gary 4/22/2010 12:48:15 PM 


On Apr 22, 5:48=A0am, "Gary L. Chefetz" <g...@nospam.chefetz.org> wrote:
> Bruce:
>
> Try this therapy and see if it helps, most often it does the trick:
>
> http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/for...
>
> --
> Gary L. Chefetz, MVP, MCT, MCTIP
> Business:http://www.msprojectexperts.com
> FAQs:http://www.projectserverexperts.com
> BLOG:http://www.projectserverhelp.com
>
> "BruceFFIC" <breyn...@ffic.com> wrote in message
>
> news:9239e9e3-891b-4f92-a2ff-c8f275f1182e@k5g2000prg.googlegroups.com...
>
>
>
> > We are running MS Project Server 2007 SP2 with AUG09 MS CU.
>
> > One of our projects is always failing on the "Reporting(Project
> > Publish) step with the following error. =A0I am not an SQL expert, and
> > the person who does our SRS reports is not able to figure it out.
>
> > Does anyone have any idea what is happening?
>
> > Error summary/areas:
> > Reporting message processor failed
> > ReportingProjectChangeMessageFailed
> > ReportingProjectChangeMessageFailed
> > ReportingProjectChangeMessageFailed
> > ReportingProjectChangeMessageFailed
> > ReportingProjectChangeMessageFailed
> > ReportingProjectChangeMessageFailed
> > Queue
> > GeneralQueueJobFailed
> > Error details:
>
> > <?xml version=3D"1.0" encoding=3D"utf-16"?>
> > <errinfo>
> > =A0<general>
> > =A0 =A0<class name=3D"Reporting message processor failed">
> > =A0 =A0 =A0<error id=3D"24006" name=3D"ReportingProjectChangeMessageFai=
led"
> > uid=3D"b74b102f-37ca-4848-8c99-49b6a0c94f38" QueueMessageBody=3D"Projec=
t
> > UID=3D'dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> > PublishType=3D'ProjectPublish'" Error=3D"The INSERT statement conflicte=
d
> > with the FOREIGN KEY constraint
> > &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> > occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> > &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> > terminated." />
> > =A0 =A0 =A0<error id=3D"24006" name=3D"ReportingProjectChangeMessageFai=
led"
> > uid=3D"f33f9dad-29f0-46a0-81a3-5ee3f0745e5f" QueueMessageBody=3D"Projec=
t
> > UID=3D'dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> > PublishType=3D'ProjectPublish'" Error=3D"The INSERT statement conflicte=
d
> > with the FOREIGN KEY constraint
> > &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> > occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> > &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> > terminated." />
> > =A0 =A0 =A0<error id=3D"24006" name=3D"ReportingProjectChangeMessageFai=
led"
> > uid=3D"d8bf9a30-25e2-432d-b87a-3454ac5911dd" QueueMessageBody=3D"Projec=
t
> > UID=3D'dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> > PublishType=3D'ProjectPublish'" Error=3D"The INSERT statement conflicte=
d
> > with the FOREIGN KEY constraint
> > &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> > occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> > &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> > terminated." />
> > =A0 =A0 =A0<error id=3D"24006" name=3D"ReportingProjectChangeMessageFai=
led"
> > uid=3D"fc353334-7ea7-446c-b906-438e9d3e0d64" QueueMessageBody=3D"Projec=
t
> > UID=3D'dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> > PublishType=3D'ProjectPublish'" Error=3D"The INSERT statement conflicte=
d
> > with the FOREIGN KEY constraint
> > &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> > occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> > &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> > terminated." />
> > =A0 =A0 =A0<error id=3D"24006" name=3D"ReportingProjectChangeMessageFai=
led"
> > uid=3D"bf52b3a8-ee78-4937-8223-c54c487f966c" QueueMessageBody=3D"Projec=
t
> > UID=3D'dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> > PublishType=3D'ProjectPublish'" Error=3D"The INSERT statement conflicte=
d
> > with the FOREIGN KEY constraint
> > &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> > occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> > &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> > terminated." />
> > =A0 =A0 =A0<error id=3D"24006" name=3D"ReportingProjectChangeMessageFai=
led"
> > uid=3D"8f54f92e-b83f-4e84-8955-9821244458d2" QueueMessageBody=3D"Projec=
t
> > UID=3D'dccf924a-e8f6-4894-8997-82ea41cc6e46'.
> > PublishType=3D'ProjectPublish'" Error=3D"The INSERT statement conflicte=
d
> > with the FOREIGN KEY constraint
> > &quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
> > occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
> > &quot;dbo.MSP_EpmTask&quot;.&#xD;&#xA;The statement has been
> > terminated." />
> > =A0 =A0</class>
> > =A0 =A0<class name=3D"Queue">
> > =A0 =A0 =A0<error id=3D"26000" name=3D"GeneralQueueJobFailed"
> > uid=3D"5ecdb417-6c78-473a-b0ce-41bae141fd41"
> > JobUID=3D"f35eb12b-0743-4970-8254-12d4fe8dd54a" ComputerName=3D"C352"
> > GroupType=3D"ReportingProjectPublish"
> > MessageType=3D"ReportProjectPublishMessageEx" MessageId=3D"1" Stage=3D"=
" />
> > =A0 =A0</class>
> > =A0</general>
> > </errinfo>
>
> > Thankis,- Hide quoted text -
>
> - Show quoted text -

Gary,

As usual thank you.

I tried a few things hoping they would work

1. Exported to XML and then re-imported - didn't work
2. Restored a backup copy - believe it or not, but this worked.

Again Thanks,
0
Reply BruceFFIC 4/23/2010 12:13:14 AM
microsoft.public.project.server 1347 articles. 5 followers.

2 Replies
857 Views

(page loaded in 0.003 seconds)

Similiar Articles:

Project Fails in the "Reporting(Project Publish) Step ...
We are running MS Project Server 2007 SP2 with AUG09 MS CU. One of our projects is always failing on the "Reporting(Project Publish) step with the...

Project Failing in the Reporting(Project Publish) Step - microsoft ...
Project Server CAL - when are they required? - microsoft.public ... Project Fails in the "Reporting(Project Publish) Step ... We are running MS Project Server 2007 ...

Project Server - force publish? - microsoft.public.project.server ...
Project Failing in the Reporting(Project Publish) Step - microsoft ... Project Fails in the "Reporting(Project Publish) Step ... Project Server - force publish ...

Reporting DB out of Synch with Publish DB - microsoft.public ...
Reporting DB out of Synch with Publish DB - microsoft.public ... Project Fails in the "Reporting(Project Publish) Step ..... person who does our SRS reports is not able to ...

Timesheet on Published DB, but not in Reporting DB - microsoft ...
Project Fails in the "Reporting(Project Publish) Step ... Project Server - force publish? - microsoft.public.project.server ... Timesheet on Published DB, but not in ...

Project Server 2007 - Publish Feature - microsoft.public.project ...
Project Fails in the "Reporting(Project Publish) Step ... Project Server 2007 - Publish Feature - microsoft.public.project ... Project Fails in the "Reporting(Project ...

Timesheet Custom Fields in Reporting Database MSPS 2007 ...
... cases, the sync with publish and reporting can fail; perhaps it's better to gather data from publish ... Project Failing in the Reporting(Project Publish) Step - microsoft

CAL License Requirements for Project Server SharePoint Pages ...
CAL License Requirements for Project Server SharePoint Pages ... Project Failing in the Reporting(Project Publish) Step - microsoft ... Project Fails in the "Reporting ...

Task Update in PWA 2007 - microsoft.public.project.server ...
... to automatically accept the task update, the system DOES NOT publish ... My team is using Project Server 2007 and PWA to ... Project Fails in the "Reporting(Project ...

microsoft.public.project.server - page 21
Project Failing in the Reporting(Project Publish) Step BruceFFIC 0 256 We are running MS Project Server 2007 SP2 with AUG09 MS CU. One of our projects is always failing on ...

Project Fails in the "Reporting(Project Publish) Step Project
We are running MS Project Server 2007 SP2 with AUG09 MS CU. One of our projects is always failing on the Reporting(Project Publish) step with the followi

Answer : Project Fails in the "Reporting(Project Publish) Step
Project Fails in the "Reporting(Project Publish) Step - answer - We are running MS Project Server 2007 SP2 with AUG09 MS CU. One of our projects is always failing on ...

Re: Project Fails in the "Reporting(Project Publish) Step
On Apr 22, 5:48 am, "Gary L. Chefetz" <g...@nospam.chefetz.org> wrote: > Bruce: > > Try this therapy and see if it helps, most often it does the trick: > > http ...

Project Fails in the "Reporting(Project Publish) Step ...
We are running MS Project Server 2007 SP2 with AUG09 MS CU. One of our projects is always failing on the "Reporting(Project Publish) step with the...

Project Failing in the Reporting(Project Publish) Step - microsoft ...
Project Server CAL - when are they required? - microsoft.public ... Project Fails in the "Reporting(Project Publish) Step ... We are running MS Project Server 2007 ...

7/23/2012 10:55:49 PM


Reply:



Privacy Policy | All Times Are GMT(UTC) | powered by