Cannot download from Tune SQL in PI is agent has parentheses in the name
説明
Foglight displayed an error “File to download is null” when queries Top SQL in SQL PI and selects Tune SQL. The file cannot be downloaded normally.
原因
The issue occurs if the agent name has a parenthesis () in the name. A null file is created and a message appears in the top right corner of the UI.
対策
The issue has been logged as defect FOG-5849 and fixed by replacing the existing handleEscapeStr script. Function location to replace is under Configuration | Definitions | Databases | SQL Server | Global Administration | _Override Functions. Refer to screenshot
Replace this function with attached handleEscapeStr.groovy script.
STATUS
This issue has been logged as defect FOG-5849 and has been fixed in the 7.1.0.10 and higher releases of the Foglight for SQL Server cartridge.