The following appears in the MID server agent log when the step is activated in the pattern. I could not get this step to execute when used with an SQLexpress server instance.
Caused by error in Ad hoc script 'EvalClosure-set the engine edition by the number' at line 27
The error seems to come from: "MSSql DB On Windows Pattern" in the "set the engine edition by the number" step. The area is rtrn variable which has not been initialized.
Steps to Reproduce
Run discovery against an SQL server and check the mid server agent logs
This problem has been fixed. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.
What is happening:
The variable "serverproperty.engine_num" contains a value, but not one of the choices that are presented in the various IF statements.
At the end, it tries to return 'rtrn', but without a matching choice that variable is never declared/initialized.
The solution is to declare var rtrn = ''; on line 2.
Related Problem: PRB1329290