Purpose (problem description)

Purpose (problem description)

This guide gives the approach to troubleshoot wrong / incorrect links found by the Reference Pattern applied to dependencies

Observed in CAST AIP
Release
Yes/No
8.3.x(tick) 
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)
Step by Step scenario
  1. Run Analysis
  2. Create reference pattern
  3. Run Reference pattern
  4. Open the Dynamic Link Manager
  5. See links that you do not expect
Action Plan

Proceed with the below steps:

  1. If the target is T-SQL Technology (Microsoft SQL Server), then check that you refined the target
  2. If the source is a UA Technology, then check if the links are part of commented code

  3. If you do not find the information you are looking for a solution for your problem,  contact CAST Technical Support, with the below Relevant Input

 

For T--SQL technology, use a Refined Target

 For SQL server databases,  the DLM creates a link for SQL table columns which is not expected to be created.

This can happen if the application has been added with a Reference Finder which targets all the SQL server objects.

For example: If a reference finder is created between ASP to SQL objects, and if the Refined Target is targeting the SQL Server technology, then all the SQL Server objects are targeted (Tables, Views, Columns …)

 

To fix the problem, proceed as follows:

 

If you want to target all objects but not table columns, you can filter the refined target by selecting all the SQL Server object types but not table columns.  

 

1) Go to Dependencies tab.

2) Select the Rule targeting SQL Objects.

3) Click Refine target.

 

 

4) Go to Type Selection and enable "Filter on object Types"


5) Add all the objects which you would like to include (for example Tables, Views, Procedures)

 


UA Technology : links from commented code

If the source is an UA language, links are made in commented code even when option "search in comments" is not activated in the reference finder,

The reason of this is that when Reference finder reads the code of the files, it trims each line.
Therefore the regular expression is false for RF, and the comment is considered as code.

Below description of comments is the root cause of the problem:

<comment>
<begin><![CDATA[[ ][ ][ ][ ][ ][ ][ ][ ][ ]DESCRIPTION[ ][ ][ ][ ][ ][ ][ ][ ][ ]]]></begin>
<end><![CDATA[<]]></end>
<nested>false</nested>
<multiline>true</multiline>
</comment>

Repalace above definition of comments with below :

<comment>
<begin><![CDATA[DESCRIPTION]]></begin>
<end><![CDATA[<]]></end>
<nested>false</nested>
<multiline>true</multiline>
</comment>

or

<comment>
<begin><![CDATA[DESCRIPTION[ \t\r\n]*-----------]]></begin>
<end><![CDATA[<]]></end>
<nested>false</nested>
<multiline>true</multiline>
</comment>

there are no more false links

Notes/comments
Ticket: # 4632