Exception calling "ExecuteQuery" with "0" arguments(s): "The underlying connection was closed: An unexpected error occurred on a send."

Question

I have inherited this script from the previous developer and I am having trouble executing query.

Any ideas how to fix this?

    $site = "https://site.sharepoint.com/sites/fulltest2"
    $listName = "Show Calendar"
    $user = "[email protected]"   
    $pwd =ConvertTo-SecureString "password" -AsPlainText -Force  

    $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($site)
    $credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($user,$pwd)
    $ctx.Credentials = $credentials
    $siteColl = $ctx.Web
    $ctx.Load($siteColl)
    $ctx.ExecuteQuery()

    $list = $ctx.Web.Lists.GetByTitle($listName)
    $ctx.Load($list)
    $ctx.ExecuteQuery()

Sandeep Vootoori · Accepted Answer · 2019-12-16 13:18:59Z

1

I have just tried the exact same script on one of my site's and it worked(Replaced Site URL, List name, ID, Password). Please make sure your Site URL, List name, ID, Password are correct. If MFA is enabled in your tenant make sure you are VPN'd in.

answered Dec 16, 2019 at 13:18

Sandeep Vootoori

684 bronze badges

Add a comment |

Martin Bartovsky · Accepted Answer · 2021-05-18 14:24:51Z

1

You have to invoke TLS 1.2

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

Past the code line in the firs line of PS script.

answered May 18, 2021 at 14:24

Martin Bartovsky

111 bronze badge

Add a comment |

Stack Exchange Network

Exception calling "ExecuteQuery" with "0" arguments(s): "The underlying connection was closed: An unexpected error occurred on a send."

2 Answers 2

Your Answer

Hot Network Questions

Exception calling "ExecuteQuery" with "0" arguments(s): "The underlying connection was closed: An unexpected error occurred on a send."

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions