This page handle the case when you get the error "Error during evolution loading Internal exception Null pointer Exception" after loading Enhancement results:
Release | Yes/No |
---|---|
8.2.x | |
8.1.x | |
8.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Step by Step scenario
- Take a full snapshot
- Open TCC and load Enhancement results
Action Plan
- 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 - 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.
- To determine if you have this type of corruption, see if the following values in TCC are negative for deleted artifacts:
- If they are negative, then proceed with the following workaround. Otherwise, proceed to the next step in the action plan.
Install the following procedure on the central schema - APMCFP_DF_INFO_DELETED.sql, APMCFP_TRAN_INFO_DELETED.sql
- 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'.
- Go to Enhancement / Transaction , and push the button 'Recompute cheksums and snapshot statuses'.
- Once the recompute operation is done, close TCC
Reopen TCC and go to Enhancement node. The issue should now be fixed.
- To determine if you have this type of corruption, see if the following values in TCC are negative for deleted artifacts:
If this is not your case then please contact CAST Technical Support with the following relevant input
Ticket # 8987, 9784