IJ39691: COMPUTER RECONCILIATION NOT WORKING. SQL ERRORCODE: -206 ERROR IN IMPORT LOG

APAR status

• Closed as program error.

Error description

• The issue occurs if you enable the computer_reconciliation_mode
  setting on Management > Advanced Server Settings panel in ILMT
  and at least one datasource configured is in version 9.2 or 9.5
  below patch 5 of BigFix.
  The error causes the reconciliation feature to not work on that
  particular datasource (so the endpoints moved to that
  datasource won't be reconciled with the endpoints already
  present in the ILMT).
  
  
  
  
  
  
  
  
  
  
  
  
  
  TS007489575
  

Local fix

• Upgrade the offending datasource to BigFix version at least 9.5
  patch 5. This issue does not affect reconciliation to other
  datasources though, so it can be neglected if that feature is
  not required to work on the affected datasource.
  

Problem summary

• ****************************************************************
  *****************
  ERROR DESCRIPTION:
  
  The issue occurs if you enable the computer_reconciliation_mode
  
  setting on Management > Advanced Server Settings panel in ILMT
  
  and at least one datasource configured is on one of the early
  
  patches of 9.2 or 9.5 version below patch 5 of BigFix.
  
  The error causes the reconciliation feature to not work on that
  
  particular  datasource (so the endpoints moved to that
  
  datasource  won't be reconciled with the endpoints already
  
  present in the ILMT).
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  TS007489575
  
  ****************************************************************
  *****************
  * EXPECTED RESULTS:
  * The issue does not occur.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

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

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

  LIC METRIC TOOL

• Fixed component ID

  5724LMTEM

Applicable component levels