I am facing problem with my custom developed webpart which inserts data into a sharepoint list using excel sheet. I have a list with around 50+ columns in it, it has 10+ lookup columns in it, things working fine with less number of records (till 470 values for a single lookup column) but what I observed is when my lookup column is having more than 470 values in a single lookup column its throwing some error while trying to update listitem using listitem.update method. In event viewer what I found is : Unknown SQL Exception 8003 occurred. Additional error information from SQL Server is included below. "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."
Now when i try editing some lookup item in list having 470 values for a single lookup column, and try adding some more values gets the error message: : "Exception from HRESULT: 0x80131904" with the above mentioned message in event viewer logs. Anyone aware about the maximum allowed values for a single lookup column in sharepoint list? and how can i update if it is possible with some configuration? any help is appreciated.