Connector.Cmd

2.1

public/GetErrorItems.ps1

                                <#

.Synopsis

Function to retrieve item errors for a specified connection using custom PowerShell commands.

.Description

The Get-ErrorItems function is designed to obtain and log item errors for a specified connection in a .csv file. It utilizes custom PowerShell commands such as Start-TranscriptLog, WriteExceptionToOutputFile, WriteErrorBatchToOutputFile, InitializeOutputFile, and Call-Url. The function retrieves errors in batches, handles token expiration, and writes error details to an output file.

.Function Get-ErrorItems

This function retrieves item errors for a specified connection and logs them in an output file. It supports parameters for ConnectionId, OutputFile, BatchLimit, and Torus.

.Parameters

- ConnectionId: Mandatory parameter specifying the connection ID for which item errors are to be retrieved.

- OutputFile: Optional parameter defining the output file for storing error details. Defaults to "Get-ErrorItems" if not provided.

- BatchLimit: Optional parameter determining the batch size for error retrieval. User input is prompted if not provided or if an invalid value is given.

- Torus: Optional switch parameter indicating Torus usage.

.Notes

- Error details are written to the specified output file in CSV format.

#>

function WriteExceptionToOutputFile {

    param (

        $errorMessage,

        $fileName

    )

    $errorMessage | Add-Content -Path $fileName

}

function WriteErrorBatchToOutputFile {

    param (

        $errorsBatch,

        $fileName

    )

    Foreach ($error in $errorsBatch.errors) 

    {

        $outputLine = Get-Date($error.timeStamp) -UFormat "%m/%d/%Y %T"

        $outputLine = $outputLine +","+ $error.displayText +","+ $errorsBatch.Code +","+ $error.detailedCode +',"'+ $errorsBatch.message +'"'

        $outputLine | Add-Content -Path $fileName

    }

}

function InitializeOutputFile {

    param (

        $fileName

    )

    "Time,Path,Error Code,Detailed Error Code,Message" | Set-Content -Path $fileName

}

