SharePoint 2010: Exception occurred while submitting data into the Stager

  • Article

Problem: In the ULS logs we found this error:

Exception occured while submitting data into the Stager (tableName=WAQueryFeedback ): System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.   

at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)     -

-- End of inner exception stack trace ---   

Solution: I first asked the customer to verify that the ‘Usage and Health data collection proxy’ was working properly. He went into Central administration and verified it was accessible and you could get to it. After re-provisioning the service with the below powershell command the error went away:

$svcAppProxy = Get-SPServiceApplicationProxy | where-object {$_.TypeName -eq “Usage and Health Data Collection Proxy”}
$svcAppProxy.Provision()

Fight Comparison:
Virgil Hill vs Roy Jones Jr…after feeling each other out for a few, Jones took him out in the 4th