Updating a list errors out

[Yuri24]

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 solution]

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.

[JPSeagull]

Thanks for solving this....I had the same issue and drove me crazy trying to resolve it. As it turns, I too used a Join that occasionally had NULLS in the data. I changed my SQL code to enter another value if the data would be null that day.