Sharepoint command: List Files Error

Support
1

Hi,

I'm trying to use the Sharepoint command action, yesterday before the update i dont have any problem. Now I receive the error "Error: The attempted operation is prohibited because it exceeds the list view threshold."

Someone with the same problem? How can i fix it?

Thank you in advance.

image
image359×610 12.1 KB

2

Hi @Agustinzs,

Can you please:

  1. Tell us which EasyMorph version you are currently using.
  2. Do a right mouse click on the error message, choose "Copy diagnostics information to Clipboard" and post the copied text here.
3

Hi @andrew.rybka,

  1. I'm using version 6.0.1.3 which I downloaded yesterday.
  2. Source: action "SharePoint command", module "ParcheServicio", table "Descarga Archivo"
    Exception: ApiException
    La operación que se intentó realizar está prohibida porque supera el umbral de vista de lista.
    Call stack:
    at Morph.DataDrivers.Integrators.IntegratorRequestService.#=zbFFPuQrvQ_0n8SqPG4CtBr0=.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.Integrators.IntegratorRequestService.#=zzKCJDWL0Ik8EkCnVKhhhT0c=1.MoveNext() --- End of stack trace from previous location --- at Morph.DataDrivers.Integrators.IntegratorRequestService.#=zzKCJDWL0Ik8EkCnVKhhhT0c=1.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.Integrators.IntegratorRequest.#=qldmxIbMotx4wGoeuG9N5e8BMp8cG76Fj0DBxpo62e7LFcAIoHCIZrUMMuQ1r_QNbv6myul3jXcq062kDmfvnfAVo796Zp6IPFsdrayo9CFc=.MoveNext()
    --- End of stack trace from previous location ---
    at #=zVJGrOciJs3Ds7OvNJUUiSR4JxpDBR$1E0v2N4LLSQ2OBZXSb8b_5LcA=.#=zJ4s7FOhxRS90NFdycg==`1.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.SharePoint.SharePointCommandDriver.#=zh3X$9FUUPb06fllSCA==.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.FileTransfer.Handlers.SharePointFileTransferHandler.#=zyy5Vq49WZqGoaC$Pww==.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.FileTransfer.Service.FileTransferClient.#=zkWXux17Qw2H_O5CQxhjswh4=.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.FileTransfer.Service.FileTransferClient.#=z1s2zfv_daCZ3BHFmHA==.MoveNext()
    --- End of stack trace from previous location ---
    at Morph.DataDrivers.SharePoint.SharePointCommandDriver.#=zrBC_FmQX2$M$oL1z0A==.MoveNext()
4

@Agustinzs, thank you for the details. We are looking into this issue.

5

Hi Andrew,

is there anything we can do to help with the diagnostics? One of our clients has a lot of ETLs frozen because of it. Happy to help in any way we can!

Best,

Albert

6

Hi Albert,

Thank you for the offer. We were able to replicate the issue. Looks like the reason for this error is a large number of files. We are looking for a workaround.

7

Hi @andrew.rybka,

In addition to the error already mentioned, I have another one related to SharePoint's action, using a different connector that does indeed have fewer files. It works, but it's only retrieving 100 files, even though the selected folder contains 519.

image
image364×508 10.3 KB

image
image524×748 26.9 KB

8

@Agustinzs, thank you for the update.

9

Hi @andrew.rybka,

I just updated and the error persists. Have they been able to find any alternative or possible solution?

I await your reply.

10

Hi @Agustinzs, we have found the fix for the issue, but we haven't released the updated version yet. Hopefully, the fix will be available by the end of the day.

11

@AlbertFabritius, @Agustinzs, the issue has been fixed. You can get the updated Desktop and Hub versions on the corresponding download pages on our website.