Project user view was truncated


Applies to: Project Server 2013, Project Server 2010

Topic Last Modified: 2013-12-18

Element ID / Rule Name:   Project_User_View_Was_Truncated

Summary:   The Reporting Data Service creates views that make it easy for users to perform reporting and cube building against the Reporting database. These views, which are Microsoft SQL Server views, are limited to1024 columns, also referred to as fields.

This alert occurs every time that the Reporting Data Service recreates the Reporting Database views (for example, when cubes are defined or when custom fields are created or deleted) if the reporting database is configured to use more than 1024 columns.

Organizations that bring multiple business divisions together into the same Microsoft Project Server site may have little or no overlap between custom fields. This can result in a Reporting database that exceeds 1024 columns.

Cause:   A large number of custom fields, in combination with a large number of Project Server fields, can cause the Reporting database views to exceed the architectural limit of 1024 columns. To prevent this condition from causing the view creation process to fail, the Reporting Data Service stops adding custom fields when the limit is reached and provides a warning Windows NT Event to help system administrators who are unaware of this limit to diagnose “missing” data.

Possible resolutions include the following:

  • Reduce the number of custom fields used by any particular Project Server site. One way to do this is by creating additional Project Server sites and moving some of the users to the new sites.

  • Organizations that need more than 1024 fields for a particular site should consume the Reporting UserViewChanged event and create additional views that contain the additional data.