Skip to main content
Solved

The Powershell command running and getting timeout during the FSM installation

  • December 29, 2021
  • 2 replies
  • 197 views
Chathuranga Samarakoon
Hero (Partner)
Forum|alt.badge.img+12

The Powershell command running and getting timeout during the FSM installation during the deployment of MetadataInsert_2.sql.

Best answer by Chathuranga Samarakoon

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
    }
}

 

Chathuranga Samarakoon

2 replies

SanjeewaJ
Superhero (Employee)
Forum|alt.badge.img+12
  • SanjeewaJ
  • Superhero (Employee)
  • 89 replies
  • January 3, 2022

Hi @Chathuranga Samarakoon 

Are you having similar issue as I encountered/reported in below post?

 

I reported a support case (G2305915) and it is being investigated now by GSD.

Please share more details, if similar, we can connect both issues together.

/Sanjeewa

Chathuranga Samarakoon
Hero (Partner)
Forum|alt.badge.img+12

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
    }
}

 

Chathuranga Samarakoon


Terms & ConditionsCookie settingsAccessibility statement