Analyzing on SonarQube server 8.9.8
Java 11.0.11 AdoptOpenJDK (64-bit)
Linux 4.18.0-372.16.1.el8_6.x86_64 amd64
Query : We are attempting to scan a project based on the Redshift SQL dialect from SonarQube. Initially, the default PL/SQL scanner was used, but it only managed to scan a few views (2-3 SQL files out of 81). The majority of the files were not parsed by the scanner.
In an attempt to address this issue, I switched the parsing and tried using T-SQL. I made the following changes in the settings:
- For PL/SQL: Changed
- For T-SQL: Changed
As a result, more files were parsed this time. However, not all of the code was fully scanned, and numerous warnings were encountered while scanning database views and procedures.
WARN: Unable to parse file '/storedprocedures/applicant.sql' : Parse error at line 1 column 11: 1: create or replace procedure mysch.sapplicant(inbatchdate date) ^ 2: language plpgsql as WARN: Unable to parse file '/src/views/summary.sql' : Parse error at line 3 column 11: 1: -- noinspection AnnotatorForFile,Annotator 2: 3: create or replace view mysch.summary as ^
Please suggest how to tackle this situation. Is there any external plugin available which solve the purpose?
Thanks in advance.