topic RE: Unable to update SharePoint List on cloud in Product Forum

Unable to update SharePoint List on cloud

MateuszWojcik — Fri, 02 Aug 2019 07:55:00 GMT

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

RE: Unable to update SharePoint List on cloud

GopalBhaire — Fri, 02 Aug 2019 09:18:00 GMT

Never had issues with Update in Oledb you can edit the 'Execute' action of OLEDB object to return the no. of rows affected that'll help you know if rows were affected or not

rowsAffected=oCommand.ExecuteNonQuery()

just add a number as output(rowsAffected)

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Unable to update SharePoint List on cloud

MateuszWojcik — Fri, 02 Aug 2019 10:38:00 GMT

Hi Gopal,

It will not help me as Blue Prism does not go out from the "Update" stage. Therefore I will not be able to check the output.

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

RE: Unable to update SharePoint List on cloud

GopalBhaire — Fri, 02 Aug 2019 10:52:00 GMT

Try adding CommandTimeout, that should at-least help you get out of Update Query

oCommand.CommandTimeout = 120

the time is in sec.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Unable to update SharePoint List on cloud

MateuszWojcik — Fri, 02 Aug 2019 11:03:00 GMT

It does not help. Blue Prism is still stuck on Update Stage.

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

RE: Unable to update SharePoint List on cloud

MichalSzumski — Mon, 12 Aug 2019 10:08:00 GMT

Hi All,

Bumping this topic - We encountered it on another SharePoint site. If anybody had similar issue then please let us know.

Best regards,
Michal

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

RE: Unable to update SharePoint List on cloud

AndrewRandolph — Mon, 12 Aug 2019 18:34:00 GMT

Are you explicitly closing the connection to the SQL server after the updates? Also what is the data within those rows on the sharepoint? Maybe there is an error in that? Could you attach the data being used for reference if possible?

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

RE: Unable to update SharePoint List on cloud

MateuszWojcik — Tue, 13 Aug 2019 05:33:00 GMT

Hi Andrew,

I do nothing after updates because the update stage is never ending.

The data I try to update are in the original message. They are correct. I also try to update column number with value 1 and this also was not successful.

Kind regards

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

RE: Unable to update SharePoint List on cloud

AndrewRandolph — Tue, 13 Aug 2019 17:06:00 GMT

Hey Mateusz,

Is it possible for you to share the 15 lines that you did update using the query from the original message on the sharepoint? If you could please share this with me that would be great. Trying to understand why this isn't working and if there is a correlation between this error and the other one that has arisen due to the post bump

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

RE: Unable to update SharePoint List on cloud

MateuszWojcik — Wed, 14 Aug 2019 05:23:00 GMT

It does not matter what is in those 15 lines.
I input another line with the same information and I was able to update it.
The only correlation I have noticed was the person who input the data.
Those 5 lines I was unable to update was inputted by 2 person.
Unfortunately when I was updating another SharePoint List I faced the same problem.
In this case all lines was inputted by 1 person. Some of them I was able to update some was not.

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

RE: Unable to update SharePoint List on cloud

AndrewRandolph — Thu, 15 Aug 2019 20:02:00 GMT

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

RE: Unable to update SharePoint List on cloud

MichalSzumski — Fri, 16 Aug 2019 11:40:00 GMT

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

RE: Unable to update SharePoint List on cloud

AndrewRandolph — Fri, 16 Aug 2019 17:42:00 GMT

Ok sounds good! OLEDB can be confusing at times

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