I'm having a similiar problem with one of my customers. We haven't been able to resolve it but we have found a way around it, I'd like to do more testing but my customer justs wants to get on with it now that we have a workaround. Logging a call with Microsoft
can be expensive, most businesses have a finite amount of support hours so you really have to do your homework before you starting chewing those hours up.
Customer created a custom list with two calculated columns and various choice, string and multi-string columns. Customer was attempting to copy and paste 128 rows of data into each column from a spreadsheet. The first (title) column successfully pasted
Subsequent columns would paste the values but not allow the values to be committed as every row displayed the "Unable to Communicate with the Server" message, preventing the list from being saved.
The problem appears to be related to the number of items the customer is trying to paste during each operation and the relationship this has with the calculated columns. We found that when we pasted 70 or less items in one operation we did not receive the
error. I attempted pasting 128 rows of data into a seperate list with the same columns excluding the calculated columns, and was successfully able to paste all 128 rows.
For the problem list I suggested to the customer to copy the formula's from the calculated columns, delete these columns and then trying pasting again, he didn't like the idea as he's happy to paste in 50% chunks. Based on the fact I was able to paste
without any problems on a list without calculated columns I would suggest it's related.
So my questions for you are:
- Are you trying to paste/add multiple values at once?
- Do you have any special column types, i.e. calculated or lookup columns?
- What columns do you have in your list?
- Have you tried adding the entries in using form entry instead of grid entry?
Unforunately I don't know how generic this error message is, there is absolutely nothing in my ULS logs or event viewer. If this error is specific to submitting data to a list in grid view it would make it easier to diagnose, but if the error is generic
in nature your problem could be as obscure as the FBA configuration.
I hope this information helps you, I will try and do some more testing.
Dave Essential Enterprise Solutions Ltd
Thursday, August 01, 2013 12:44 PM