In the 188.8.131.52 and lower releases of the database cartridge the SQL PI repository cannot be created on an Azure SQL Managed Instance.
Failed to create PI repository on Azure SQL Managed instance by specifying files in CREATE DATABASE statement and filegroups
This workaround has been logged as hotfix FDH-58 and is applicable for SQL Server v184.108.40.206/v220.127.116.11 and Oracle/Azure v18.104.22.168. After applying the workaround below, the database cartridges will be able to deploy the SQL PI repository on an Azure SQL Managed Instance via the setup wizard.
Backup the WCF module
Open a command line on the FMS and run the following two commands. Replace "foglight" in each line with the foglight administrator account username and password.
Import the WCF module into the FMS from a command line on the FMS
Deploy the jar file to the FMS
Backup the jar file spi-common-utils-1.16.0.jar from the jar folder.
Replace the jar file spi-common-utils-1.16.0.jar in following paths:
Then Restart the FMS
Deploy jar file on FglAM
Backup the jar file spi-common-utils-1.16.0.jar from the path mentioned in next step.
For Foglight Agent Managers deployed with database agents and Foglight Agent Managers deployed with a Domain manager agent, replace the jar file spi-common-utils-1.16.0.jar in the path:
Then restart the FglAM
This issue has been logged as defect FOG-620 and has been fixed in the 22.214.171.124 and higher releases of the Foglight Database cartridges.