function Get-ErrorItems{

    param(

        # Connection Id

        [Parameter(Mandatory=$true)]

        [string]

        $ConnectionId,

        [Parameter(Mandatory=$false)]

        [string]

        $OutputFile,

        # Batch Limit

        [Parameter(Mandatory=$false)]

        [int]

        $BatchLimit,

        # Torus Check

        [Parameter(Mandatory=$false)]

        [switch]

        $Torus

    )

    $CommandType = "Get-ErrorItems"

    $OutputFile = Start-TranscriptLog -CommandType $CommandType -OutputFile $OutputFile -ConnectionId $ConnectionId 

    # converting file name to csv to write errors

    $OutputFile = "$OutputFile.csv"

    # Check if the BatchLimit is not provided or is 0

    if (-not ($BatchLimit) -or ($BatchLimit -lt 1) -or ($BatchLimit -gt 5000))

    {

        $validInput = $false

        # Prompt the user for input until a valid integer greater than 0 is provided

        while (-not $validInput)

        {

            $tempBatchLimit = Read-Host "BatchLimit(range 1-5000) (press Enter to use the default value '250')"

            # If the user just presses Enter, use the default value

            if (-not ($tempBatchLimit))

            {

                $BatchLimit = 250

                $validInput = $true

            }

            else

            {

                # Try to parse the user input as an integer

                $parsedTempBatchLimit = 0

                if ([System.Int32]::TryParse($tempBatchLimit, [ref]$parsedTempBatchLimit) -and $parsedTempBatchLimit -gt 0 -and $parsedTempBatchLimit -lt 5001)

                {

                    $BatchLimit = $parsedTempBatchLimit

                    $validInput = $true

                }

                else

                {

                    Write-Error "Invalid input. Please enter a valid integer greater than 0."

                }

            }

        }

    }

    try 

    {

        $TokenInfoObj = GetOAuthToken -TenantId $TenantId -Torus:$Torus

        $Token = $TokenInfoObj.Token

        #Initiliazing Output file

        InitializeOutputFile -FileName $OutputFile

        $ErrorUrlPath = "/v1.0/admin/datasets/$ConnectionId/errors"

        # Get the list of Error Codes

        $errorCodesResponse = Call-Url -CommandType Get-ErrorItems -Token $Token -Method "Get" -UrlPath $ErrorUrlPath -TenantId $TokenInfoObj.TenantId | ConvertFrom-Json

        Write-Host "Total Error Count is: $($errorCodesResponse.errorCount)"

        #Initializing variables

        $errorsReceivedSoFar = "0"

        $errorsMissedSoFar = "0"

        $errorsRemaining = $errorCodesResponse.errorCount

        # Get all the error items for each error code

        Foreach($errorCode in $errorCodesResponse.errorCodes)

        {

            $currentErrorCode = $errorCode.code

            $currentOffset = "0"

            $currentErrorCodeCount = $errorCode.count

            $errorsReceivedForCurrentErrorCode = "0"

            $errorsMissedForCurrentErrorCode = "0"

            Write-Host "Current Error Code: $currentErrorCode, Total Count: $currentErrorCodeCount"

            while($currentOffset -ne "-1") 

            {

                Write-Host "Current Offset: $currentOffset"

                # Refresh the token if it has expired for admin

                if(-not $TokenInfoObj.IsTorus){

                    $currentTime = Get-Date

                    $tokenExpiry = $Token.ExpiresOn.LocalDateTime

                    Write-Host "CurrentTime: $currentTime, TokenExpiresOn: $tokenExpiry"

                    # Refresh the token if it's about to expire in the next 5 seconds

                    if ($tokenExpiry -lt ($currentTime.AddSeconds(5))) 

                    {

                        Write-Host "Access token is about to expire. Refreshing..."

                        $Token = Get-MSALTokenWithRetry -IsRefresh $true

                        Write-Host "Access token Refreshed."

                    }

                }

                else{

                    # implement token expire check for torus

                }

                try 

                {

                    $UrlPathGetErrorCode = "/v1.0/admin/datasets/$ConnectionId/errors/$($currentErrorCode)?offset=$($currentOffset)&limit=$($BatchLimit)"

                    Write-Host "Call for ErrorCode - $($currentErrorCode), Offset-  $($currentOffset),  BatchLimit - $($BatchLimit)"

                    $itemErrorsBatchResponse = Call-Url -CommandType Get-ErrorCodeErrors -Token $Token -Method "Get" -UrlPath $UrlPathGetErrorCode -TenantId $TokenInfoObj.TenantId | ConvertFrom-Json

                    WriteErrorBatchToOutputFile -ErrorsBatch $itemErrorsBatchResponse -FileName $OutputFile

                    $currentOffset = $itemErrorsBatchResponse.metaData.nextOffset

                    $errorsReceivedForCurrentErrorCode = [string]([int]$errorsReceivedForCurrentErrorCode + [int]$itemErrorsBatchResponse.metadata.count)

                }

                catch 

                {

                    Write-Warning "Error while getting the batch for offset: $currentOffset. `nSkipping this batch."

                    WriteExceptionToOutputFile -ErrorMessage $_ -FileName $OutputFile

                    if([int]$currentOffset + [int]$BatchLimit -lt $currentErrorCodeCount)

                    {

                        $currentOffset = [string]([int]$currentOffset + [int]$BatchLimit)

                        $errorsMissedForCurrentErrorCode = [string]([int]$errorsMissedForCurrentErrorCode + [int]$BatchLimit)

                    }

                    else

                    {

                        $currentOffset = "-1"

                        $errorsMissedForCurrentErrorCode = [string]([int]$currentErrorCodeCount - [int]$errorsReceivedForCurrentErrorCode)

                    }

                }

                Write-Host "Current Error Code: $currentErrorCode, Errors Received For current error code: $errorsReceivedForCurrentErrorCode, Errors Missed For Current Error Code: $errorsMissedForCurrentErrorCode"

            }

            $errorsReceivedSoFar = [string]([int]$errorsReceivedSoFar + [int]$errorsReceivedForCurrentErrorCode)

            $errorsMissedSoFar = [string]([int]$errorsMissedSoFar + [int]$errorsMissedForCurrentErrorCode)

            $errorsRemaining = [string]([int]$errorCodesResponse.errorCount - ([int]$errorsReceivedSoFar + [int]$errorsMissedSoFar))

            Write-Host "Total Error Count: $($errorCodesResponse.errorCount), Errors remaining: $errorsRemaining, Errors Missed: $errorsMissedSoFar, Errors Received: $errorsReceivedSoFar"

        }

        Write-Host "------- Get Item Errors Success. Errors list Stored in file $($OutputFile) -------"

    } 

    catch 

    {

        Write-Error "Error in running GetErrorItems.ps1 Error message: `n$_`n";

        WriteExceptionToOutputFile -ErrorMessage $_ -FileName $OutputFile

    }

    Stop-TranscriptLog

}

