Skip to main content

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

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


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

 


Reply