IJ07404: WHEN SHARED DISCS DISCOVERY IS ENABLED, IMPORT FAILS IF THE SAME SHARED POINT IS MOUNTED TWICE ON A GIVEN COMPUTER

APAR status

• Closed as program error.

Error description

• If a computer in an infrastructure has the same shared disc
  mounted twice (for example in /mnt and /tmp), Discover Remote
  Shared  Disks fixlet has been run and Shared Disk Information
  analysis has been enabled import fails with the exception:
  2018-06-28 09:28:50 (+0:00:00.115) ERROR:  (ImportThread)
  SQLException -> Message       : batchUpdate
               -> SQL message   : The same row of target table
  "SAM.SHARED_DISKS_COMPUTERS_REL_TABLE" was identified more than
  once for an update, delete or insert operation of the MERGE
  statement.. SQLCODE=-788, SQLSTATE=21506, DRIVER=3.72.24
               -> SQL errorcode : -788
               -> SQL state     : 21506
  com.ibm.db2.jcc.am.SqlException: The same row of target table
  "SAM.SHARED_DISKS_COMPUTERS_REL_TABLE" was identified more than
  once for an update, delete or insert operation of the MERGE
  statement.. SQLCODE=-788, SQLSTATE=21506, DRIVER=3.72.24
   at com.ibm.db2.jcc.am.hd.a(hd.java:816)
   at com.ibm.db2.jcc.am.hd.a(hd.java:66)
   at com.ibm.db2.jcc.am.hd.a(hd.java:140)
   at com.ibm.db2.jcc.am.ip.b(ip.java:2455)
  

Local fix

• Enable partial import to skip the shared disc data and allow the
  imports to complete.
  
  
  Please make sure that you have the current BFI/LMT site
  version in BigFix Console:
  (site version 120 or higher for LMT / site version 114 or
  higher for BFI) which already contain a solution for the issue.
  
  In case you need the share disc data and the site update did
  not help, please use the following hot-fix:
  
  http://software.bigfix.com/download/tema/fixes/9.2.12.0/sharedDi
  sks/com.ibm.license.mgmt.dao.jar
  
  Please place this file in <LMT/BFI>\wlp\usr\servers\server1\lib
  Please restart the application after the change.
  
  Make sure that the original file is moved outside of wlp folder.
  

Problem summary

• ****************************************************************
  * ERROR DESCRIPTION:
  * If any computer in a infrastructure has the same shared disc
  * mounted twice (for example in /mnt and /tmp), import fails
  * with following exception:
  
  * 2018-06-28 09:28:50 (+0:00:00.115)
  * ERROR:  (ImportThread) SQLException -> Message : batchUpdate
  * -> SQL message   : The same row of target table
  * "SAM.SHARED_DISKS_COMPUTERS_REL_TABLE" was identified more
  * than once for an update, delete or insert operation of the
  * MERGE statement.. SQLCODE=-788, SQLSTATE=21506, DRIVER=3.72.24
  * -> SQL errorcode : -788
  * -> SQL state     : 21506 com.ibm.db2.jcc.am.SqlException:
  * The same row of target table
  * "SAM.SHARED_DISKS_COMPUTERS_REL_TABLE" was identified more
  * than once for an update, delete or insert operation of the
  * MERGE statement.. SQLCODE=-788, SQLSTATE=21506, DRIVER=3.72.24
  * at com.ibm.db2.jcc.am.hd.a(hd.java:816)
  * at com.ibm.db2.jcc.am.hd.a(hd.java:66)
  * at com.ibm.db2.jcc.am.hd.a(hd.java:140)
  * at com.ibm.db2.jcc.am.ip.b(ip.java:2455)
  * EXPECTED RESULTS:
  * The issue does not occur.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

• ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  
  PROBLEM CONCLUSION:
  
  The fix for this APAR is contained in the following maintenance
  packages:
   | Update | BFI 9.2.13
   | Update | ILMT 9.2.13
  

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