# SIG # Begin signature block

# MIIoZQYJKoZIhvcNAQcCoIIoVjCCKFICAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCA8+eGa3KSZuu8n

# Xl79I4o+R2lMMTig3yGye4gi06MN9KCCDXYwggX0MIID3KADAgECAhMzAAAEhV6Z

# 7A5ZL83XAAAAAASFMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjUwNjE5MTgyMTM3WhcNMjYwNjE3MTgyMTM3WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDASkh1cpvuUqfbqxele7LCSHEamVNBfFE4uY1FkGsAdUF/vnjpE1dnAD9vMOqy

# 5ZO49ILhP4jiP/P2Pn9ao+5TDtKmcQ+pZdzbG7t43yRXJC3nXvTGQroodPi9USQi

# 9rI+0gwuXRKBII7L+k3kMkKLmFrsWUjzgXVCLYa6ZH7BCALAcJWZTwWPoiT4HpqQ

# hJcYLB7pfetAVCeBEVZD8itKQ6QA5/LQR+9X6dlSj4Vxta4JnpxvgSrkjXCz+tlJ

# 67ABZ551lw23RWU1uyfgCfEFhBfiyPR2WSjskPl9ap6qrf8fNQ1sGYun2p4JdXxe

# UAKf1hVa/3TQXjvPTiRXCnJPAgMBAAGjggFzMIIBbzAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUuCZyGiCuLYE0aU7j5TFqY05kko0w

# RQYDVR0RBD4wPKQ6MDgxHjAcBgNVBAsTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEW

# MBQGA1UEBRMNMjMwMDEyKzUwNTM1OTAfBgNVHSMEGDAWgBRIbmTlUAXTgqoXNzci

# tW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8vd3d3Lm1pY3Jvc29mdC5j

# b20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3JsMGEG

# CCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDovL3d3dy5taWNyb3NvZnQu

# Y29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3J0

# MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIBACjmqAp2Ci4sTHZci+qk

# tEAKsFk5HNVGKyWR2rFGXsd7cggZ04H5U4SV0fAL6fOE9dLvt4I7HBHLhpGdE5Uj

# Ly4NxLTG2bDAkeAVmxmd2uKWVGKym1aarDxXfv3GCN4mRX+Pn4c+py3S/6Kkt5eS

# DAIIsrzKw3Kh2SW1hCwXX/k1v4b+NH1Fjl+i/xPJspXCFuZB4aC5FLT5fgbRKqns

# WeAdn8DsrYQhT3QXLt6Nv3/dMzv7G/Cdpbdcoul8FYl+t3dmXM+SIClC3l2ae0wO

# lNrQ42yQEycuPU5OoqLT85jsZ7+4CaScfFINlO7l7Y7r/xauqHbSPQ1r3oIC+e71

