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

Rational System Architect Fix Pack 4 (11.4.2.4) for 11.4.2

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 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