BUG in Exceptions API - doesn't care about Application Items

[al-hexagon]

Line 529 / 530 - missing shared components.

      --fetch new component_id and construct l_dest_ora_hash
      begin
        select r.component_id,
              ora_hash(
              (select rule_key
               from rules
               where rule_id= r.rule_id
               and apex_version = l_apex_version
              ) ||
              r.page_id ||
              r.component_name ||
              r.column_name ||
              r.item_name ||
              r.shared_comp_name ||
              r.current_value
              ) as orahash,
              r.current_value
        into l_dest_component_id, l_dest_ora_hash, l_current_value
        from sert_core.eval_results_v r
        where application_id = l_application_id
        and nvl(page_id,-1) = nvl(x.page_id,-1)
        and nvl(item_name,'N/A') = nvl(x.item_name,'N/A')
        and nvl(column_name,'N/A') = nvl(x.column_name,'N/A')
        and rule_set_id = l_rule_set_id
        and nvl(component_name,'N/A') = nvl(x.component_name,'N/A')

AND nvl(shared_comp_name, 'N/A') = nvl(x.shared_comp_name, 'N/A')

        and rule_id = l_rule_id;

is missing the shared components:

[miklpotter]

added to backlog

[miklpotter]

@al-hexagon
Hi Andreas,
do you have any specific rules that fail to be imported? I've tried a few and they successfully export and import back in without issue. If you have a scenario that is problematic i'd like to replicate it to verify.
Mik

[al-hexagon]

Yes - if you have an exception for an global application item for not having turned on escape-mode.

Anyhow - if you don't have this line added, i guess all shared components will be missed during import of exceptions because the component_name is null, column_name is null etc.

If you now have multiple shared components you'll get an "Query returns more than one row" exception during import.

Please give me a few days and i'll add the exceptions logs of the import.