PM81773: sadlg failed to create error on running verify and repair (1 Pass) on a large encyclopedia

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Environment: SA Version: 11.4.2.2.69
    
    SQL Server 2008 R2
    
    Description: IBM Rational System Architect application crashes
    when 1 pass of ?Verify and repair? is ran on a large client
    encyclopedia.
    
    Impact: High
    
    Expected results: The maintenance activity on the encyclopedia
    should take place successfully.
    
    Actual results: Currently when the ?Verify and Repair? is ran on
    the encyclopedia, the System Architect application crashes with
    the error:
    
    sadlg failed to create
    
    
    Steps to reproduce:
    
    1. In the sa2001.ini file, under the
    [SystemArchitect] section add:
    
    VerifyAndRepairPasses=1
    
    2. Save the file
    3. Restart SA.
    4. Restore and open the encyclopedia
    5. Navigate to Tools-? Verify Encyclopedia-?Verify and repair
    and start this activity for the encyclopedia.
    6. The error will occur.
    
    NOTE: Attempting to add UseServerCursor=Y in the
    [SystemArchitect] section of the sa2001.ini file did not help
    resolve the problem.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The client encyclopedia is too large for Verify ? Repair to
    work with as currently implemented. V?R asks the SQL Server
    DBMS to create a single recordset of ALL diagrams, symbols,
    and definitions in "one gulp". The error reported by the
    client was caused when SQL Server ran out of the "cursor
    space" needed to step through the huge recordset.
    

Problem conclusion

  • Verify and Repair should be rewritten so as not to stress
    SQL Server's "cursor space". Do diagrams first, then
    symbols, then definitions. Furthermore, definitions should
    be accessed piecemeal as smaller batches. Batches of 100,000
    should be OK, SA2001.INI can be used to provide an override.
    Contact Technical Support for this ini setting.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM81773

  • Reported component name

    TLOGIC SYS ARCH

  • Reported component ID

    5724V68SA

  • Reported release

    B30

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-31

  • Closed date

    2013-06-14

  • Last modified date

    2013-06-14

  • 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

    TLOGIC SYS ARCH

  • Fixed component ID

    5724V68SA

Applicable component levels

  • RB30 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Rational System Architect

Software version:

11.3

Reference #:

PM81773

Modified date:

2013-06-14

Translate my page

Machine Translation

Content navigation