CAST HIGHLIGHT - Keyword Scan - The occurrences of the keywords are duplicated when scanning sql files – CAST

The Highlight agent is found to wrongly duplicate keywords when using Keyword Scan while analyzing sql files . This is because sql files are duplicated and in the .csv generated by the agent, it can be seen that it adds the suffix: EXTENDEDIDENT_1 to the .sql files which do not exist in the scanned folder.

Details and Workaround

Duplicates are created because Highlight can't deduce from the code automatically whether the code is PL/SQL or T-SQL. If the user or application owner is not aware about this it can result in duplication because

The user may have selected both technologies (PL/SQL and T-SQL) for the scan after the discovery step. The local agent scans corresponding files twice: one time with PL/SQL analyzer, one time with T-SQL analyzer.The local agent displays a recap of the analysis with both technologies (how many files scanned/skipped for each technology)
After confirmation from the user (last step), the local agent produces one CSV file for each technology
The user uploads these two CSV files. As a result, duplicates can be found on the dashboard.

This is a known limitation.

To avoid this issue the user should decide whether the code is PL/SQL or TSQL and should manually select the right technology after the discovery step.

In the command line, you can't exclude/deactivate a technology, however you can pass a list of technologies you want to explicitly analyze.

https://doc.casthighlight.com/product-tutorials-third-party-tools/automated-code-scan-command-line/

--technologies (optional)
 Technologies you want to explicitly scan in your sources. Separated by "," and sorted by preferences (See --printTechnos option above).

More details on how TSQL/PLSQL files are analyzed can be found here

CAST HIGHLIGHT - Local Agent - Discovery Step - Best Practices for Analyzing PL/SQL

CAST HIGHLIGHT - Local Agent - Discovery Step - Best Practices for Analyzing Microsoft T-SQL

CAST HIGHLIGHT - Local Agent - Discovery Step - Files that should be excluded from Analysis

CAST HIGHLIGHT - Analyzer - Analysis Step - Analysis proceeds with limited results