IJ05768: MIGRATION TO BFI 9.2.11 MAY FAIL ON PROCESSING 1518706193_ICEBERG_ULTIMATE_PROV_INV_DETAILS_PART3

APAR status

• Closed as program error.

Error description

• In case of large environments (more than 3 million files used
  for detection of software) the upgrade may fail on the following
   statement:
  
            insert into sam.versions (id, version)
            select
              distinct ff.version_id as id,
                ff.version COLLATE SQL_Latin1_General_CP1_CS_AS as
              version
              from sam.file_facts_scd ff where id in (select id
              from ##file_facts_to_process)
                and version is not null
                and not exists (select 1 from sam.versions v where
              v.id=ff.version_id)
  
  with a similar exception:
  
  
  Sequel::DatabaseError (DBNAME: temadb -
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot
  insert duplicate key row in object 'sam.versions' with unique
  index 'sam_versions_version_index'. The duplicate key value is
  ().):
  
  In order to verify if your environment is affected, please
  execute the following query on temadb (BFI database):
  
  select case when tmp.c > 3000000 then 'Affected' else 'Not
  affected' end from
   (select
          count(distinct ff.id) as c
        from sam.signature_matches_scd sms
        inner join sam.signature_roots s on sms.signature_id =
  s.root_id
        inner join sam.software_components comp on comp.guid =
  s.discoverable_guid
        inner join sam.file_rules fr on s.id = fr.signature_id
        inner join sam.file_rule_matches_persistent frmp on fr.id
  = frmp.file_rule_id
        inner join sam.file_rule_matches_scd frms on frms.id =
  frmp.id and frms.computer_id = sms.computer_id and frms.valid_to
  = '9999-12-31 23:59:59.997'
        inner join sam.file_facts_scd ff on frms.computer_id =
  ff.computer_id and frmp.file_fact_id = ff.id and ff.valid_to =
  '9999-12-31 23:59:59.997') as tmp
  

Local fix

• Technote will be written to document workaround and document
  here when completed
  

Problem summary

• ****************************************************************
  
  * ERROR DESCRIPTION:
  *
  * ENV: Windows 2012 R2, Migration from 9.2.9 to 9.2.11
  *
  * In case of large environments (more than 3 million files used
  *
  * for detection of software) the upgrade may fail on the followi
  *
  *  statement:
  *
  *
  *
  *           insert into sam.versions (id, version)
  *
  *           select
  *
  *             distinct ff.version_id as id,
  *
  *               ff.version COLLATE SQL_Latin1_General_CP1_CS_AS
  *
  * version
  *
  *             from sam.file_facts_scd ff where id in (select id
  *
  * from ##file_facts_to_process)
  *
  *               and version is not null
  *
  *               and not exists (select 1 from sam.versions v whe
  *
  * v.id=ff.version_id)
  *
  *
  *
  * with a similar exception:
  *
  *
  *
  *
  *
  * Sequel::DatabaseError (DBNAME: temadb -
  *
  * Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot
  *
  * insert duplicate key row in object 'sam.versions' with unique
  *
  * index 'sam_versions_version_index'. The duplicate key value is
  *
  * ().):
  *
  * **************************************************************
  *
  * EXPECTED RESULTS:
  * The issue does not occure.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
   | Update | BFI 9.2.11.1
   | Update | ILMT 9.2.11.1
  ****************************************************************
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IEM SW USE ANL

• Fixed component ID

  5725F57MT

Applicable component levels