Purpose (problem description)
This guide gives the approach to troubleshoot wrong / incorrect links found by the Reference Pattern applied to dependencies
Release | Yes/No |
---|---|
8.3.x |
RDBMS | Yes/No |
---|---|
CSS |
- Run Analysis
- Create reference pattern
- Run Reference pattern
- Open the Dynamic Link Manager
- See links that you do not expect
Proceed with the below steps:
- If the target is T-SQL Technology (Microsoft SQL Server), then check that you refined the target
If the source is a UA Technology, then check if the links are part of commented code
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 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)
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,
Issue
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>
Remediation
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