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

Subscribe

You can track all active APARs for this component.

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 number

    PM68732

  • Reported component name

    TLOGIC SYS ARCH

  • Reported component ID

    5724V68SA

  • Reported release

    B41

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-12

  • Closed date

    2013-06-05

  • Last modified date

    2013-06-05

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational System Architect

Software version:

11.4.1

Reference #:

PM68732

Modified date:

2013-06-05

Translate my page

Machine Translation

Content navigation