PM68732: Importing more than 99 definitions creates duplications and incorrect order in the SA browser in Oracle ency

APAR status

• Closed as Permanent restriction.

Error description

• Importing more than 99 definitions via Dictionary/Import it
  creates duplicate definitions and incorrect order in the SA
  browser in an Oracle database.
  
  
  How to reproduce:
  -----------------
  
  Oracle 11g Express server installed on the same machine as
  System Architect client.
  Rational System Architect 11.4.1.2
  
  How to reproduce:
  -------------------
  1- In an Oracle encyclopedia import a csv file with 100
  definitions any type from Dictionary/Import definitions.
  
  2- Expand the definition type from the SA browser and you will
  see incorrect order and duplicated definitions (only display no
  data duplication).
  
  3- Delete all the definitions imported and delete one definition
  in the csv file in order to have only 99.
  
  4- Import the csv file containing 99 definitions and note that
  the duplications are not reproducible and the order is correct
  from the SA browser.
  
  Workaround for duplicate definitions is to use these sa2001.ini
  settings:
  
  Add the following to the sa2001.ini file:
  
  [ADO]
  ADONLSComp=binary
  ADONLSSort=binary
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Importing more than 99 definitions via Dictionary/Import it
  creates duplications and incorrect order in the SA browser
  in an Oracle database. Not reproduced on SQL Server.
  
  The incorrect order displayed in the SA browser is is
  reproducible only when he try importing 100 or more
  definitions.
  
  If he imports 99 or less it is not reproducible and SA
  browser will show the appropriate order for the definitions.
  
  It is reproducible for the customer on the following
  scenarios:
  
  1) SA running on Hungarian OS.
  Oracle running on English OS.
  
  2) SA running on Hungarian OS.
  Oracle running on Hungarian OS.
  
  Note if SA is running on English OS, then it is not
  reproducible in any Oracle OS installation.
  
  Because customer is using Oracle 11g Express the
  NLS_LANG environment variable is set by default accordingly
  with the OS language.
  
  Workaround for duplicate definitions is to use these
  sa2001.ini settings:
  
  Add the following to the sa2001.ini file:
  
  [ADO]
  ADONLSComp=binary
  ADONLSSort=binary
  

Problem conclusion

• This issue has nothing to do with the number of items in the
  CSV file. It has to do with the order in which ORACLE sorts
  things based upon the NLS settings.
  
  Without changing the settings, in Hungarian Windows with
  English Oracle, the items are sorted in the ASCII table
  order: numbers first, followed by letters, followed by
  special letters.
  
  Using the following SA settings:
  [ADO]
  ADONLSComp=LINGUISTIC
  ADONLSSort=Hungarian
  
  the items are sorted as follows: special letters, letters
  and numbers.
  
  If this is not acceptable, refer to the following for more
  information on these parameters:
  
  http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch3glo
  benv.htm#i1008393
  http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.ht
  m
  
  
  The customer is happy with the solution (workaround) given,
  and understood how this works and happy with the results.
  This case will be closed.
  

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