Updating a list errors out

Question

Hello,

I loaded my Sharepoint list with data from a query and it took about an hour to complete. I used "Delete List and Append" option for the sharepoint list output.

However when I change it to "Update; Error on Update Failure" and trying to update the sharepoint list I am getting the below error.

Error: SharePoint List Output: Error while updating records: The 'sId' argument is invalid.

There is no sId field that I am using in my data/dataset

Yuri24 · Accepted Answer

I figured it out, one of the columns had no data in it while it was being used in a join. That column was no longer needed and another unique int64 column was used to perform the join and it was fixed.