Complete records are not getting moved from database to sharepoint

Question

Hello All,

I'm trying to move the data from database table to SharePoint list. But Alteryx is not moving the entire records.

So for now my DB table has roughly 900 records, but it's only moving 420 records and it's throwing attached error.

Could you please advise any solution?

I've tables where we've more then 1000 records and by the use of alteryx we want move those tables to SharePoint list

Please help

DB to SP.PNG

SharePoint List Error.PNG

swapsingh2712 · Answer

@danilang I've tried using the different batch sizes like 200,185,150,100,50,25. But none of them copied the entire records to the sharepoint. Here's the list of batches and iterations I tried

batch                        size records

100                       2 iteration run (128 items added to sp list)
25                         5 iteration run (53 items added to the list)
50                         3 iterations run (128 items moved)
150                       1 iterations run (278 items moved)
185                       1 iterations run (243 items moved)
200                       1 iterations run (228 items moved)

Not able to move entire records (830 records). Please advise.

I've attached the screenshot of the macro which I've created

Iterative Macro_SP.PNG

danilang · Answer

hi @swapsingh2712

The record size is passed into the macro in the S input.  In the main workflow this set in the Batch Size input tool.  Change this number to 200 and see if this works.  If not decrease to to 100, then 50, then 25, etc to find the largest batch size that Sharepoint will accept.

Dan

swapsingh2712 · Answer

Hello @danilang

Thank you so much for your help. Actually I'm not very much familiar with iterative workflow. so Just wanted to ask, How can add the record size in the batch, as my input is coming from the database which contains around 850 records