Project Windows SharePoint Services format error
Applies to: Project Server 2013, Project Server 2010
Topic Last Modified: 2013-12-18
Element ID / Rule Name: Project_Windows_SharePoint_Services_Format_Error
Summary: The Reporting Data Service extracts Microsoft Project Issue, Risk, and Deliverable data from lists that are defined within each workspace (sites) on the Microsoft Project Server application servers in the farm. This alert occurs if an item in one of the lists contains data that cannot be stored in its associated Reporting database table. This typically is caused by the list data being in the wrong format or too large to store in the database table.
The resolution is to fix the underlying problem. The RDS pulls SharePoint Server data (Issues, Lists, Deliverables) into RDS. Use ULS to pinpoint the SharePoint Server list item causing the issue. Delete/re-create the item, or look for type mismatches/anomalies in the list item instance data.
Cause: An administrator or designer incorrectly modified the standard Project list templates. For example, the entry types or sizes were changed in a way that data that was stored in lists cannot be replicated to the Reporting database.
The Project Server SDK documentation indicates valid customizations that can be made to these standard list items.
Possible resolutions include the following:
If the site template was incorrectly edited, you can do the following to resolve the problem:
Correct the site template.
Recreate the workspace using the corrected template.
Manually reload the data into the lists.
If this procedure is not feasible, the affected lists should be deleted and a custom list that supports the data format that you require should be used instead. Note that if you choose this alternate resolution, you will not be able to replicate data from the custom list to the Reporting database.