IV33712: EMPTY KFWHISTDATA CAUSES DUPLICATE UADVISOR

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  
  When running multiple TEPS connected to the same HUB and
  importing the TEPS database from a primary TEPS to a "read only"
  TEPS appears to cause duplicate UADVISOR situations on the HUB.
  
  RECREATE INSTRUCTIONS:
  1.  With 2 TEPS connected to the same HUB.
  2.  Run migrate-export to backup the primary TEPS that has no
  KFWHISTDATA table.
  3.  Take the saveexport.sql output from that and use it as input
  to a migrate-import on a secondary "read only" TEPS.
  4.  After completion of the migrate-import, the TEPS database on
  the "read only" TEPS will have an empty KFWHISTDATA table.
  
  It is still unclear how this causes duplicate UADVISOR
  situations, but customer insists this is the result.
  

Local fix

• Update export.parms to remove the KFWHISDATA table definition.
  
  
  Under the TEPS sqllib directory:
  1) Edit the export.parms file and change all references for
  KFWHISTDATA to KFWHISTDATABAK.
  
  2) Edit the export.parms file changing the two KFWHISTDATA
  entries to KFWHISTDATABAK,
  
  3) Edit the seed-4.sql file changing the one table name entry
  for KFWHISTDATA to KFWHISTDATABAK.
  

Problem summary

• When running multiple TEPS connected to the same HUB and
  importing the TEPS database from a primary TEPS to a "read only"
  TEPS appears to cause duplicate UADVISOR situations on the HUB.
  

Problem conclusion

•  DETAILS PENDING
  The fix for this APAR is included in the following maintenance
  vehicle:
  | fix pack | 6.2.3-TIV-ITM-FP0004
  

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

  TEPS

• Fixed component ID

  5724C04PS

Applicable component levels

• R622 PSY

     UP

• R623 PSY

     UP