SharePoint 2010: Exception occurred while submitting data into the Stager

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)    …


SharePoint 2010: Web part errors accessing external web sites

Problem: Today a string a errors appeared on web parts within a customer’s sharepoint 2010 farm such as: Error loading weather details. Unable to connect to the remote server Check weather service connection. Cannot connect to Resolution: The fact that this ‘used to work before’ and that all of these problems appeared today  was…


SharePoint 2010: No new ULS logs being generated

Problem: Customer discovered that the ULS logs had stopped generating. Within the Logs file there were files but from an old date. Troubleshooting: I looked in Event viewer and found this: Tracing Service failed to create the trace log file at location specified in SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\LogDir Error 0x0: The operation completed successfully. ….


Powershell: How to convert a ‘Single line of Text’ column to ‘Multi-line of Text’

Problem: Customer needed a way, via PowerShell to convert a column from single line of text to Multi-line of text. I first verified that the column they were trying to convert was not the default ‘Title’ column, I would not recommend touching that one. The customer had run into an issue where the Single Line…