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 | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 |
Step by Step Scenario
- Run Analysis
- 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 :
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.
- Run the analysis
- 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