# 5s2G3ClZa3y99aYx2lnXYe1srcrIx8NAXTViiypXVn9ZGmEkfNcfDiqGQwkml5z9

# nm3pWiBZ69adaBBbAFEjyJG4y0a76bel/4sDCVvaZzLM3TFbxVO9BQrjZRtbJZbk

# C3XArpLqZSfx53SuYdddxPX8pvcqFuEu8wcUeD05t9xNbJ4TtdAECJlEi0vvBxlm

# M5tzFXy2qZeqPMXHSQYqPgZ9jvScZ6NwznFD0+33kbzyhOSz/WuGbAu4cHZG8gKn

# lQVT4uA2Diex9DMs2WHiokNknYlLoUeWXW1QrJLpqO82TLyKTbBM/oZHAdIc0kzo

# STro9b3+vjn2809D0+SOOCVZMIIHejCCBWKgAwIBAgIKYQ6Q0gAAAAAAAzANBgkq

# hkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5

# IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEwOTA5WjB+MQswCQYDVQQG

# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG

# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYDVQQDEx9NaWNyb3NvZnQg

# Q29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC

# CgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+laUKq4BjgaBEm6f8MMHt03

# a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc6Whe0t+bU7IKLMOv2akr

# rnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4Ddato88tt8zpcoRb0Rrrg

# OGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+lD3v++MrWhAfTVYoonpy

# 4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nkkDstrjNYxbc+/jLTswM9

# sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6A4aN91/w0FK/jJSHvMAh

# dCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmdX4jiJV3TIUs+UsS1Vz8k

# A/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL5zmhD+kjSbwYuER8ReTB

# w3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zdsGbiwZeBe+3W7UvnSSmn

# Eyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3T8HhhUSJxAlMxdSlQy90

# lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS4NaIjAsCAwEAAaOCAe0w

# ggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRIbmTlUAXTgqoXNzcitW2o

# ynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMCAYYwDwYD

# VR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBDuRQFTuHqp8cx0SOJNDBa

# BgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2Ny

# bC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3JsMF4GCCsG

# AQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3dy5taWNyb3NvZnQuY29t

# L3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3J0MIGfBgNV

# HSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEFBQcCARYzaHR0cDovL3d3

# dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1hcnljcHMuaHRtMEAGCCsG

# AQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkAYwB5AF8AcwB0AGEAdABl

# AG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn8oalmOBUeRou09h0ZyKb

# C5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7v0epo/Np22O/IjWll11l

# hJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0bpdS1HXeUOeLpZMlEPXh6

# I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/KmtYSWMfCWluWpiW5IP0

# wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvyCInWH8MyGOLwxS3OW560

# STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBpmLJZiWhub6e3dMNABQam

# ASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJihsMdYzaXht/a8/jyFqGa

# J+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYbBL7fQccOKO7eZS/sl/ah

# XJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbSoqKfenoi+kiVH6v7RyOA

# 9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sLgOppO6/8MO0ETI7f33Vt

# Y5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtXcVZOSEXAQsmbdlsKgEhr

# /Xmfwb1tbWrJUnMTDXpQzTGCGkUwghpBAgEBMIGVMH4xCzAJBgNVBAYTAlVTMRMw

# EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN

# aWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNp

# Z25pbmcgUENBIDIwMTECEzMAAASFXpnsDlkvzdcAAAAABIUwDQYJYIZIAWUDBAIB

# BQCggeYwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEO

# MAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIFKMLbopkqA3UStTXEo0A9Da

# hYvm5JVLNhpVasdi0jR5MHoGCisGAQQBgjcCAQwxbDBqoEyASgBNAGkAYwByAG8A

# cwBvAGYAdAAuAEcAcgBhAHAAaAAuAEMAbwBuAG4AZQBjAHQAbwByAHMALgBDAG0A

# ZABsAGUAdAAuAGQAbABsoRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTANBgkq

# hkiG9w0BAQEFAASCAQB7xNuu+wTP5MV0xVKlBtBbtPyJ4xegup9y73v5oFnaV1wv

