Switching Between Microsoft VBScript Engine and Native Script Engine

To switch between script engines:

Parameter - ScriptEngineType:

  • 0 - Native Engine
  • 1 - Microsoft Engine (Default)

Verify if the ScriptEngineType parameter is present on the Settings page. If the parameter is missing, you must add it by executing the appropriate SQL scripts on the corresponding database.

Oracle Database

INSERT INTO XFM_PARAMETERS_DEFAULTS (Name,Type,Hidden,Validation,Description,DefaultValue) VALUES ('ScriptEngineType','1','0','','Set Native or Microsoft Script Engine','1');
INSERT INTO XFM_PARAMETERS (ParameterName, ClusterName, ServerName, ApplicationName, CategoryName, CreatedOn, UpdatedOn, CreatedBy, UpdatedBy, Value) SELECT Name, 'ALL','ALL','ALL','ALL', SYSDATE, SYSDATE, 'system', 'system', DefaultValue FROM XFM_PARAMETERS_DEFAULTS WHERE NOT EXISTS ( SELECT * FROM XFM_PARAMETERS WHERE Name = ParameterName );

SQL Server Database

INSERT INTO XFM_PARAMETERS_DEFAULTS (Name,Type,Hidden,Validation,Description,DefaultValue) VALUES ('ScriptEngineType','1','0','','Set Native or Microsoft Script Engine','1');
INSERT INTO XFM_PARAMETERS (ParameterName, ClusterName, ServerName, ApplicationName, CategoryName, CreatedOn, UpdatedOn, CreatedBy, UpdatedBy, Value) SELECT Name, 'ALL','ALL','ALL','ALL', GETDATE(), GETDATE(), 'system', 'system', DefaultValue from XFM_PARAMETERS_DEFAULTS  WHERE NOT EXISTS ( SELECT * FROM XFM_PARAMETERS WHERE Name = ParameterName );

Note:

  • Ensure that no ofmserver.exe processes are running before switching the script engine.

  • After switching, launch the HFM application to proceed.