Purpose (problem description)

This page explains the case when the Data Function is flagged as UNCHANGED in the evolution node, while there is change in the analyzed code source.

TCC:



Source code comparaison:


Observed in CAST AIP

Release

Yes/No

8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Observed in RDBMS

RDBMS

Yes/No

Oracle Server (tick)
Microsoft SQL Server (tick)
CSS3(tick)
CSS2 (tick)
Step by Step scenario
  1. Run analysis and take a snapshot.
  2. Run another analysis and take another snapshot.
Action Plan

Perform the below actions

  1. Get the checksum of the Data Function from the snapshots from where the Data Function is changed, for this refer to SQL Queries - CAST Central Base - Queries on Objects - How to get the checksum of an object in a given snapshot based on its full name
    1. If the Checksum of the Data Function is the same between the 2 snapshots:
      1. From the source code of Data Function, examine the change made between the 2 snapshot:
        1. If the change is made on the name of table or the name/type of one of the column of the table, then get the check sum of the table from the knowledge schema corresponding to each snapshot by following the page SQL Queries - CAST Knowledge Base - Queries on objects - How to get the checksum of an object
          1. If the Checksum of the table is the same between the 2 knowledge schema, then we need to investigate the issue on analyzer side - CMS Snapshot Analysis - Run Analyzer
          2. Else If the Checksum of the table is not the same between the 2 knowledge schema, then we need to investigate the issue on compute snapshot side - CMS Snapshot Analysis - Compute Snapshot
        2. Else If the change is not made on the name of table or the name/type of one of the column of the table, then it's expected to get UNCHANGED Data Function, For example, columns that have a change on the encoding storage should not change the checksum of the table:

    2. Else If the Checksum of the Data Function is not the same between the 2 snapshots, then the issue is related to TCC viewer, contact CAST Technical Support with the following Relevant input
  2. If the above steps do not solve your issue contact CAST Technical Support with the following Relevant input for CAST Technical Support to reproduce the issue with the following Transaction Configuration Center - Information - How to reproduce user issues

 

Notes/comments

Ticket # 13467

Related Pages