# 6mirZWve0iVFHZq3pCphx9Nzad+nL3ha8XDLPQ84deZ7lLazP9XCyW2Z4g076M+H

# WZ5njLrDflO5MJyj2C5e9GoG5aHgZfrN48YRDSWd3B0GSdO0jDEBS1BWGMapqmvo

# Dm0Q/49EyN0NpQsugZU8PlJXPnCDpiGrqRwj76TZnfIX76SZWFJpbCKHW6Z0+66J

# LhplFPKsgLu5hrNnkZB4d8Gs+iyOFiTphCWrK6i1DrEakfiUE1ijQUA3f82eDf5S

# aIGBjbRyJx2AzKE5RpOkDIGr6Dvr/XX07lhk66gdoYIXlzCCF5MGCisGAQQBgjcD

# AwExgheDMIIXfwYJKoZIhvcNAQcCoIIXcDCCF2wCAQMxDzANBglghkgBZQMEAgEF

# ADCCAVIGCyqGSIb3DQEJEAEEoIIBQQSCAT0wggE5AgEBBgorBgEEAYRZCgMBMDEw

# DQYJYIZIAWUDBAIBBQAEIGSpFw4nwiWScyg5pywWElcWuaIPGJ8X0qFQ3L630ahI

# AgZpwU19F28YEzIwMjYwNDA2MTM0NjI0LjY2OVowBIACAfSggdGkgc4wgcsxCzAJ

# BgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25k

# MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJTAjBgNVBAsTHE1pY3Jv

# c29mdCBBbWVyaWNhIE9wZXJhdGlvbnMxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVT

# TjozNzAzLTA1RTAtRDk0NzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAg

# U2VydmljZaCCEe0wggcgMIIFCKADAgECAhMzAAACHzpwaeSiMC6VAAEAAAIfMA0G

# CSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u

# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp

# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMB4XDTI2

# MDIxOTE5Mzk1MVoXDTI3MDUxNzE5Mzk1MVowgcsxCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xJTAjBgNVBAsTHE1pY3Jvc29mdCBBbWVyaWNhIE9w

# ZXJhdGlvbnMxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjozNzAzLTA1RTAtRDk0

# NzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZTCCAiIwDQYJ

# KoZIhvcNAQEBBQADggIPADCCAgoCggIBAMs7xcU5x8aoCqCLPT4CZCYWXd1nRpMb

# hQUmSqo10wfLbwNqF4IGzo425+6TJ7nHjYJaTOBEjL2QTZVbASe1nxmSDKvKQLRs

# iqwgPv7oXGC6x5Nd/VXC+bUPzXThWZ62gEmUni4Zu7IllS9cPHnmdWHnTKAtPNnb

# haRCyc+m9Fm/aQ9zf1/duEvIdW2cexr9b/zpWt+134B8W94D6o38Rj5caPlz8M8x

# cJgQJvRqthv3Z0Mla3DOnIGuniB8eWBjVQSlziXgAYQut/YnjCvFPNNb5IzxeFXV

# 044+tiMPTzQhtmovwH4gXREJ2fbr1hesYrpAgeKnOcplwJLyM3fRgAedMlU3lnOz

# q3/ZiyoEYOq68Np3v3fgUVPDO9Rw7dWgjJ33ddbC8/z9IIVUmHbVbygZBOm0YfKX

# L4WXiF6dUxVkXW/qiw62KtfwYVOISGd/ydF06DvJlgAnTHL0K0N9tdpOf9x/curc

# 38YJgoWML7mZQIT4AmGbEy4x29JQaYqIAV2I8CNROqxZYEFkmbR4LCB4YkWaZAD5

# Xv/3wEpwT6BQvs715ZENDAp4By+jqvE2/ZjiMqscDpn/CLdr98pSEsI1kRLyoZ2u

