Call to Add-PnPFile returns $upload.UniqueId but the file is NOT uploaded

[jamesbl99]

I have what I think is some pretty simple code which reads a CSV file consisting of about ~16,000 files. In a typical foreach loop, I make a call to Add-PnPFile like this:

        $upload = Add-PnPFile -Path $fullPath -Folder $foldername -Values @{
        "Field1"=$($metadataField1)
        "Field2"=$metadataField2
        "Field3"=$metadataField3
        "Field4"=$metadataField4
        "Field5"=$metadataField5
        "Field6"=$metadataField6
        "Field7"=$metadataField7
        } -Connection $pnpconnection

From here I immediately check $upload.UniqueId as I understand if the file is not uploaded, this property will be NULL....

        if($upload.UniqueId)
                {
                    $successCounter += 1
                    Write-Host "$fullPath uploaded successfully." -ForegroundColor Green
                    Log ($fullPath + " uploaded successfully.")
                }
                else
                {
                    Write-Host "ERROR - Unable to Upload" -ForegroundColor Green
                    Log ($fullPath + " NOT uploaded successfully.")
                }

The issue I am having is out of these ~16,000 files, 2 of them are not actually uploaded to SPO, however, according to this code above and the corresponding log file, they are logged as successfully uploaded.

Has anyone run across this scenario and/or is there just generally a 100% reliable way to determine if the file in question was TRULY uploaded or not?

Thanks,
-jb

@VesaJuvonen

[jamesbl99]

I did add the following in an attempt to ensure the $upload variable was cleared after each run.

 `$upload=$null` #reset variable for the next run`

But alas, somewhere in the run, I received this error:

I/O error occurred. Exception setting "UniqueId": "Cannot convert null to type "System.Guid"." Exception setting "UniqueId": "Cannot convert null to type "System.Guid"." Exception setting "UniqueId": "Cannot convert null to type "System.Guid"."

No idea why nulling out the $upload object as a whole would result in this happening randomly...