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.

1{
2If ($adminUser)
3    {
4    Invoke-Sqlcmd `
5                -QueryTimeout 1000 `
6        -serverInstance $($server) `
7        -Username $($adminUser) `
8        -Password $($adminPass) `
9        -Database $($dbName) `
10        -InputFile ".\FSM_570_MetadataInsert_2.sql" `
11        -ErrorAction stop `
12        -Verbose > ".\metadata_2.log" 4>&1
13    }
14Else
15    {
16    Invoke-Sqlcmd `
17                -QueryTimeout 1000 `
18        -serverInstance $($server) `
19        -Database $($dbName) `
20        -InputFile ".\FSM_570_MetadataInsert_2.sql" `
21        -ErrorAction stop `
22        -Verbose > ".\metadata_2.log" 4>&1
23    }
24}