Users are not able to update historical data on particular lists. The update fails “silently” – no error is reported.
The underlying problem was discovered while running a trace against the sharepoint sql server. An error number 1150 was raised in proc_UpdateListItem (and ignored) when attempting to run an update.
We discovered that after a point in time, the number of rows in AllUserData that represented a version of a list item grew from 3 to 4 (tp_RowOrdinal). The attempted updates to the historical items that have 3 rows fail. Below is a snippet from
proc_UpdateListItem where the error is occurring:
OR @RowOrdinal > 0
= 0 OR
What is the recommended way to resolve this? Should an additional record be added for each version? This seems risky. Is there a way to inform sharepoint that historical records have 3 rows, while current records have 4?
We have been using several tools with sharepoint, including deployment tools, so we are unsure what caused the issue.
Any help or information would be greatly appreciated.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.