[BUG] PnPUPABulkImportStatus and New-PnPUPABulkImportJob now generate " The attempted operation is prohibited because it exceeds the list view threshold."

[thomasdaggett]

[BUG] PnPUPABulkImportStatus and New-PnPUPABulkImportJob both fail to execute and generate error " The attempted operation is prohibited because it exceeds the list view threshold.**" after it has been running in scripts daily for over a year. Please let me know how I can clear the list or circumvent this error. I am unable to submit new import jobs nor query for jobs.

Expected behavior

These cmdlets were being used for over a year but now cannot run. No jobs can be submitted or queried.

Actual behavior

Error message is "The attempted operation is prohibited because it exceeds the list view threshold." for both PnPUPABulkImportStatus and New-PnPUPABulkImportJob cmdlets

Steps to reproduce behavior

$JobsInSPO = Get-PnPUPABulkImportStatus

What is the version of the Cmdlet module you are running?

1.12.0 on PS 5.1 and 2.2.0 on PS 7

Which operating system/environment are you running PnP PowerShell on?

• Windows

[jackpoz]

What is the version of the Cmdlet module you are running?

1.12.0

Just as a note, 1.12.0 was released on November 2022 at https://github.com/pnp/powershell/releases/tag/v1.12.0 , I would suggest trying with the latest version first.

[thomasdaggett]

I am running the scripts on PS 5.1 as I am limited from upgrading, is there a newer version than 1.12.0 that is 5.1 compatible for me to try? I believe 1.12.0 is the last 5.1 compatible version.

[jackpoz]

Well, 1.12.0 is no longer maintained, any fix would be applied to 2.x anyway.
How many files do you have in the library storing the import jobs btw ?

[thomasdaggett]

I went ahead and deleted the full history of all files in the library, cleared the primary and secondary recycle bin. Each day I create a new folder with about 200 files in it. It does seem that a list threshold was reached but I cannot seem to find where that list is and how to clear it, it seems the job submission status is never being cleared.

[thomasdaggett]

I tried this using the PnP.PowerShell 2.2.0 version on Powershell 7, regardless of the site I use for the PnP connection I get the same error:
Get-PnPUPABulkImportStatus -IncludeErrorDetails
Get-PnPUPABulkImportStatus: The attempted operation is prohibited because it exceeds the list view threshold.

Get-PnPUPABulkImportStatus
Get-PnPUPABulkImportStatus: The attempted operation is prohibited because it exceeds the list view threshold.

Does anyone know what list it is referring to and where it stored/how to empty it?