Skip to main content
Kofax

MarkView Mail Gateway: Empty status notification emails generated when unused rule parameter value is not set.

Summary

4191

You may encounter the issue whereby empty status notification emails generated.

This occurs when the deprecated StatusEmail rule instance parameter is not is set for the 'MVT Global Periodic Status Upd' and/or 'MVT Global Ovr-Lmt Status Updt' workflow rules.

This issue only affects MarkView 5.10.X and above.

To determine if you have or will encounter this issue, run the following queries.

If it returns more than 0 rows:

select rt.rule_type_name, rpt.parameter_name
    from sf_rule_type rt, sf_rule_instance ri, sf_rule_parameter_type rpt
where rt.rule_type_id = ri.rule_type_id
    and rt.rule_type_id = rpt.rule_type_id
    and rt.rule_type_name in
        ('MVT Global Periodic Status Upd', 'MVT Global Ovr-Lmt Status Updt')
    and rpt.parameter_name = 'StatusEmail'
order by rt.rule_type_name, rpt.parameter_name;

and this query returns 0 rows:

select rt.rule_type_name, rpt.parameter_name, ripv.parameter_value
    from sf_rule_type rt, sf_rule_instance ri, sf_rule_parameter_type rpt,
sf_rule_instance_param_value ripv
where rt.rule_type_id = ri.rule_type_id
    and rt.rule_type_id = rpt.rule_type_id
    and rt.rule_type_name
        ('MVT Global Periodic Status Upd', 'MVT Global Ovr-Lmt Status Updt')
    and rpt.parameter_name = 'StatusEmail'
    and ri.rule_instance_id = ripv.rule_instance_id
    and rpt.rule_parameter_type_id = ripv.rule_parameter_type_id
order by rt.rule_type_name, rpt.parameter_name;

.... then this is an issue in your environment.

This is a known issue (25861) which will be addressed in a future release.

To workaround the issue, run the attached Fix25861.sql in the MarkView schema.

To confirm the issue is resolved, the following two queries should return the same number of rows after the Fix25861.sql is run:

(1) select rt.rule_type_name, rpt.parameter_name
    from sf_rule_type rt, sf_rule_instance ri, sf_rule_parameter_type rpt
where rt.rule_type_id = ri.rule_type_id
    and rt.rule_type_id = rpt.rule_type_id
    and rt.rule_type_name in
        ('MVT Global Periodic Status Upd', 'MVT Global Ovr-Lmt Status Updt')
    and rpt.parameter_name = 'StatusEmail'
order by rt.rule_type_name, rpt.parameter_name;

(2) select rt.rule_type_name, rpt.parameter_name, ripv.parameter_value
    from sf_rule_type rt, sf_rule_instance ri, sf_rule_parameter_type rpt,
sf_rule_instance_param_value ripv
where rt.rule_type_id = ri.rule_type_id
    and rt.rule_type_id = rpt.rule_type_id
    and rt.rule_type_name in
        ('MVT Global Periodic Status Upd', 'MVT Global Ovr-Lmt Status Updt')
    and rpt.parameter_name = 'StatusEmail'
    and ri.rule_instance_id = ripv.rule_instance_id
    and rpt.rule_parameter_type_id = ripv.rule_parameter_type_id
order by rt.rule_type_name, rpt.parameter_name;

Keywords: Bug 25861