FSM 6 Update 14 On-Prem Installation Error

Is there anyone who could complete FSM6 UPD14 Fresh installation/upgrade in on-prem(SQL server)? Apparently both end up in above error, even with all the pre-requisites are there.

@SanjeewaJ

Adding to the above,

I would suggest in checking with FSM-DB mappings and then a SQL server restart before the DB upgrade.

Br, Aaqil

Hi @SanjeewaJ 

Yes, I installed UPD 14 to my local machine. The issue I encountered was on the power shell command. In my case it was not a fresh installation, but an upgrade from UPD 13. There was no issue in Mobile service.

I’m afraid whether you need to create a new database for FSM, which should be your last resort. 

But before that you could try deleting the existing login and create a new one. Map the FSMDB to the new login. Then provide those details for installation.

As u said it is likely to be an issue with FSM-DB upgrade.

Br, Aaqil

Hi @SanjeewaJ ,

Please try to adding “-QueryTimeout 1000 `” line in FSM_Upgrade.ps1 script. 

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