The Powershell command running and getting timeout during the FSM installation during the deployment of MetadataInsert_2.sql.
Page 1 / 1
Hi
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.