OA46225: IQ IMPORT FAILED WHEN PROCESSING LKB ENTRIES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HSIC020E Inquisitor Import encountered errors. Error code =
  6636
  

Local fix

•  Delete and recreate of the LKB dataset
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM Tivoli Asset Discovery for z/OS      *
  *                 V8.1 customers.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Inquisitor Import failed with RC 8      *
  *                      with the following log messages:        *
  *                                                              *
  *                      =================================       *
  *                      unexpected values when getting          *
  *                      product key                             *
  *                      vendor key = 0, product name =          *
  *                      Error while retrieving the              *
  *                      version key.                            *
  *                      Unexpected values when retrieving       *
  *                      povinvid on key = 0, InvKey = 1         *
  *                      Error Retrieving the POVINVID           *
  *                      Error in call to                        *
  *                      CRepPOVLib::GetPOVLibKey().             *
  *                      Aborting Load.                          *
  *                      ERROR while migrating library           *
  *                      library modules                         *
  *                      =================================       *
  *                      HSIC020E error message and the          *
  *                      following error code in sysout:         *
  *                      Error code = 6636                       *
  *                      =================================       *
  ****************************************************************
  * RECOMMENDATION: N/A                                          *
  ****************************************************************
  When the LKB is updated with records for products and
  versions that were previously scanned, the updates could
  incorrectly cause orphaned records.
  
  The orphaned records can be determined by running the
  following query:
  
  SELECT * FROM lkbschema.TSCORPAT AS SC
  WHERE NOT EXISTS
   (SELECT 1 FROM lkbschema.TVERSION AS VR
    WHERE VR.FPOVID=SC.FPOVID);
  
  WHERE lkbschema is the name of the LKB schema.
  

Problem conclusion

• Updates will now no longer cause orphaned records.
  
  Note that this change is to prevent future corruption of
  the LKB TSCORPAT table and does not fix existing corruption.
  Existing orphaned records can be identified by issuing the SQL
  statement as described in the Problem Description section.
  
  If symptoms of this problem exist after applying this PTF
  you can either delete and repopulate the LKB, or delete
  orphaned records by modifying the given SQL statement to
  perform a delete.
  

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:

  UA75221

Modules/Macros

•    HSICIQIM
  

Fix information

• Fixed component name

  TIV ASSET DISC

• Fixed component ID

  5698B39TD

Applicable component levels

• R810 PSY UA75221

     UP14/10/29 P F410

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.