-
Titolo
SQL Error log entries fail to match or ignore due to special character -
Descrizione
Customers reported a problem where a sql error alarm would not match or ignore the provided text, example below:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
-
Causa
After extensive testing we have identified the cause of the issue to be the special characters "[" or "]" (square bracket), this has been logged under Defect ID SES-2051.
-
Risoluzione
WORKAROUND:
Replace any squre bracket character "[" or "]" with the "%" (percentage sign) as replacement, this will serve as a wildcard allowing for the match or ignore to happen successfully.
Before:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]After:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. %CLIENT: <local machine>% -
Informazioni aggiuntive
Dev has identified this issue up until version 15.0 and has planned to address this issue on a future release.