# kMCbuqH7oWNjHK0BuSIozq5M3L9Qs+XC2VhmgAkMNA/t5gLLDBVs1NsddEFJL41x

# wLSxIHhbtTrvAgMBAAGjggFJMIIBRTAdBgNVHQ4EFgQU2TvawYOUfSvkPC98ZHlf

# AkjwHtswHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIwXwYDVR0fBFgw

# VjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jcmwvTWlj

# cm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3JsMGwGCCsGAQUF

# BwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3Br

# aW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIwMjAxMCgx

# KS5jcnQwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcDCDAOBgNV

# HQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBAGVu7cijKec/PQrWI9t42ex6

# PZvXmXmx2XYUAUEEZP2VF1zaA1XwsAi6w9gceFS9ENyzHiVsw2FUo8a7hMMtqo23

# 8Ij5IW0a6p1EulU/VcT1wIvIqso+lwkUkKo+lX55+gC1gGYhRBzHHBPtYhDuBqDz

# 6uQq+syQKhGopLSYq/wnWwp+Lzn4ba6Fn/VG15JV1hk5k6P5JvjDOidMJOPsS2Aw

# 38Ffflbl1PN3vAl0Z6liRWLzvV1KsLZOvVkXMBHtLjh2sJZmknqmElptU06w3EUk

# qBLKS6A4ZbNDfXxGvcxM+DazcGez6lQ9WAyKN3htQ4fYGUSwswzA5yiVNNmqDUdi

# t1jWPGlQAj2KmMFBEg0v87vTln79/YuM2YlCigJUlVfbhp2lnnX1Kx9rMaipca33

# VuaoqjR8jT0iXixQeHiKHqumJAMGXIvu+a8J6PBXFh69jipXBNn+jeC+X5HSUXFh

# L194gzg14bT5awNnuMtyLkwV643CixBjfPbpeDWiPRT276dxH25NT7EGYnwG2UJ2

# FDXdE0xfk/6StFg8HdcKn0mbpdo7X33mrfYAhmbWbMEYjrIeW+JdoQLlPMaI7Ute

# 4+1dlTZf3ehAlsyh7e/z7kI8qtBqUZbJi6HZrdXWnBuP5bQUSYQU+m7xMj6pg7Ug

# hBZRJG8WNe2Hk5vTaEwyMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJmQAAAAAA

# FTANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hp

# bmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jw

# b3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0

# aG9yaXR5IDIwMTAwHhcNMjEwOTMwMTgyMjI1WhcNMzAwOTMwMTgzMjI1WjB8MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNy

# b3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCAiIwDQYJKoZIhvcNAQEBBQADggIP

# ADCCAgoCggIBAOThpkzntHIhC3miy9ckeb0O1YLT/e6cBwfSqWxOdcjKNVf2AX9s

# SuDivbk+F2Az/1xPx2b3lVNxWuJ+Slr+uDZnhUYjDLWNE893MsAQGOhgfWpSg0S3

# po5GawcU88V29YZQ3MFEyHFcUTE3oAo4bo3t1w/YJlN8OWECesSq/XJprx2rrPY2

# vjUmZNqYO7oaezOtgFt+jBAcnVL+tuhiJdxqD89d9P6OU8/W7IVWTe/dvI2k45GP

# sjksUZzpcGkNyjYtcI4xyDUoveO0hyTD4MmPfrVUj9z6BVWYbWg7mka97aSueik3

# rMvrg0XnRm7KMtXAhjBcTyziYrLNueKNiOSWrAFKu75xqRdbZ2De+JKRHh09/SDP

# c31BmkZ1zcRfNN0Sidb9pSB9fvzZnkXftnIv231fgLrbqn427DZM9ituqBJR6L8F

# A6PRc6ZNN3SUHDSCD/AQ8rdHGO2n6Jl8P0zbr17C89XYcz1DTsEzOUyOArxCaC4Q

# 6oRRRuLRvWoYWmEBc8pnol7XKHYC4jMYctenIPDC+hIK12NvDMk2ZItboKaDIV1f

