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
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)

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