PM46709: IBM Rational System Architect application crashes when ?Verify and repair? is ran on an encyclopedia.

APAR status

• Closed as Permanent restriction.

Error description

• Environment:
  
  SA Version: 11.4.0.3.309
  
  SQL Server 2005
  
  Description:  IBM Rational System Architect application crashes
  when ?Verify and repair? is ran on large encyclopedia.
  
  Impact: High
  
  Input:  NA
  
  Output: NA
  
  Expected results:  The maintenance activity on encyclopedia
  should take place successfully.
  
  Actual results:  Currently when the ?Verify and Repair? is ran
  on  encyclopedia, the System Architect application crashes
  without completing the activity. Thus unable to fix the data
  errors in encyclopedia.
  
  
  Steps to reproduce:
  
  1. Launch SA .
  2. Open an encyclopedia
  3. Navigate to Tools-? Verify Encyclopedia-?Verify and repair
  and start this activity for the encyclopedia.
  4. We find the application crashing during the ?Verify and
  Repair? activity.
  
  Workaround:
  
  Run Verify and Repair 1 pass at a time, instead of the default
  3:
  
  1. In the sa2001.ini file, under the
  [SystemArchitect] section add:
  
  VerifyAndRepairPasses=1
  
  2. Save the file
  3. Restart SA.
  4  Ran Verify and Repair
  5. Save the report.
  6. Close SA.
  7. Restart SA.
  8. Repeat steps 4-7 twice.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Verify and Repair on large encyclopedias fails after
  completing the first pass. The problem is the panel that
  displays the error/warning messages.
  
  If we let V?R run with several passes, the panel will run
  out of space about a third of the way into the 2nd pass.
  Unfortunately the panel does not handle the out-of-space
  gracefully but simply causes a crash. There is no workaround
  for the panel problem, and so it becomes mandatory to
  restrict the run to a single pass.
  

Problem conclusion

• We have a problem with SA's access to SQL Server.
  After each pass, V?R closes the encyclopedia and (in theory)
  SQL Server is supposed to release all its internal
  resources.
  The crash occurred because resources were not released at
  the end of the pass and SQL Server ran out of resources.
  
  The problem appears to be in the low-level database access
  functions, which means that the fix will be high-risk. Note
  that the client has a workaround, and it is suggested the
  issue be conceded.
  

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