search

microsoft / Code-Search

Code Search Admin scripts (SQL and PS) for managing a Code Search on-prem instance
53 stars 68 forks source link

Azure_DevOps_Server_2019/ReIndexFiles.ps1 #93

Open MarRich1 opened 10 months ago

MarRich1 commented 10 months ago

Has somebody already ran this script ;)

Invoke-Sqlcmd : Procedure or function 'prc_MergeFileLevelFailures' expects parameter '@maxFailureThreshold', which was not supplied.
At C:\Code-Search\Azure_DevOps_Server_2019\ReIndexFiles.ps1:67 char:21
+ ... ryResults = Invoke-Sqlcmd -InputFile $SqlFullPath -serverInstance $SQ ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
    + FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

prc_MergeFileLevelFailures parameters:

-- Hash: 66F9F9467AC87713D89D5AB3A184B27B3A12FB6D
ALTER PROCEDURE [Search].[prc_MergeFileLevelFailures]
(
    @partitionId               INT,
    @indexingUnitId            INT,
    @fileLevelFailureRecords   Search.typ_FileFailureRecord READONLY,
    @maxFailureThreshold       INT
)