Project Server Queue Error: Reporting WssSyncList Failed (24018)

In this post, we will solve the “Reporting WssSyncList Failed to prepare the transfer of SP list 1100 for project. the field category was missing from the SP list and was ignored” issue that you may face during publishing a project schedule in Project Server


Reporting WssSyncList Failed (24018)

In Project Server, when I tried to publish a project schedule from PWA, I got the below error

Reporting WssSyncList Failed to prepare the transfer of SP list 1100 for project. the field category was missing from the SP list and was ignored

Reporting WssSyncList Failed (24018)
Reporting WssSyncList Failed (24018)

Failed to prepare the transfer of SP list 1100 for project

This problem might occur because one or more out of the box list columns have been removed from the default lists like Issues, Risks, and Deliverable in Project site.

The SP list ID that shown in the error message represents the list name based on the following table:

SP List IDSP List Name
1100Issues
1101Risks
1104Deliverables

In our case, the problem occurred in the Issues list (1100), so we will check the issue list and we will make sure that the category field is not removed by doing the following:

  • Open the project site workspace for this project  > Go to issues list setting.
  • As you can see, the category field is not found that means it was manually removed!! and this behavior is not supported in Project Server. therefore, it causes a sync problem between the Project Site and Reporting DB.
issue list settings

Important

You should be aware of removing or updating the default columns in the default Project Server list will raise sync issues. therefore, please, don’t try to remove any fields in the default lists in the project site. Instead, you should do the following:

  • If you would like to customize these lists in order to hide some fields, so in this case, you should edit the list view to hide them.
  • Also, you can enable content type for this list and set this field as hidden.
Hide column in SharePoint List

The field category was missing from the SP list and was ignored

To solve this issue, please, follow the bit instructions mentioned below:

  • Open an issue list within another Project site that was not modified before.
  • Go to list setting > Field Name > Check the URL (In Some Fields As “Assigned To” the original name is AssignedTo without space)
Get Field Internal Name
Get Field Internal Name
  • Pick the field name as above shown.
  • Go back to the affected Project Site.
  • Open the affected list (In my case it is Issue list) >  Add a new column > Name the new field with the same field name that picked from the original list.
  • Publish the Project Schedule again.
  • Try to check the project queue that shouldn’t raise the sync issue for this field now. (Might be the problem still persists but with another list or another field )

NoteIf you didn’t have any important information on your Project Site, I advise you to delete it and recreate a new one that will solve all errors related to ReportingWssSyncListFailed.


Conclusion

In conclusion, we have learned it’s very important to avoid deleting any built-in fields in the default project server lists to avoid any “Reporting WssSyncList failed issues”

Applied To
  • Project Server 2013.
  • Project Server 2010.
You might also like to read
Have a Project Server / Online Question?

If you have any related questions, please don’t hesitate to ask it at deBUG.to Community.

Leave a Reply