Project Server 2007 : Reporting (WSS Sync) Job Failed but not Blocking

Below are the top 3 reasons for receiving this error message.  First you will need to dissect the error message.
Find the following two entries: SPListType=”xxxx” Error=”yyyyy”

SP List ID   SP List Name

1100            Issues

1101            Risks

1104            Deliverables

Scenario 1.

**********

<error id="24018" name="ReportingWssSyncListFailed" uid="98df7838-4760-49ed-864c-a27773850d18" SPListType="1100" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="64ee928c-6ca1-47ee-be13-d033c76bedba" SPListType="1101" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="3cc8deea-acba-4bc1-bc3c-214643ed47aa" SPListType="1104" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="a15bcba9-59c7-41d8-a634-d24e8b317ee0" SPListType="1100" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="9ef51835-0e70-4cf3-85d9-809805044814" SPListType="1101" 

Workaround 1.

**************

The first line of the error message it is referencing to " SPListType="1100" Error="Mismatched transaction."

1.     In the “Issue” list item there could be some issue item’s where “Assigned To” and “Owner” columns values are BLANK

Update these values for all the listed issue items.

2.     Now Publish the project plan

3.     In Manage queue hopefully you will not see Reporting (WSS Sync ) error

4.     If you still getting Reporting (Wss Sync) error then check the error message in manage queue and match the scenario


 Scenario 2.

**********

<error id="24018" name="ReportingWssSyncListFailed" uid="159dcef9-ed73-4a45-866e-1852c098d1e6" SPListType="1101" Error="Failed to prepare the transfer of SP list 1101 for project '7053e472-db33-49f3-a148-476cab370f6a'. The field Cost was missing from the SP list and was ignored." />
<error id="24018" name="ReportingWssSyncListFailed" uid="076c5db8-a912-4f7d-ba36-db60bb037815" SPListType="1101" Error="Failed to prepare the transfer of SP list 1101 for project '7053e472-db33-49f3-a148-476cab370f6a'. The field Cost was missing from the SP list and was ignored." />

Workaround 2.

*************

The above error is referencing to SPListType="1101" and . “The field Cost was missing from the SP list and was ignored."
In this example “Cost” field was missing in Risk. Same pattern we can create other fields 

1.     Open project workspace on which you are getting this error.

2.     From Quick Launch select “Risk”

3.     Settings>>List Settings>>Create column

4.     Create “Cost” field (check the default values from any working workspaces)

5.     Now Publish the project plan

6.     In Manage queue hopefully you will not see Reporting (WSS Sync ) error

7.     If you still getting Reporting (Wss Sync) error then check the error message in manage queue and match the scenario
 

Scenario 3.

***********

<error id="24018" name="ReportingWssSyncListFailed" uid="159dcef9-ed73-4a45-866e-1852c098d1e6" SPListType="1101" Error="Failed to prepare the transfer of SP list 1101 for project '7053e472-db33-49f3-a148-476cab370f6a'. The field Description  was missing from the SP list and was ignored." />

Workaround 3.

************

In some examples I have also seen that the “Risk” Description field is there but still you will get the above error.

In this scenario you need to delete the description field and recreate.

***If you don’t have any useful information in the workspace, delete the workspace and the recreation of the workspace will resolve all the scenario’s above.

*****************COMPLETE ERROR MESSAGE *******************************

Error summary/areas:
Reporting Wss list sync failed
ReportingWssSyncListFailed

ReportingWssSyncListFailed
ReportingWssSyncListFailed
Reporting transfer WSS links failed.
ReportingWssTransferLinksFailed
ReportingWssTransferLinksFailed
ReportingWssTransferLinksFailed
Reporting message processor failed
ReportingWSSSyncMessageFailed

ReportingWSSSyncMessageFailed
Reporting ProjectWorkspaceInternalHRef field sync failed
ReportingWssSyncHRefFailed
ReportingWssSyncHRefFailed

ReportingWssSyncHRefFailed
Queue
GeneralQueueJobFailed
Error details:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting Wss list sync failed">
<error id="24018" name="ReportingWssSyncListFailed" uid="98df7838-4760-49ed-864c-a27773850d18" SPListType="1100" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="64ee928c-6ca1-47ee-be13-d033c76bedba" SPListType="1101" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="3cc8deea-acba-4bc1-bc3c-214643ed47aa" SPListType="1104" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="a15bcba9-59c7-41d8-a634-d24e8b317ee0" SPListType="1100" Error="Mismatched transaction." />
<error id="24018" name="ReportingWssSyncListFailed" uid="9ef51835-0e70-4cf3-85d9-809805044814" SPListType="1101" Error="Mismatched transaction." />
</class>
<class name="Reporting transfer WSS links failed.">
<error id="24019" name="ReportingWssTransferLinksFailed" uid="6b41c89e-5ab7-4e7f-a37c-064ffad25ebe" Error="Mismatched transaction." />
<error id="24019" name="ReportingWssTransferLinksFailed" uid="024a683d-d743-4caa-9808-742d01c360b3" Error="Mismatched transaction." />
<error id="24019" name="ReportingWssTransferLinksFailed" uid="6b624adf-cd8a-4963-8e45-7dbe3a2540b2" Error="Mismatched transaction." />
</class>
<class name="Reporting message processor failed">
<error id="24016" name="ReportingWSSSyncMessageFailed" uid="44419642-fc21-47fa-bff8-ed83da43cbcc" QueueMessageBody="ProjectUID='91a74b99-5487-482e-adc7-a16c5e7878f9'. ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed" uid="58064d39-da8b-40ae-88e5-d00812f35265" QueueMessageBody="ProjectUID='91a74b99-5487-482e-adc7-a16c5e7878f9'. ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed" uid="8b183448-1b2e-49aa-a513-bb04502453d6" QueueMessageBody="ProjectUID='91a74b99-5487-482e-adc7-a16c5e7878f9'. ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed" uid="f9cabf75-98af-426f-9e6a-8d407f432ce4" QueueMessageBody="ProjectUID='91a74b99-5487-482e-adc7-a16c5e7878f9'. ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried." />

</class>
<class name="Reporting ProjectWorkspaceInternalHRef field sync failed">
<error id="24021" name="ReportingWssSyncHRefFailed" uid="03c01005-484a-407d-ac75-70663314fd95" Error="Mismatched transaction." />
<error id="24021" name="ReportingWssSyncHRefFailed" uid="24f30780-5be8-4418-96b2-2a6c1baba4b1" Error="Mismatched transaction." />
<error id="24021" name="ReportingWssSyncHRefFailed" uid="0a47f802-04b9-4072-ad0e-37ac7f84a9c4" Error="Mismatched transaction." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="6d57df72-4042-406f-951d-072340df0803" JobUID="7a41ff5c-ecba-416a-9bc5-a5df6f6d7bbb" ComputerName="INVG2158" GroupType="ReportingWSSSync" MessageType="WSSSyncMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>


Permalink | Comments (0) | Post RSSRSS comment feed

Comments