# MHSRlJTYuVD5C4lh8zYGNRiER9vcG9H9stQcxWv2XFJRXRLbJbqvUAV6bMURHXLv

# jflSxIUXk8A8FdsaN8cIFRg/eKtFtvUeh17aj54WcmnGrnu3tz5q4i6tAgMBAAGj

# ggHdMIIB2TASBgkrBgEEAYI3FQEEBQIDAQABMCMGCSsGAQQBgjcVAgQWBBQqp1L+

# ZMSavoKRPEY1Kc8Q/y8E7jAdBgNVHQ4EFgQUn6cVXQBeYl2D9OXSZacbUzUZ6XIw

# XAYDVR0gBFUwUzBRBgwrBgEEAYI3TIN9AQEwQTA/BggrBgEFBQcCARYzaHR0cDov

# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1JlcG9zaXRvcnkuaHRtMBMG

# A1UdJQQMMAoGCCsGAQUFBwMIMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsG

# A1UdDwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFNX2VsuP6KJc

# YmjRPZSQW9fOmhjEMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9jcmwubWljcm9z

# b2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIz

# LmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6Ly93d3cubWlj

# cm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3J0

# MA0GCSqGSIb3DQEBCwUAA4ICAQCdVX38Kq3hLB9nATEkW+Geckv8qW/qXBS2Pk5H

# ZHixBpOXPTEztTnXwnE2P9pkbHzQdTltuw8x5MKP+2zRoZQYIu7pZmc6U03dmLq2

# HnjYNi6cqYJWAAOwBb6J6Gngugnue99qb74py27YP0h1AdkY3m2CDPVtI1TkeFN1

# JFe53Z/zjj3G82jfZfakVqr3lbYoVSfQJL1AoL8ZthISEV09J+BAljis9/kpicO8

# F7BUhUKz/AyeixmJ5/ALaoHCgRlCGVJ1ijbCHcNhcy4sa3tuPywJeBTpkbKpW99J

# o3QMvOyRgNI95ko+ZjtPu4b6MhrZlvSP9pEB9s7GdP32THJvEKt1MMU0sHrYUP4K

# WN1APMdUbZ1jdEgssU5HLcEUBHG/ZPkkvnNtyo4JvbMBV0lUZNlz138eW0QBjloZ

# kWsNn6Qo3GcZKCS6OEuabvshVGtqRRFHqfG3rsjoiV5PndLQTHa1V1QJsWkBRH58

# oWFsc/4Ku+xBZj1p/cvBQUl+fpO+y/g75LcVv7TOPqUxUYS8vwLBgqJ7Fx0ViY1w

# /ue10CgaiQuPNtq6TPmb/wrpNPgkNWcr4A245oyZ1uEi6vAnQj0llOZ0dFtq0Z4+

# 7X6gMTN9vMvpe784cETRkPHIqzqKOghif9lwY1NNje6CbaUFEMFxBmoQtB1VM1iz

# oXBm8qGCA1AwggI4AgEBMIH5oYHRpIHOMIHLMQswCQYDVQQGEwJVUzETMBEGA1UE

# CBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9z

# b2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1lcmljYSBPcGVy

# YXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRTUyBFU046MzcwMy0wNUUwLUQ5NDcx

# JTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNlcnZpY2WiIwoBATAHBgUr

# DgMCGgMVAEsgyDU/uw24JemZsfYhdPa1d4QQoIGDMIGApH4wfDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp

# bWUtU3RhbXAgUENBIDIwMTAwDQYJKoZIhvcNAQELBQACBQDtfZYVMCIYDzIwMjYw

# NDA2MDIxNjUzWhgPMjAyNjA0MDcwMjE2NTNaMHcwPQYKKwYBBAGEWQoEATEvMC0w

# CgIFAO19lhUCAQAwCgIBAAICFT8CAf8wBwIBAAICEpQwCgIFAO1+55UCAQAwNgYK

