Unable to update SharePoint List on cloud

[MateuszWojcik]

Hi,

I use OLEDB to update SharePoint List on cloud.

This is SQL Script I use:
"UPDATE LIST SET [Status] ='Rejected', [PO_Completed_Number] ='0', [PO_Rejected_Number] ='3', [PO_RejectedWithComments] ='7000111111 - Different Vendor_ID(111111 Micky Mouse Company).', [PO_Numbers] ='3', [PO_Completed] ='' WHERE [ID] = 11"

I have updated 15 linies in Sharepoint List.
12 linies have been updated successfully.
3 linie [ID: 11,13,15] were unable to update. Blue Prism stuck on the "update" stage and did not throw any exception. It seems like it falls into infinite loop.

I tried to update the same information into another  ID and it worked.
I tried to updated line in manually and it worked.
I tried to update only 1 column in ID 11,13,15 and it also stuck.


Please let m know if you have faced such issue.




------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------

[AndrewRandolph]

It may be possible that there are multiple instances of the file open on multiple computers making it difficult to make a unified update. I would contact the 2 people that made file updates and see if they have it checked out on SharePoint. This may not be blue prism related but is definitely a bug worth looking in to.

------------------------------
Andrew Randolph
Analyst
Accenture
America/New_York
------------------------------

[MichalSzumski]

Hi Andrew,

Our problem concerns SharePoint List and not the file on SharePoint. Anyway we found solution - we had to get rid of this part "RetrieveIds=Yes" from Connection String and then it worked

Best regards,
Michal

------------------------------
Michal Szumski
RPA developer
Rockwell Automation
Europe/Warsaw
------------------------------

[AndrewRandolph]

Ok sounds good! OLEDB can be confusing at times

------------------------------
Andrew Randolph
Analyst
Accenture
America/New_York
------------------------------