Pessoal estou com problema para foreach para lista externa via powershell, alguém pode me ajudar por favor ?
Segue erro e código abaixo:
An error occurred while enumerating through a collection: The shim execution failed unexpectedly - Could not
load file or assembly 'System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561
934e089' or one of its dependencies. Either a required impersonation level was not provided, or the provided
impersonation level is invalid. (Exception from HRESULT: 0x80070542)..
At line:8 char:15
+ foreach <<<< ($item2 in $listExterna.Items){
+ CategoryInfo : InvalidOperation: (Microsoft.Share...tanceEnumerator:SPEntityInstanceEnumerat
or) [], RuntimeException
+ FullyQualifiedErrorId : BadEnumeration
---- código----
$ctx = Get-SPServiceContext servidor
$scope = New-Object Microsoft.SharePoint.SPServiceContextScope $ctx
$web = Get-SPWeb "site"
$list = $web.Lists["ListaAprovaDiretor"]
$listExterna = $web.Lists["listaexternateste"]
foreach($item in $list.Items){
foreach($item2 in $listExterna.Items){
if($item["Nr_Ordem_1"] -eq $item2["Nr_Ordem_de_Compra"])
{
$item["Status_1"] = $item2["Status_Ordem_de_Compra"]
$item["Dias_1"] = $item2["Dias_para_Entrega"]
$item.Update();
}
}
}
