The Powershell command running and getting timeout during the FSM installation

Hi @SanjeewaJ ,

I was able to resolve my issue by adding “-QueryTimeout 1000 `” line in FSM_Upgrade.ps1 script. 

I’ll update you post as well you can try it.

{
If ($adminUser)
    {
    Invoke-Sqlcmd `
                -QueryTimeout 1000 `
        -serverInstance $($server) `
        -Username $($adminUser) `
        -Password $($adminPass) `
        -Database $($dbName) `
        -InputFile ".\FSM_570_MetadataInsert_2.sql" `
        -ErrorAction stop `
        -Verbose > ".\metadata_2.log" 4>&1
    }
Else
    {
    Invoke-Sqlcmd `
                -QueryTimeout 1000 `
        -serverInstance $($server) `
        -Database $($dbName) `
        -InputFile ".\FSM_570_MetadataInsert_2.sql" `
        -ErrorAction stop `
        -Verbose > ".\metadata_2.log" 4>&1
    }
}