JR33139: INFORMATION SERVER 8.1 - ISSUE WITH IMPORTING SYBASE METADATA; ERRONEOUS KEY INFORMATION GENERATED

APAR status

• Closed as program error.

Error description

• Information Server 8.1 - issue with importing Sybase
  metadata; erroneous key information generated
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All pltaforms, jobs using Sybase Plugin Metadata import
  ****************************************************************
  PROBLEM DESCRIPTION:
  SybaseOC imports key columns incorrectly.
  ****************************************************************
  RECOMMENDATION:
  Install patch for JR33139
  The fix has been included in the IS 8.1 FP1. Apply the FixPack1
  for IS 8.1.
  ****************************************************************
  

Problem conclusion

• SybaseOC metadata was using sp_statistics to get key columns.
  This returns all indexes on the table instead of just primary
  key.
  
  Modified code to use sp_pkeys to get the primary key column of
  aSybase ASE table.
  

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:

Modules/Macros

• SYBASEOC
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP