Transaction Configuration Center - Enhancement - Load Enhancement results - Error - Error during evolution loading Internal exception Null pointer Exception

Purpose (problem description)

This page handle the case when you get the error “Error during evolution loading Internal exception Null pointer Exception” after loading Enhancement results:

Observed in CAST AIP

Observed on RDBMS

Step by Step scenario

1. Take a full snapshot
2. Open TCC and load Enhancement results

Action Plan

1. Check in the central base if you have a transaction that is transformed to a Data Function or a Data Function that is transformed to a Transaction, for this please refer to the following pages:
   SQL Queries - CAST Central Base - Corruptions on Transactions - Transaction transformed to Datafunction
   SQL Queries - CAST Central Base - Corruptions on Data Function - Datafunction transformed to Transaction
   If not then go to the next step, else note that this is a corruption, a scenario that can lead to this corruption can be the following:

   Setup OBJECT_A as entry point
   Take snapshot SN1 –> OBJECT_A is sent to the central database with a transaction the form
   Drop SN1
   DROP the SETUP which wad related to the OBJECT_A
   Setup OBJECT_A as Data Entity
   Generate again the snapshot SN1 –> OBJECT_A is sent to the central database with the form Data Functoin
   we’ll found the OBJECT_A as Transaction and Data function !!!
   Please refer to the above pages for remediation. This issue is fixed in Service Pack 8.2.4

2. Not all the corruption cases were fixed in 8.2.4.  Other corruptions have been seen and will be fixed in a later version of CAST.

   1. To determine if you have this type of corruption, see if the following values in TCC are negative for deleted artifacts:
      
   2. If they are negative, then proceed with the following workaround.  Otherwise, proceed to the next step in the action plan.
      1. Install the following procedure on the central schema - APMCFP_DF_INFO_DELETED.sql, APMCFP_TRAN_INFO_DELETED.sql
      2. Connect to TCC and go to Enhancement node (the error will still be present at this point) , but then go to Enhancement / Datafunction , and push the button ‘Recompute cheksums and snapshot statuses’. 
      3. Go to Enhancement / Transaction , and push the button ‘Recompute cheksums and snapshot statuses’. 
         
      4. Once the recompute operation is done, close TCC
      5. Reopen TCC and go to Enhancement node.  The issue should now be fixed.

3. If this is not your case then please contact CAST Technical Support with the following relevant input

Notes/comments

Ticket # 8987, 9784

Related Pages