Retour
-
Titre
Cannot enable SQL PI for Azure SQL agents when using an AAD user -
Description
Monitoring Azure SQL with SQL PI fails when using an AAD (Azure Active Directory) account.
The following error appears when trying to enable PI with an AAD user.
ERROR [dbwhcjsbsv-4] script.system:dbwc_azure_installer_spi.enableSPI - No such property: authMode for class: system._dbwc_azure_installer_spi.scripts.enableSPIgroovy.lang.MissingPropertyException: No such property: authMode for class: system._dbwc_azure_installer_spi.scripts.enableSPIat org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:53)at org.codehaus.groovy.runtime.callsite.PogoGetPropertySite.getProperty(PogoGetPropertySite.java:52)at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callGroovyObjectGetProperty(AbstractCallSite.java:307)at system._dbwc_azure_installer_spi.scripts.enableSPI.createDBCredentialsRequest(enableSPI:227) -
Résolution
WORKAROUND
Upgrade to the 5.9.7.20 Azure SQL cartridge and replace the function content with the script below.
- Navigate to Configuration | Data
- Open the definition under Databases | Azure | installer | SPI
- Change the pulldown to Functions
- Search for enableSPI
- Click the Edit button
- Back up the existing content to a text file
- Replace the script content from the attached enableSPI.groovy
- Save the changes
Retry to install\enable PI for the Azure SQL instance
STATUS
This issue was logged as defect FOG-1993 and has been fixed in the 6.0.0.10 release of the Azure SQL cartridge.
-
Identifiant du défaut
FOG-1993