We are trying to implement the SharePoint and OneDrive input and output tools for our company and having nothing but problems. After months of work we finally got them partially working.
I can now connect to and write through a SharePoint Output tool. But now I'm getting the following error.
When Writing a dataset of about 1.1 M rows to a CSV delimited file, it consistently writes 149311 rows, then stops with this error. Here is the error log:
any ideas what this is? Is there some undocumented limit on how many rows it can write?
Is it choking on something in the data?
I made sure to size all the columns less than 254 in size and looking at the data in row 149311, there is nothing remarkable or different about it.
Just to test, I threw a sort in front of the output and resorted it to put the data in a different order (so it wouldn't be writing the same row of data to that row) and it DID switch to a different row count, so it would seem to be something in that particular row of data. However the row it chokes on after the sort (consistantly) is NOT the same row it chokes on with the prior sort. And there is nothing unique or interesting about either row of data.
Anybody have any ideas?
I'm having the same error message from the SharePoint output tool. I can write only 40,753 rows of data with 63 columns.
I reran the same dataset limiting it to only 40,000 rows and ran with no error. Is there a file size limitation with the SharePoint output tool?
Running Server & Designer version 24.1 and SharePoint tools version 2.6.0.
Follow up to my last post. I generated 3M rows and tried to write to SharePoint. Could only write 1.66M rows before the error.
Any ideas how to prevent this from happening?
