JR35002: PRIMARY KEY ANALYSIS CLIENT ISSUES

APAR status

• Closed as fixed if next.

Error description

• 1. In Primary Key Analysis->Create Data Sample, the screen is
  
  initially displayed with Sample Size as 0. If the Sample Type
  "Sequential" is chosen, no error is displayed. However, no
  
  Sample is created and when you go back to the Primary Key
  Analysis screen the Sample Status column for that table has an
  "Error" indicator. If a non-zero Sample size is specified,
  the
  sample is successfully created.
  
  
  2. In Primary Key Analysis->Run Multiple Column Analysis->Create
  Data Sample-> for Random Sample (and I think Sequential and Nth
  Interval too), it seemed like it created the sample in most
  
  cases, but the UI would be stuck in the screen displaying
  
  "Sample Creation in Progress". The Options and Engine tabs on
  
  the screen were still disabled (correct behavior). If we closed
  the "Primary Key Analysis" window and re-opened it, the
  Sample
  would show up as Created and would be offered during MCPK.
  
  3. In Primary Key Analysis->MCPK screen, when you click
  
  Duplicate Check, it runs to completion, but you cannot view
  
  duplicate check, and completion of duplicate check does not
  
  register on interface. If you close out of the ?Open Primary Key
  Analysis? and come back in, then the duplicate check shows as
  
  completed and you can view the results. So, this appears to be
  
  another "refresh" issue with the UI.
  
  
  
  IA 8.1 RU5 on Windows Server 2005 with SQL Server 2005
  repository.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users specifying Sequential Sample Size as 0, or creating
  Samples or using Duplicate check.
  ****************************************************************
  PROBLEM DESCRIPTION:
  1. In Primary Key Analysis->Create Data Sample, the screen is
  initially displayed with Sample Size as 0. If the Sample Type
  "Sequential" is chosen, no error is displayed. However, no
  Sample is created and when you go back to the Primary Key
  Analysis screen the Sample Status column for that table has an
  "Error" indicator. If a non-zero Sample size is specified,
  the sample is created successfully.
  
  2. In Primary Key Analysis->Run Multiple Column Analysis->Create
  Data Sample - for Random Sample (and possibly Sequential and Nth
  Interval too), it seemed like it created the sample in most
  cases, but the User Interface would be stuck in the screen
  displaying "Sample Creation in Progress". The Options and
  Engine tabs on the screen were still disabled (correct
  behavior). If the "Primary Key Analysis" window was closed and
  re-opened, the Sample would show up as Created and would be
  offered for use during MCPK.
  
  3. In Primary Key Analysis->MCPK screen, when Duplicate Check
  is clicked it runs to completion, but you cannot view duplicate
  check, and completion of duplicate check does not register on
  the User interface. If the screen is closed and re-opened, then
  the duplicate check shows as completed and you can view the
  results. So, this appears to be another "refresh" issue with
  the UI.
  
  ****************************************************************
  RECOMMENDATION:
  Upgrade to Information Analyzer 8.1 Fix Pack 2, or
  Information Analyzer 8.1.1 Fix Pack 1, or Information Analyzer
  8.1.2 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R810 PSN

     UP