2018-07-27 10:57:17,501 INFO  [stdout] (DEFAULT task-1) DEBUG [] [] ==>  Preparing: SELECT scenario.id AS scenario_id, scenario.KEY AS scenario_key, scenario.ext_id AS scenario_extid, scenario.status AS scenario_status, scenario.scenario_order AS scenario_order, scenario.active_requested AS active_requested, scenariod.KEY AS default_scenario, scenario.scenario_type AS scenario_type, op_type.NAME AS op_type_name, widget.KEY AS wid, widget_scenario.widget_order AS widget_order_id, widget_scenario.autorun AS widget_autostart, muc.KEY AS mucid, muc.description AS muc_description, method.method_id AS method_name, method.description AS method_description, method.blocked AS method_blocked, method.ext_id AS method_extid, authn_srv.as_id AS authn_srv_name, authn_srv.description AS authn_srv_description FROM asm_scenario scenario LEFT JOIN asm_scenario scenarioD ON scenariod.id = scenario.default_scenario_id LEFT JOIN asm_scenario_op_type op_scenario ON op_scenario.scenario_id = scenario.id LEFT JOIN cmn_operation_type op_type ON op_scenario.operation_type_id = op_type.id LEFT JOIN asm_scenario_widget widget_scenario ON widget_scenario.scenario_id = scenario.id LEFT JOIN asm_widget widget ON widget_scenario.widget_id = widget.id LEFT JOIN asm_muc muc ON muc.widget_id = widget.id LEFT JOIN cmn_method method ON muc.method_id = method.id LEFT JOIN cmn_authn_server authn_srv ON method.authn_server_id = authn_srv.id WHERE scenario.id IN ( SELECT scenario.id AS scenario_id FROM ASM_SCENARIO scenario LEFT JOIN ASM_SCENARIO scenarioD ON scenarioD.ID = scenario.DEFAULT_SCENARIO_ID LEFT JOIN ASM_SCENARIO_WIDGET widget_scenario ON widget_scenario.SCENARIO_ID = scenario.ID LEFT JOIN ASM_WIDGET widget ON widget_scenario.WIDGET_ID = widget.ID LEFT JOIN ASM_MUC muc ON muc.WIDGET_ID = widget.ID LEFT JOIN CMN_METHOD method ON muc.METHOD_ID = method.ID WHERE method.EXT_ID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) MINUS SELECT scenario.id AS scenario_id FROM ASM_SCENARIO scenario LEFT JOIN ASM_SCENARIO scenarioD ON scenarioD.ID = scenario.DEFAULT_SCENARIO_ID LEFT JOIN ASM_SCENARIO_WIDGET widget_scenario ON widget_scenario.SCENARIO_ID = scenario.ID LEFT JOIN ASM_WIDGET widget ON widget_scenario.WIDGET_ID = widget.ID LEFT JOIN ASM_MUC muc ON muc.WIDGET_ID = widget.ID LEFT JOIN CMN_METHOD method ON muc.METHOD_ID = method.ID WHERE method.EXT_ID NOT IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ORDER BY scenario_order, widget_scenario.widget_order  [cz.monetplus.mep.config.fs.mybatis.mapper.ScenarioMapper.getScenariosByExtMethodIds]
2018-07-27 10:57:17,502 INFO  [stdout] (DEFAULT task-1) DEBUG [] [] ==> Parameters:  AM_CSPIN_SMS(String),  AM_SPNEGO(String), AM_TLS(String),  AM_SMS(String),  AM_CSPIN(String),  AM_PWD(String),  AM_ESMS(String),  AM_CERT(String),  AM_AQR(String),  AM_CM(String), AM_DPWD(String),  AM_CSPIN_SMS(String),  AM_SPNEGO(String), AM_TLS(String),  AM_SMS(String),  AM_CSPIN(String),  AM_PWD(String),  AM_ESMS(String),  AM_CERT(String),  AM_AQR(String),  AM_CM(String), AM_DPWD(String) [cz.monetplus.mep.config.fs.mybatis.mapper.ScenarioMapper.getScenariosByExtMethodIds]
2018-07-27 10:57:17,507 INFO  [stdout] (DEFAULT task-1) TRACE [] [] <==    Columns: SCENARIO_ID, SCENARIO_KEY, SCENARIO_EXTID, SCENARIO_STATUS, SCENARIO_ORDER, ACTIVE_REQUESTED, DEFAULT_SCENARIO, SCENARIO_TYPE, OP_TYPE_NAME, WID, WIDGET_ORDER_ID, WIDGET_AUTOSTART, MUCID, MUC_DESCRIPTION, METHOD_NAME, METHOD_DESCRIPTION, METHOD_BLOCKED, METHOD_EXTID, AUTHN_SRV_NAME, AUTHN_SRV_DESCRIPTION [cz.monetplus.mep.config.fs.mybatis.mapper.ScenarioMapper.getScenariosByExtMethodIds]
2018-07-27 10:57:17,507 INFO  [stdout] (DEFAULT task-1) TRACE [] [] <==        ROW: 6, s_authn_spnego, urn:monetplus:mep:names:tc:SAML:2.0:ac:classes:Kerberos, ENABLED, 6, 0, s_authn_spnego, WEB, AUTHENTICATION, w_authn_spnego, 1, 1, muc_authn_spnego, SPNEGO, SPNEGO, SPNEGO, 0, AM_DPWD, AS SPNEGO, AS SPNEGO [cz.monetplus.mep.config.fs.mybatis.mapper.ScenarioMapper.getScenariosByExtMethodIds]
2018-07-27 10:57:17,507 INFO  [stdout] (DEFAULT task-1) DEBUG [] [] <==      Total: 1 [cz.monetplus.mep.config.fs.mybatis.mapper.ScenarioMapper.getScenariosByExtMethodIds]