Description

After analysis there is a missing Link from ColdFusion Query to Oracle Table.

 

Coldfusion is custom so it is not supported by CAST support.

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)
7.2.x(tick)
7.0.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(tick)
CSS2(tick)
CSS1(tick)
Step by Step Scenario
  1. Run Analysis
  2. Check in Enlighten
Action Plan

The cause of this issue is that the Teradata Oracle Extraction is Wrong.

There is no Teradata table attached to the instance, because no schema is attached to the instance.

You have to correct your Teradata Extraction :

  1. Open DatabaseSchema.X.uax in file editor, there is :

    <CAST_Symbol_WithParent parent="DatabaseInstance"/>
    DatabaseInstance must be replaced by the Teradata Instance name :
    <CAST_Symbol_WithParent parent="Teradata_Instance"/>

    By doing the above, the schema will be linked to the Instance.

  2. Run the analysis
  3. Check in enlighten whether the links are there.
Impact on Analysis Results and Dashboard

Impact of issue: No issue in Analysis
Impact after applying solution: Analysis runs fine.

Notes/comments

Ticket # 3704

Cold Fusion is a field extension which is not supported by CAST AIP

Related Pages