# KwYBBAGEWQoEAjEoMCYwDAYKKwYBBAGEWQoDAqAKMAgCAQACAwehIKEKMAgCAQAC

# AwGGoDANBgkqhkiG9w0BAQsFAAOCAQEAip+T6QjZfnJW6X/CeERcEq9tWd0O5MwY

# sJ95YEjtNXoPMyTYvn3teQi0DfhQ6WMLe6qob2jKS1AlH4+at2nzZgy0xZETEs62

# BOz+CRz6jJTra4zvD1GOZrc6xT/YEONeQSJDyU4p+oEKJlHuB1xe+1Pf6bZr769R

# 8uj4V/Cd9kqc+ITYPfPoNpZrRuR+raDigYvwpVXN+BAYzzFH/NxiZyx+iA51rJ3N

# wY/4UhACHpXZhaM2Jl5SYyouFidRC6JD5alejpiwfbCtU4M5HtXkScg5z/7oN7cl

# srPf9QJ+SG2URRsRvVjuwfHPpidjQpMqfG6XFMfWDNANI0PX7Z/DfjGCBA0wggQJ

# AgEBMIGTMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD

# VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAk

# BgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAACHzpwaeSi

# MC6VAAEAAAIfMA0GCWCGSAFlAwQCAQUAoIIBSjAaBgkqhkiG9w0BCQMxDQYLKoZI

# hvcNAQkQAQQwLwYJKoZIhvcNAQkEMSIEIBXCGO4AHdChMCbD4f0ad88y7mhm/cuh

# u64twZsAQOMuMIH6BgsqhkiG9w0BCRACLzGB6jCB5zCB5DCBvQQgsCQK31aQKwy1

# RGQW7pNjQ/dRd1GcKJi49mF7fKQt/BQwgZgwgYCkfjB8MQswCQYDVQQGEwJVUzET

# MBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMV

# TWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1T

# dGFtcCBQQ0EgMjAxMAITMwAAAh86cGnkojAulQABAAACHzAiBCAjN5D3KfQCWmCj

# e/GhA2xE+4doRqAYeLTizPT/xSpTkzANBgkqhkiG9w0BAQsFAASCAgCCtJrJcnis

# DlOWRTJMNP94Ya79+E7Se1y3XhyD3Y8OZ/yRCsI4f0e7QgwHCsvbbG81611IGPIL

# t7OnC5Np2uDHUjJO6c25+BBWmpH3Eq3UqSyuvVzg0g9F/h+fAtvrBCVOcesjkd5l

# yPN2fHKq9dWIWQqYwsK5D8x8IfgG6s4D9H7A8YZo4W8IoJ1i2UAmpj7Niw9YH0h4

# dYdX0XZ0cNjE9gCb/UkdRliqK6QHKcef/8ywZGZKgqkwroMAVdTf02dyFawZ3g94

# kxwy2aL06PTEj1Inzeibdecs1uzM8MDXLYsqs1IKdQDXri9sesx9a4Miju3xspbc

# KN4qCLkgQTQM/a52DgCO3QbE1uUcNoAhMniVSvvaX67F3tVDM5NAzQoV93AxBe3z

# OZFflLVFFxHXfjm+Vaue3YrMtPg7w6Tz5QxzxQT6E6nbLaDxzpZ6iEPtrGqgHT2E

# RWdtqeLHh/Wrw0187n7cfBCL1vQMlwXSmWsLoXKYmYkuZwhcELb+8Hu4t0acqsn+

# 472UOBDA3R+9zo0neRKRlrWFEwGpJhu22hAIeVXz4D47/Y2qVm/lwfEPtJD5Lp4Y

# X8gL3JDmJpdwdEaUjyaqmDsUoH6Yu6hfu1asTE/68V1xbIL25IJQgWIqmuyNuT9Z

# RQQk4itQbrZHt/6LEUuhYgZ0tN7NgwAhqg==

# SIG # End signature block