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

[GopalBhaire]

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

[MateuszWojcik]

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

[GopalBhaire]

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

[MateuszWojcik]

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

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

[MichalSzumski]

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

[AndrewRandolph]

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

[MateuszWojcik]

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

[AndrewRandolph]

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

[MateuszWojcik]

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